Excel Tables in ArcGIS Pro

[MichelleCouden]

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.

[JoeBorgione]

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.....

[MichelleCouden]

That failed as well. I am thinking of checking me table for spaces. That would cause errors. Can you think of anything else.

Michelle Couden

Cartographer

Certified GIS Analyst

TPP Wellness Contact

Transportation Planning and Programming

Traffic Analysis Section

(512)486-5136

Watch for Cyclists!

[JoeBorgione · Accepted solution]

Maybe save your .xlxs as .xls and try it.....

[MichelleCouden]

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!

[JoeBorgione]

Seems like using Excel in Pro is hit or miss.

[DanPatterson_Retired]

It is more strict on spreadsheet errors... see my last post below

[JoeBorgione]

Yeah... When it initially failed I didn't even bother looking at the field names...

[MichelleCouden]

Thanks Dan. This spreadsheet came from an internet based program we have and I figured there were errors in it.

Michelle Couden

Cartographer

Certified GIS Analyst

TPP Wellness Contact

Transportation Planning and Programming

Traffic Analysis Section

(512)486-5136

Watch for Cyclists!

[JayJohnsonWashoeCounty]

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.