AnsweredAssumed Answered

Adding Excel data to ArcMap

Question asked by tedrakel_power on Dec 7, 2016
Latest reply on Dec 13, 2016 by jayanta.poddar

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

Outcomes