Convert X & Y to Lat/Lon or Lat/Lon to X & Y

 

By Steven Dutch

Natural and Applied Sciences,

University of Wisconsin - Green Bay
 

This spreadsheet will allow you to convert universal transverse mercator coordinates

(aka; X and Y, or UTM) to latitude and longitude, or vice-a-versa.

 

P = point under consideration
F = foot of perpendicular from P to the central meridian. The latitude of F is called the footprint latitude.
O = origin
OZ = central meridian
LP = parallel of latitude of P
ZP = meridian of P
OL = k0S = meridional arc from equator
LF = ordinate of curvature
OF = N = grid northing
FP = E = grid distance from central meridian
GN = grid north
C = convergence of meridians = angle between true and grid north

 

Just so you know what you're getting yourself into...

 

 

UTM Conversions

Excel format

 

Download the instructions

 

Download the spreadsheet

 

Right click on the links above and select

SAVE TARGET AS . . .