topic Add data from Excel spreasheet not working in ArcMap 10 since upgrade to Windows 7 in ArcGIS Online Questions

Add data from Excel spreasheet not working in ArcMap 10 since upgrade to Windows 7

KimberlyWereley — Mon, 02 Apr 2012 16:21:23 GMT

In addition to other problems since my work computer was upgraded to Windows 7, I am no longer able to add data via excel 2010 spreadsheet.

I add my Excel 2010 spreadsheet, which then asks me to select which sheet (usually shows as 'Sheet 1$'), and I make sure the correct coordinate system is showing and that X and Y are selected correctly, but once that???s added the attribute table is empty. I've tried changing the name of the sheet and it doesn't make a difference.

I have to send the Excel file to someone else and have them convert to a shapefile and send that back to me for me to map my events.

Any help would be much appreciated!

Re: Add data from Excel spreasheet not working in ArcMap 10 since upgrade to Windows

HardolphWasteneys — Mon, 02 Apr 2012 17:55:49 GMT

This is Normal: You need to export the data from the layer file created by the ADD XY tool in order to have a populated attribute table. Just right click on the layer select DATA then export Data and create a shapefile from that.

The xy points should have plotted out when you use the ADD XY tool.
If not you may have formatting issues, but not likely if you've successfully done this before. Anyway, saving the xls file in csv format will help as well as checking to be sure you have numeric contents in the first 6 rows in the excel file.

Hardolph

Re: Add data from Excel spreasheet not working in ArcMap 10 since upgrade to Windows

KimberlyWereley — Mon, 02 Apr 2012 18:14:48 GMT

Wow that worked! And I can stop relying on my coworker to assist.

Thank you so much!