AnsweredAssumed Answered

Coordinate conversion

Question asked by CCweedcontrol on Apr 18, 2017
Latest reply on Apr 18, 2017 by CCweedcontrol

So i was given a excel. xls table with Lat and Long of decimal degrees minutes and i need to import it into ArcMap. I am needing to convert them to decimal degrees in order to import it into ArcMap. How can i convert this table the entire table to decimal degrees. I tried using the Add XY Data but when i select the file nothing happens, do i also need to convert the table certain format before add it to arcmap?  Can this be done through arcmap or field calculator? I would appreciate any help.

 

 The table is populated as following

LongLat
-116 37.86343 41.353

Outcomes