Excel Tables in ArcGIS Pro

2144
11
Jump to solution
02-21-2019 06:36 AM
MichelleCouden
Occasional Contributor

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.

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
JoeBorgione
MVP Emeritus

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

That should just about do it....

View solution in original post

11 Replies
JoeBorgione
MVP Emeritus

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

That should just about do it....
MichelleCouden
Occasional Contributor

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!

0 Kudos
JoeBorgione
MVP Emeritus

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

That should just about do it....
MichelleCouden
Occasional Contributor

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!

0 Kudos
JoeBorgione
MVP Emeritus

Seems like using Excel in Pro is hit or miss.

That should just about do it....
0 Kudos
DanPatterson_Retired
MVP Emeritus

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

0 Kudos
JoeBorgione
MVP Emeritus

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

That should just about do it....
0 Kudos
MichelleCouden
Occasional Contributor

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!

0 Kudos
JayJohnsonWashoeCounty
Occasional Contributor III

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.

Jay
Washoe County GIS