I am trying to add an excel table to a map in ArcGIS Pro. It is a 2010 excel file. Simple no macros or anything. It won't load. I have tried everything from the help menu. Am I having problems because we only have ArcGIS Pro 2.1??? I have attached the excel file I am trying to use.
Maybe save your .xlxs as .xls and try it.....
Good habit to have!
I've made it a habit to always convert Excel to tables rather than trying to work with Excel natively. Just too much possibility for flakiness otherwise.
field names shouldn't begin with numbers
you had a whole load of 'errors' in the T_Flag column. I 'fixed' those by copying to a new field defined as 'Text', then copied the values back over the original field (so CHECK THEM!!! )
But Excel To Table in ArcGIS Pro worked
see the attached. I called it 'stuff', so as not to confuse it with the original.
That was it. I was wondering if I should do that. Thanks for the help. I don’t like excel either.
Michelle Couden
Cartographer
Certified GIS Analyst
TPP Wellness Contact
Transportation Planning and Programming
Traffic Analysis Section
(512)486-5136
Watch for Cyclists!
That failed as well. I am thinking of checking me table for spaces. That would cause errors. Can you think of anything else.
Have you tried using the Excel To Table tool? When I try to add your excel spreadsheet to a 2.3 ArcGIS Pro session I get:
However, If I convert it to a table first, the new table comes in just fine.
Work with Microsoft Excel files in ArcGIS Pro—Excel | ArcGIS Desktop
Personally, I have a love/hate relationship with excel: I love to hate it.....
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
