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.
|
|
Instructions:
The utility is functional, but I am still working on instructions...
Data must have at least one of the following sets of column headings.
1)
|
Latitude, Longitude
|
2)
|
Position
|
3)
|
TownshipAndRange
|
4)
|
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.
Example of a spreadsheet to be converted:
|
A
|
B
|
C
|
D
|
E
|
F
|
1
|
Latitude
|
Longitude
|
Position
|
TownshipAndRange
|
TexasAbstract
|
ToStatePlaneZone
|
2
|
43°36'34.86"N
|
116°12'23.30"W
|
|
|
|
1103
|
3
|
43 36 33.22
|
-116 12 18.40
|
|
|
|
1103
|
4
|
|
|
10S 577727mE 4341180mN
|
|
|
0402
|
5
|
|
|
12SVD9954691185
|
|
|
0202
|
6
|
|
|
139LK38
|
|
|
0202
|
7
|
|
|
2401 201995.535m 311469.941m
|
|
|
|
8
|
|
|
|
WA Willamette T24-1/2N R9W
|
|
4601
|
9
|
|
|
|
19T4NR2WS21
|
|
2113
|
10
|
|
|
|
|
="0011025"
|
4203
|
11
|
|
|
|
|
Anderson 1025
|
4203
|
Coordinate Types
Row 1: Column Headings, can be in any order
Row 2: Latitude Longitude
Row 3: Latitude Longitude without punctuation
Row 4: UTM
Row 4: UTM
Row 5: MGRS
Row 6: GARS
Row 7: State Plane
Row 8: Township and Range
Row 9: Township and Range, BLM "Landkey" format
Row 10: Texas Abstract, FIPS code format
Row 11: Texas Abstract, County name format
more Lat/Lon formats... more
Position formats... more
Township and Range formats... more
Texas Abstract formats...
|