mickeyp
Posts: 1
Joined: Thu Oct 09, 2008 3:53 am
Location: USA

convert excel file in DMS

Thu Oct 09, 2008 3:54 am

> I have an excell file of GPS cords taken with a garmin, in DMS. They
> are like this
> N34 49 00.3 ,W85 32 17.6.
>
> How can I get this tool to read the excell file?
I can find no good examples in the help.

wolfshadow
Posts: 24
Joined: Sun Jun 11, 2006 4:12 am

RE: convert excel file in DMS

Thu Oct 09, 2008 10:49 pm

Not sure what format you want to convert your data to based on your post but my recommendation would be to do an Excel "search & replace" function to replace any "N"s and "E"s with "" and replace any "S"s and "W"s with "-" to get the correct signs on the lat/long data. Then you could use the Separator Example Coordinate format as a starting point for a new input format and use spaces as the separators between the degrees, minutes, and seconds.

Return to “CoordTrans”