topic Excel Tables in ArcGIS Pro in ArcGIS Pro Questions

Excel Tables in ArcGIS Pro

MichelleCouden — Thu, 21 Feb 2019 14:36:21 GMT

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.

Re: Excel Tables in ArcGIS Pro

JoeBorgione — Thu, 21 Feb 2019 14:47:33 GMT

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

Re: Excel Tables in ArcGIS Pro

MichelleCouden — Thu, 21 Feb 2019 15:17:53 GMT

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!

Re: Excel Tables in ArcGIS Pro

JoeBorgione — Thu, 21 Feb 2019 15:20:21 GMT

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

Re: Excel Tables in ArcGIS Pro

MichelleCouden — Thu, 21 Feb 2019 15:28:05 GMT

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!

Re: Excel Tables in ArcGIS Pro

JoeBorgione — Thu, 21 Feb 2019 15:36:01 GMT

Seems like using Excel in Pro is hit or miss.

Re: Excel Tables in ArcGIS Pro

DanPatterson_Retired — Thu, 21 Feb 2019 15:40:02 GMT

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.

Re: Excel Tables in ArcGIS Pro

DanPatterson_Retired — Thu, 21 Feb 2019 16:58:13 GMT

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

Re: Excel Tables in ArcGIS Pro

JoeBorgione — Thu, 21 Feb 2019 17:11:09 GMT

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

Re: Excel Tables in ArcGIS Pro

MichelleCouden — Fri, 22 Feb 2019 14:54:00 GMT

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!

Re: Excel Tables in ArcGIS Pro

JayJohnsonWashoeCounty — Fri, 22 Feb 2019 14:58:53 GMT

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.

Re: Excel Tables in ArcGIS Pro

JoeBorgione — Fri, 22 Feb 2019 18:51:57 GMT

Good habit to have!