Download the free Excel template to perform the following operations:

- Conversion of UTM Coordinates to Decimal Degrees.
- Conversion of Coordinates in Decimal Degrees to UTM.
- Conversion of Coordinates in Degrees, Minutes and Seconds to Decimal Degrees.
- Conversion of Decimal Degrees to Coordinates in Degrees, Minutes, and Seconds.

Download Excel template to convert between Geographic Coordinates and UTM

Very usefull. Thanks.

Is this Excel template only for the south hemisphere?

No, you can select South or North hemisphere.

Thank you for your sharing but I found some mistake on Decimal to UTM which coordinate Y is plus to 10,000,000 . So, I minus 10,000,000 in Y formula and It seem accurate

Thanks, I will check

Very very useful, thanks a ton for your effort.

Thank you very much, this is very helpfull

How do I adjust it to UTM zone 34S

This file is very helpful!!

My coordinates are showing up in the Southern Hemisphere?

Easting: 441336.44

Northing: 5233415.59

@watersail commented about editing the Y axis label, where is this?

Thanks so much to the creator for your effort!

I just have a quick doubt, how can I change from WGS84 to NAD27 (Mexico)? Is there like a couple of cells I can just change the values?

Thanks in advance!

I’m having this same problem, not exactly sure how to remove the WGS84 and input NAD83

VERY USE FULL THANKS FOR IT

Thank you very much. Precision. good luck bro…

Thank you so much!

Thank you for this great file!

Super, thank you so much for this file!

These coordinates (UTM to decimal degree transformation) are about 200 m SSW of ground truthed position when plotted on Google Earth. Any thoughts on this? I am working in 37P area. Thank you.

That’s amazing. Thanks.

Is there anyway to convert from one UTM Zone to another Zone? Say Zone 10 to Zone 11.

It’s very very good, except I’ve got quite a large data and I can’t convert it all at once, I have to do it in bits which is really time consuming.. any help or guide please?

Very Very Thank you !

This was amazing! I have been looking for a way to batch convert within excel for a long time and I stumbled upon this. I did the entry data modifications (Zone & Hemisphere) needed for my area, put in my coordinates, and double checked the output to my other coverage comparing the Google Earth map to ArcMap and it seems like it was perfect. You are an angel!

Thanks man you help me out

I can’t believe this works as well as it does. awesome job

Great code – here is a VB6 snippet that works based on this spreadsheet.

Private Sub cmdGetUTM_Click()

‘USER DEFINED

Dim C12 As Double ‘A SEMI MAJOR AXIS

Dim C13 As Double ‘B SEMI MINOR AXIS

Dim lat As Double

Dim lon As Double

‘CALCULATED

Dim C15 As Double ‘Eccentricity

Dim C16 As Double ‘2ª Excentric. ( e’ )

Dim C17 As Double ‘e’ ²

Dim C18 As Double ‘c (polar radius of curvature)

Dim C21 As String ‘Hemisphere

‘HIDDEN VARS

Dim E5 As Double ‘LAT

Dim F5 As Double ‘LONG

Dim G5 As Double ‘RADIANS LONG

Dim H5 As Double ‘RADIANS LAT

Dim I5 As Double ‘ZONE

Dim J5 As Double ‘MERIDAN

Dim K5 As Double ‘LAMBDA

Dim L5 As Double ‘A

Dim M5 As Double ‘Xi

Dim N5 As Double ‘ETA

Dim O5 As Double ‘Ni

Dim P5 As Double ‘Zeta

Dim Q5 As Double ‘A1

Dim R5 As Double ‘A2

Dim S5 As Double ‘J2

Dim T5 As Double ‘J4

Dim U5 As Double ‘J6

Dim V5 As Double ‘ALFA

Dim W5 As Double ‘BETA

Dim X5 As Double ‘GAMMA

Dim Y5 As Double ‘B(FI)

Dim Z5 As String ‘Banda(-72 to -16)

Dim AA5 As String ‘Banda (-8 to 48)

Dim AB5 As String ‘Banda (56 to 84)

Dim AC5 As Double ‘UTM Easting X

Dim AD5 As Double ‘UTM Northing Y

Dim AE5 As Double ‘Zone

Dim AF5 As String ‘Band

Dim AG5 As Double ‘LONG DD

Dim AH5 As Double ‘LONG MM

Dim AI5 As Double ‘LONG SS

Dim AJ5 As Double ‘LAT DD

Dim AK5 As Double ‘LAT MM

Dim AL5 As Double ‘LAT SS

Dim AM5 As String ‘LAT DD MM SS

Dim AN5 As String ‘LONG DD MM SS

Dim PI As Double

Dim bigno As Double

PI = 3.14159265359

‘USER DEFINED VALUES

E5 = CDbl(txtLat.Text) ‘latitude

F5 = CDbl(txtLong.Text) ‘longitude

C21 = UCase(txtHem.Text)

‘DATUM WGS84 DEFAULTS

C12 = 6378137

C13 = 6356752.314

