ZC-043 Excel template to convert Geographic coordinates to UTM

With this Template you can view Google Earth coordinates in Excel – and convert them to UTM.

Example:  -8.971, 15.463   to →  352,175.12, 1,458,298.01

With this Excel template you can convert coordinates from degree-minute-second format to decimals.

Example: Station 1-2, Distance 13.25, Heading  8° 58′ 15.6” W     to →  Autocad or Microstation

With this Excel template you can convert UTM coordinates to geographic coordinates.

Example: X=489513.59, Y=2,145,667.38  to →  lat= 19° 24' 18”, Length= -8° -5' -59”

With this template you can construct a box of bearings from a list of UTM coordinates in an Excel table.

Example:  352458.89, 1154221.20 Zone 16 N     to →    Station 1 am - 2 pm Distance 25.45 Course 8° 58′ 15.6” W  

With this template you can create a dxf file from a list of points in Excel

Example: 8° 58′ 15.6” W     to →  -8.971

With this Template you can concatenate the code for a script that draws the points, polygon and vertex names of an Excel table in AutoCAD.

Example:   1 374,037.80 1,580,682.4    to →  AutoCAD

With this Excel Template you can generate a kml file from UTM coordinates.

Example: 579706.89, 1341693.45 Zone 16 N

With this Excel template you can convert coordinates from degree-minute-second format to decimals.

Example: 8° 58′ 15.6” W     to →  -8.971