lyndy

Importing Lat/Long Formats into GIS

Discussion created by lyndy on Apr 5, 2012
Latest reply on Apr 6, 2012 by GrizJohnson
Hi,

I understand that it's not possible to import degrees, minutes, and seconds format of lat/long into ArcGIS. I have a client who has all their data in an Excel spreadsheet in degrees, minutes, seconds.

First, may I just confirm that it's not possible to import degrees, minutes, seconds format into ArcGIS.

Second, what is the best way to convert the data in Excel?  I have written a function that converts the data for the client so that it may be imported into ArcGIS. But I am not sure if this is the most efficient way to handle the problem. They seem reticent to collect the data in decimal degrees because they have always been collecting the data in degrees, minutes, seconds.

Any advice?

Regards,
Lyndy

Outcomes