‘FIXED VARS BASED ON GEODETIC DEFAULT

C15 = (Sqr(C12 ^ 2 – C13 ^ 2)) / C12

C16 = (Sqr(C12 ^ 2 – C13 ^ 2)) / C13

C17 = C16 ^ 2

C18 = (C12 ^ 2) / C13

‘HIDDEN CALCS

G5 = F5 * PI / 180 ‘RADIANS LONG

H5 = E5 * PI / 180 ‘RADIANS LAT

I5 = Fix((F5 / 6) + 31) ‘ZONE

J5 = 6 * I5 – 183 ‘MERIDAN

K5 = G5 – ((J5 * PI) / 180) ‘LAMBDA

L5 = Cos(H5) * Sin(K5) ‘A

M5 = (1 / 2) * (Log((1 + L5) / (1 – L5))) ‘Xi

N5 = Atn((Tan(H5)) / Cos(K5)) – H5 ‘ETA

O5 = (C18 / (1 + C17 * (Cos(H5)) ^ 2) ^ (1 / 2)) * 0.9996 ‘Ni

P5 = (C17 / 2) * M5 ^ 2 * (Cos(H5)) ^ 2 ‘Zeta

Q5 = Sin(2 * H5) ‘A1

R5 = Q5 * (Cos(H5)) ^ 2 ‘A2

S5 = H5 + (Q5 / 2) ‘J2

T5 = ((3 * S5) + R5) / 4 ‘J4

U5 = (5 * T5 + R5 * (Cos(H5)) ^ 2) / 3 ‘J6

V5 = (3 / 4) * C17 ‘ALFA

W5 = (5 / 3) * V5 ^ 2 ‘BETA

X5 = (35 / 27) * V5 ^ 3 ‘GAMMA

Y5 = 0.9996 * C18 * (H5 – (V5 * S5) + (W5 * T5) – (X5 * U5)) ‘B(FI)

‘T5

‘Banda(-72 to -16)

Select Case E5

Case Is < -72

Z5 = "C"

Case Is < -64

Z5 = "D"

Case Is < -56

Z5 = "E"

Case Is < -48

Z5 = "F"

Case Is < -40

Z5 = "G"

Case Is < -32

Z5 = "H"

Case Is < -24

Z5 = "J"

Case Is < -16

Z5 = "K"

Case Else

Z5 = "L"

End Select

'AA5

'Banda (-8 to 48)

Select Case E5

Case Is < -8

AA5 = "L"

Case Is < 0

AA5 = "M"

Case Is < 8

AA5 = "N"

Case Is < 16

AA5 = "P"

Case Is < 24

AA5 = "Q"

Case Is < 32

AA5 = "R"

Case Is < 40

AA5 = "S"

Case Is < 48

AA5 = "T"

Case Else

AA5 = "no"

End Select

'AB5

'Banda (56 to 84)

Select Case E5

Case Is < 56

AB5 = "U"

Case Is < 64

AB5 = "V"

Case Is < 72

AB5 = "W"

Case Is < 84

AB5 = "X"

Case Else

AB5 = "no"

End Select

'UTM Easting X

AC5 = M5 * O5 * (1 + P5 / 3) + 500000

'UTM Northing Y

If C21 = "S" Then

AD5 = N5 * O5 * (1 + P5) + Y5 + 10000000

Else

AD5 = N5 * O5 * (1 + P5) + Y5

End If

'ZONE

AE5 = I5 'Zone

'AF5

'Band

Select Case E5

Case Is < -16

AF5 = Z5

Case Is < 64

AF5 = AA5

Case Is < 84

AF5 = AB5

Case Else

AF5 = "MALO"

End Select

AG5 = Fix(F5) 'LONG DD

AH5 = Fix((F5 – AG5) * 60) 'LONG MM

AI5 = Round((((F5 – AG5) * 60) – AH5) * 60, 3) 'LONG SS

AJ5 = Fix(E5) 'LAT DD

AK5 = Fix((E5 – AJ5) * 60) 'LAT MM

AL5 = Round((((E5 – AJ5) * 60) – AK5) * 60, 3) 'LAT SS

AM5 = AJ5 & "º " & AK5 & "' " & AL5 & " S" 'LAT DD MM SS

AN5 = AG5 & "º " & AH5 & "' " & AI5 & " W" 'LONG DD MM SS

'return

txtNorthing.Text = AD5

txtEasting.Text = AC5

txtZone = AE5

End Sub

What set of equations does this spreadsheet use to transform between UTM and decimal degrees and back? Is there a paper or textbook these came from? I’m having trouble finding these particular equations. I’ve found a bunch of papers from Deakin, Hunter, Karney, and others that seem more complicated. I also found this webpage from “Land Information New Zealand” that has their own set of equations:

https://www.linz.govt.nz/data/geodetic-services/coordinate-conversion/projection-conversions/transverse-mercator-transformation-formulae

There are a lot of similarities to all of these, but I would prefer to stick with your spreadsheet, but have the reference noted.

Regards

Very nice. thank you very much. been looking for this one