StatePlaneToLatLon(Easting, Northing, State_Code)
Converts input U.S. State Plane (NAD83) coordinates to latitude and longitude.
Input: Easting = State Plane easting coordinate , in meters (number)
Northing = State Plane northing coordinate, in meters (number)
State_Code = U.S. State Plane code. (see below) (number)
Output: Latitude and longitude in decimal degrees (vector)
Notes:
- If unfamiliar with Excel vector functions, see Vector Functions reference
- This function is an adaptation of the National Geodetic Survey's SPCS83 coordinate conversion tool. Accordingly, the list of State Codes follows convention in SPCS83, reproduced here:
State Region State Code | State Region State Code
| AL | E | 101 | MS | E | 2301 | |
| W | 102 | W | 2302 | |||
| AK | 1 | 5001 | MO | E | 2401 | |
| 2 | 5002 | C | 2402 | |||
| 3 | 5003 | W | 2403 | |||
| 4 | 5004 | |||||
| 5 | 5005 | MT | 2500 | |||
| 6 | 5006 | |||||
| 7 | 5007 | NE | 2600 | |||
| 8 | 5008 | |||||
| 9 | 5009 | NV | E | 2701 | ||
| 10 | 5010 | C | 2702 | |||
| W | 2703 | |||||
| AZ | E | 201 | ||||
| C | 202 | NH | 2800 | |||
| W | 203 | |||||
| NJ | 2900 | |||||
| AR | N | 301 | ||||
| S | 302 | NM | E | 3001 | ||
| C | 3002 | |||||
| CA | 1 | 401 | W | 3003 | ||
| 2 | 402 | |||||
| 3 | 403 | |||||
| 4 | 404 | NY | E | 3101 | ||
| 5 | 405 | C | 3102 | |||
| 6 | 406 | W | 3103 | |||
| L | 3104 | |||||
| NC | 3200 | |||||
| CO | N | 501 | ||||
| C | 502 | ND | N | 3301 | ||
| S | 503 | S | 3302 | |||
| CT | 600 | OH | N | 3401 | ||
| S | 3402 | |||||
| DE | 700 | |||||
| OK | N | 3501 | ||||
| FL | E | 901 | S | 3502 | ||
| W | 902 | |||||
| N | 903 | OR | N | 3601 | ||
| S | 3602 | |||||
| GA | E | 1001 | ||||
| W | 1002 | PA | N | 3701 | ||
| S | 3702 | |||||
| HI | 1 | 5101 | ||||
| 2 | 5102 | RI | 3800 | |||
| 3 | 5103 | |||||
| 4 | 5104 | SC | 3900 | |||
| 5 | 5105 | |||||
| SD | N | 4001 | ||||
| ID | E | 1101 | S | 4002 | ||
| C | 1102 | |||||
| W | 1103 | TN | 4100 | |||
| IL | E | 1201 | TX | N | 4201 | |
| W | 1202 | NC | 4202 | |||
| C | 4203 | |||||
| IN | E | 1301 | SC | 4204 | ||
| W | 1302 | S | 4205 | |||
| IA | N | 1401 | UT | N | 4301 | |
| S | 1402 | C | 4302 | |||
| S | 4303 | |||||
| KS | N | 1501 | ||||
| S | 1502 | VT | 4400 | |||
| KY | 1Z | 1600 | VA | N | 4501 | |
| N | 1601 | S | 4501 | |||
| S | 1602 | |||||
| WA | N | 4601 | ||||
| LA | N | 1701 | S | 4602 | ||
| S | 1702 | |||||
| SH | 1703 | WV | N | 4701 | ||
| S | 4702 | |||||
| ME | E | 1801 | ||||
| W | 1802 | WI | N | 4801 | ||
| C | 4802 | |||||
| MD | 1900 | S | 4803 | |||
| MA | M | 2001 | WY | E | 4901 | |
| I | 2002 | EC | 4902 | |||
| WC | 4903 | |||||
| MI | N | 2111 | W | 4904 | ||
| C | 2112 | |||||
| S | 2113 | VI | PR | 5200 | ||
| MN | N | 2201 | ||||
| C | 2202 | AS | 5300 | |||
| S | 2203 | |||||
| GU | 5400 |