|
Convert a spreadsheet of coordinates from one system to another.
A user account is recommended for the features on this web page.
Batch Convert - Convert a spreadsheet of coordinates.
1) Convert From:
Data is read from spreadsheet. See instructions below.
2) Convert To:
3) Put Converted Values:
|
4) Select an Excel file (xls, xlsx, xlsm, txt, or csv)
5) Convert the file.
You are not signed in to your account. Only the first five spreadsheet rows will
be converted. For unrestricted access, please sign in or purchase a subscription.
|
|
Note: if you want to map the coordinates onto Google Earth, the Excel To Google Earth utility can map them directly. There is no need to convert them.
Instructions:
Data must have at least one of the following sets of column headings.
|
1)
|
Latitude, Longitude
|
|
2)
|
Zone, Easting, Northing. UnitOfMeasure is optional.
|
|
3)
|
Position
|
|
4)
|
TownshipAndRange
|
|
5)
|
TexasAbstract
|
If converting to State Plane, then the column heading ToStatePlaneZone must also
be specified.
If converting to UTM, the column ToUtmZone is supported. The column is optional.
The allowed values are the numbers 1 to 60. By default, coordinates are converted
to the UTM zone in which they lie. However, if ToUtmZone is specified, then
the coordinates are be converted to the that zone.
All other spreadsheet columns, if any, are ignored.
Examples of spreadsheets to be converted:
Latitude and Longitude
The ToStatePlaneZone column is only needed if converting to state plane. ToStatePlaneZone is only shown for Latitude and Longitude, but could be included on any of the examples below.
|
|
A
|
B
|
C
|
|
1
|
Latitude
|
Longitude
|
ToStatePlaneZone
|
|
2
|
43°36'34.86"N
|
116°12'23.30"W
|
1103
|
|
3
|
43 36 33.22
|
-116 12 18.40
|
1103
|
Coordinate Types
Row 1: Column Headings, can be in any order
Row 2: Latitude Longitude
Row 3: Latitude Longitude without punctuation
more Lat/Lon formats...
Zone, Easting, Northing
|
|
A
|
B
|
C
|
D
|
|
1
|
Zone
|
Easting
|
Northing
|
UnitOfMeasure
|
|
2
|
10S
|
577727
|
4341180
|
|
|
3
|
2401
|
662712
|
1021877
|
|
|
3
|
2401
|
201995
|
311469
|
m
|
Coordinate Types
Row 1: Column Headings, UnitOfMeasure is optional.
Row 2: UTM, unit of measure defaults to meters
Row 4: State Plane, unit of measure defaults to US Survey Feet.
Row 4: State Plane, unit of measure set to meters.
more Zone, Easting, Northing formats...
Position
|
|
A
|
|
1
|
Position
|
|
2
|
10S 577727mE 4341180mN
|
|
3
|
12SVD9954691185
|
|
4
|
139LK38
|
|
5
|
2401 201995.535m 311469.941m
|
Coordinate Types
Row 2: UTM
Row 3: MGRS
Row 4: GARS
Row 5: State Plane
more Position formats...
Township and Range
|
|
A
|
|
1
|
TownshipAndRange
|
|
2
|
WA Willamette T24-1/2N R9W
|
|
3
|
19T4NR2WS21
|
Coordinate Types
Row 2: Township and Range
Row 3: Township and Range, BLM "Landkey" format
more Township and Range formats...
Texas Abstract
|
|
A
|
|
1
|
TexasAbstract
|
|
2
|
0011025
|
|
3
|
Anderson 1025
|
Coordinate Types
Row 2: Texas Abstract, FIPS code format
Row 3: Texas Abstract, County name format
more Texas Abstract formats...
|