Earth Point Displays USA County Lines - Google recently removed county lines from Google Earth. Earth Point put them back. Select "County Lines" from the menu, lower left, or www.earthpoint.us/Counties.aspx

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.
  Enhanced feature.  What is this?
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...