topic Adding an Excel Table to ArcGIS Pro... is it possible? in ArcGIS Pro Questions

Adding an Excel Table to ArcGIS Pro... is it possible?

BenVan_Kesteren1 — Tue, 09 Dec 2014 22:20:31 GMT

Hi all,

I am playing around in ArcGIS Pro Pre-release and I am unable to work out how to add a table from excel to a map??? In ArcDesktop it was very straight forward, but it is not so straightforward in Pro...

Anyone done this simple task before?

Thanks

Re: Adding an Excel Table to ArcGIS Pro... is it possible?

JoshuaBixby — Wed, 10 Dec 2014 01:50:45 GMT

From a post 6 months ago in the ArcGIS Beta Community forums:

Kent Marten wrote:
This is expected as direct read of Excel worksheets (or Named Ranges) as tables is not planned to be supported during the first release of ArcGIS Pro.

Re: Adding an Excel Table to ArcGIS Pro... is it possible?

StephenLead — Fri, 12 Dec 2014 04:56:05 GMT

This is a little bit mind-boggling to me. I remember the weeping and group-hugs when they announced Excel support for ArcMap at the UC a few years ago.......

Re: Adding an Excel Table to ArcGIS Pro... is it possible?

ThomasMisek — Thu, 05 Mar 2015 20:08:23 GMT

I agree. Thanks for the bad news.

I hope that this will be something like the command line in ArcGIS and be added sooner rather later. This alone may keep people away from ArcPro until resolved.

Re: Adding an Excel Table to ArcGIS Pro... is it possible?

Robert_LeClair — Fri, 27 Mar 2015 21:59:18 GMT

Excel is supported at ArcGIS Pro 1.1 which is expected to be released this summer.

Re: Adding an Excel Table to ArcGIS Pro... is it possible?

JackHunt — Wed, 08 Apr 2015 19:56:46 GMT

A current workaround for this (until 1.1 is released) is to convert your xlsx table to csv and perform either of the following steps:

Add Data -> click ‘Data’ -> Select desired table -> Right click table once it appears in TOC and select ‘Display XY Data' -> Run the GP tool
Add Data dropdown -> click ‘XY Event Data’ -> Select the desired table -> Run the GP too

Re: Adding an Excel Table to ArcGIS Pro... is it possible?

curtvprice — Fri, 01 May 2015 02:12:01 GMT

Excel is a great analysis environment but a really bad database. Just say no!

Re: Adding an Excel Table to ArcGIS Pro... is it possible?

BenVan_Kesteren1 — Fri, 01 May 2015 06:41:29 GMT

I understand your comment, but not every client/customer/peer I have contact with has access to some form of GIS.

I think Excel is a wonderful medium to transfer data between myself and the rest of the world, and it should most definately be supported completely moving forward.