Adding Excel data to ArcMap

3462
19
Jump to solution
12-07-2016 10:36 AM
TheodoreRakel
Occasional Contributor

I'm using Arc Map 10.2.1.  I have an Excel spreadsheet with two sheets in it.  One sheet I can bring into Arc Map without a problem and the other I cannot.  They aren't much different.  Here are some screen shots of the Excel sheets and the data in Arc Map.  Does anyone know why the second sheet does not come into Arc Map properly?  I've read the topics in Formatting a table in Microsoft Excel for use in ArcGIS—Help | ArcGIS for Desktop and can't see what is wrong.

Excel sheet 1

After bringing sheet 1 into Arc Map, here's the attribute table for Sheet1

Excel sheet 2

After bringing sheet 2 into arc map, here's the attribute table for Sheet2.  Notice the fields are all null

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
JayantaPoddar
MVP Esteemed Contributor

The spaces in the Field Names (in Excel Sheet) may be causing the issue. Make sure there is no space in the Field Name (both before and after the FieldName text).



Think Location

View solution in original post

19 Replies
JoeBorgione
MVP Esteemed Contributor

Any chance you could include a few rows of each sheet here so we can give it a try?

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

The excel file is attached.

0 Kudos
JayantaPoddar
MVP Esteemed Contributor

The spaces in the Field Names (in Excel Sheet) may be causing the issue. Make sure there is no space in the Field Name (both before and after the FieldName text).



Think Location
Robert_LeClair
Esri Frequent Contributor

I'm working with ArcMap 10.4.1 and am able to bring in the data as an XY event layer.  Question for you - what coordinate system are the numbers?  State Plane?  UTM?  Any details would be greatly appreciated.

TheodoreRakel
Occasional Contributor

NAD_1983_UTM_Zone_12N

Jayanta is correct, you can't have spaces before or after the field names

0 Kudos
MelitaKennedy
Esri Notable Contributor

Just wondering, UTM using feet for the units, correct?

Thanks!

Melita

0 Kudos
TheodoreRakel
Occasional Contributor

correct

0 Kudos
JoeBorgione
MVP Esteemed Contributor

That's downright weird.  Using 10.3.1 I can open it at all as an xlxs, but I can as an xls, but that #2 work book is all null.  Tried it in 10.0 and same thing.

I copied the contents of #2 into #1 and that worked.  Beats me though....

edited moments later:  Good Catch Jayanta-  Didn't notice them!

That should just about do it....
0 Kudos
PROBERT68
Regular Contributor III

Yes, ArcGIS 10.3.1 does not like xlsx. So, I made a copy of it to .xls

Then Open ArcCatalog and I was able to view it.

Export it as a .dbf file and add it as NAD_1983_UTM_Zone_12N.

Open ArcMap and add the file to it.

You need to re-export it to shapefile.

I'm using ArcGIS 10.3.1. 

Did you do this method ?

0 Kudos