AnsweredAssumed Answered

Issue with exporting Excel to Shapefile - INCORRECT lat and long

Question asked by geonetadmin on Oct 20, 2013
Latest reply on Oct 21, 2013 by geonetadmin
Original User: stevens.a.eliz

I'm trying to export data found in an Excel file to a point shape file and regardless how I approach the task, I always seem to end up with the same result. The spreadsheet is transformed into a point shapefile and in Preview (ArcCatalog) looks correct, but when I add it to ArcMap, instead of the points appearing at the decimal degrees listed in the Excel sheet, they are all at a miniature scale (see picture). When I add a basemap and zoom out to a world-view, all the points appear to be in the same place, further indicating the tiny scale at which it is rendering.

My new shapefile is projected at WGS_1984_World_Mercator

This might be a fairly obvious fix but I've tried everything I can think of - changing the file type of the saved Excel, changing the cell formats of the Lat and Long data, converting in ArcCatalog and in ArcMap and the results are always the same.

Thank you.

Outcomes