Global Mapper v25.0

Lat-Lon Excel - to - csv

3dvr_m4
3dvr_m4 Global Mapper UserTrusted User
edited October 2012 in Vector Data
I have an Excel file with coordinates in this format and would like to change the format to something that I can import into GlobalMapper. Each is in a seperate column in Excel.

19 26 16 99 11 52
19 26 27 99 12 2
19 26 28 99 12 12
19 26 58 99 12 52
19 25 44 99 12 30

Comments

  • global_mapper
    global_mapper Administrator
    edited October 2012
    I assume those are degree, minute, second coordinates? If so, if you can do the math to turn those into 2 columns of decimal degree that would be the easiest way. Your formula would basically be degrees + ( minutes / 60 ) + ( seconds / 3600 ) for each one (negatives get a bit harder). Then you could save as a CSV and load using the File->Open Generic ASCII Text File menu command.

    Thanks,

    Mike
    Global Mapper Guru
    gmsupport@bluemarblegeo.com
    http://www.globalmapper.com