zahoward
Posts: 1
Joined: Fri May 28, 2010 3:18 am

CSV Format for Batch Conversion

Fri May 28, 2010 3:26 am

I have a spreadsheet i'm trying to convert WGS84 to NAD83. The coordinates were recorded as follows:
LAT
N32/ 24.931
LONG
W93/ 26.871

I need to understand how to take these coordinated into a CSV file and format it properly (choose the correct settings in the conversion wizard). I've tried creating one field for lat and long like this:

LAT
32,24.931
LONG
93,26.871

with no luck. i've also tried removing the comma and replacing with a space or no space.

Can you show me an example of how the lat/long field should look to convert DDMM in WGS84 to Decimal Degrees in NAD83?

Thanks!

Return to “CoordTrans”