# Convert UTM to Geographic Coordinates with Excel

In the previous post we had shown an Excel sheet to convert coordinates Geographic to UTM From a sheet that had popularized Gabriel Ortiz.

Let's see now this tool that does the same process in reverse, that is, having coordinates in UTM format (Universal Traverso de Mercator) and knowing the area, transform them to latitudes and geographical longitudes.

Let's start familiarizing ourselves with this: according to Google Earth, the coordinates of the Palace of Sports in DF would be X = 489513.59, Y = 2,145,667.38 considering that Google Earth uses WGS84 datum. (for what you do not know, to see UTM coordinates you only go to tools / options / vista3D / show lat / long)

In geographical coordinates, this would be Long = -8 ° -5 '-59 », lat = 19 ° 24' 18», (to display the grid in google Earth it becomes «view / grid»)

I recommend that you familiarize yourself with this form of verification and understanding How the UTM coordinates work To get the most out of the tool in Excel.

I've done This sheet that would be very useful to a friend who some time ago was looking to send to Google Earth some data that were in UTM.

1. How to enter data

The fields in yellow pick up the XY coordinates, and also the zone, with this one must be careful enough because Mexico to give an example, the zones go from the 16 to the 21 so that the same coordinates can be in different zones.

The same happens with the hemisphere, as is the case of Colombia, Ecuador and Brazil that have areas in both the northern and southern hemispheres.

Also in the upper part is the reference spheroid with which the UTM coordinates were generated, this is not for the output coordinates but rather for the input coordinates.

2. The output results

The columns in green are the geographical coordinates, the coordinates in the east of the Greenwich meridian will be positive, those in the west will be negative.

3 How to send them to Google Earth

We had already seen some ways to send an Excel file to Google Earth, both geographically and UTM, so take a look, if you want to send the UTM coordinates to AutoCAD, This Excel template allows you to do it.

Here you can download the template to convert UTM coordinates to Geographic.

You can buy it with credit card.

It is symbolic if one considers the utility it provides and the ease with which it can be acquired.

Learn how to make this and other templates in the Excel-CAD-GIS cheat course.

## 109 Replies to "Convert UTM coordinates to geographic coordinates with Excel"

1. All the previous opinions are with past dates, for today September of the year 2020, how are such versions, the technology of that moment is different from today's date, will it remain in force, are there variations?

2. Hi Javier.
We have sent it to your email. Surely he had gone to some spam folder.

Greetings.

3. Good afternoon,

I just bought the model but nothing came to me. Could you please check the sending of this excel?

Thank you
Javier

4. Tisti says:

By the way, I just discovered this website and I am fascinated. I still have to miss a while on it, but it looks great.

5. Tisti says:

I also don't find where to download it…. 🙁 Where is that wonderful table?

6. LUIS LARA says:

I do not see where to go down !!

7. Can you give us an example?

8. Frank says:

I would like to know because when I entered the same geographic range I vote different results for example

9. Efrain Peña Borda says:

Q program for windows vista or excel sheet I can use and download free to convert flat coordinates to geographic or viseversa, I thank you in advance for the attention to the present.

Cordially,

Efrain Peña Borda

10. Jonathan Cardiel says:

PERFECT!!!

11. Sure, much more than that.

12. Jonathan Cardiel says:

Good day;

I would like to know if with your table I can convert (from UTM to GEOGRAPHIC) many coordinates at the same time. Many are like 1000.

13. We do not have a template to convert GTM to UTM.

14. Pedro luis patino says:

I am personally interested in the exel template to convert GTM coordinates TO UTM AND FORMS
Please send me a template count account number

15. Ernesto says:

Hello, I have the excel sheet to move from decimal degrees to degrees, minutes, seconds.
Get in touch with me

16. JOSE LUIS says:

Thank you, I will see what is the most accessible payment method in which you can do it.

17. Hello José Luis
No problem, the template contains columns where it supports the input in decimal format.

18. JOSE LUIS says:

Dear, what I want is to be able to graph the coordinates in MicroStation V8i, but my HandHeld captures them to me in decimal degrees LAT W89.14298 N13.71391, and I must convert them to XY, the excel template asks for them in Degrees, minutes and Seconds.
Can help me with this. Thank you

19. First, thank you for your interest.
Check what you are looking for, as this template converts from UTM to geographic but there are other templates that are sure to do what you want.

Check out the other available templates in this link.

20. JOSE LUIS says:

QUESTION CAN YOU MODIFY THE EXCEL SHEET TO DIRECTLY ENTER DECIMAL GRADES AND AT WHAT COST WOULD HAVE.

21. VICENTE DU says:

You can use the spreadsheet to convert geographic coordinates into
UTM coordinates and as

22. Christian says:

18

23. Douglas says:

How do I convert UTM coordinates to geographic coordinates?

24. As the template works without inconveniences

If you leave us an example, we can review.
What are the coordinates you entered, what area, what results do you generate, what country you are in and we check to see what happens. Do not be a matter of separation nomenclature of thousands or decimals.

25. Fresia says:

Hello, I bought the form, I put the coordinates to convert them but I sent them off the continent. It may be that it is in the area, in this sheet puts zone 15, for Chile what zone should I put?

26. Shaviola says:

Hello, I need to convert coordinates in decimal degrees to coordinates in degrees, minutes and seconds.

27. Surely your coordinate And it is bad, because latitude starts in Ecuador and when it reaches El Salvador it is a number that exceeds one million. Check it out because apparently there is the problem.

28. WHITE AINOA SHIRT FOR WOMEN says:

Datum wgs84

29. WHITE AINOA SHIRT FOR WOMEN says:

It is that in this country the variations of longitude in degrees vary between 87 ° and 89 ° and the latitude between 13 ° and 14 ° is a Central American country

30. WHITE AINOA SHIRT FOR WOMEN says:

X = 439188.2040 and Y = 316859.3910

31. Yes but we would not know what to say. How do you know that should give?
Which Datum did you use?

Record the coordinates in meters here, and we will try our converter to see if you do not care.

32. WHITE AINOA SHIRT FOR WOMEN says:

look, use a coordinate converter from meters to degrees and the results I should give is 89 ° longitude and 13 ° latitude, but it gave me 89 ° and 2 ° latitude use 16 zone and north west hemisphere I need to know what it does

33. RAUL MACIAS VALDEZ says:

there is a google heart version that accepts to enter points with UTM coordinates is 6.2.1.6014 (beta)

34. You click on the link that says:

Or on the button that says "buy now"

35. Luis Gallardo says:

I can not find the way to send the 2 dollars and I urgently need to download that coordinate converter worksheet.

36. Cris says:

Many thanks

37. Cris says:

Ok and is there any possibility of obtaining a map of Venezuela that tells me from what point the spindles or zones are located?

38. REGVen WGS84 equals UTM WGS84

39. Cris says:

Hi, I have some doubts. the UTM coordinates are the same REGVEN? is that I need to know the areas in which Venezuela is divided, can you help me with that please?

40. In some cases it may happen that the download stops, or that the Proxi from which you are connecting blocks the download. However, if this happens, you can notify it by mail.

We sent the template to your email.

Greeting.

41. heeeey pay the dollar 2 and don't let me download the excel template

what I do ?????

42. Works with any zone

43. Cyc says:

I mean the 14 zone or it works with all zones

44. What 14 do you mean?

45. Cyc says:

Do these methods work for 14?

46. Juan says:

I thank you for the information

47. Unable to, Google Earth does not accept coordinate input in UTM format. The most practical thing is that you do it with a GIS program like Microstation, gvSIG or QGis, and then export it to kml to see it in Google Earth.

48. Enrique Arizabalo says:

Hi, look, I'm interested in the coordinates. I would like to know how I input my coordinates utm to Google Earth in advance, Gracesco, the help.

49. g! says:

-The coordinates that Google Earth shows and those you refer to are those known as UTM. This system divides the continent into 60 zones that go from pole to pole, 6 degrees long each. In the East direction, each zone has 500,000 as the central meridian and thus it increases or decreases until it reaches the limit of the zone, so an East coordinate is repeated in each zone, but it is never negative. In the North sense, it starts at zero from the equator, towards the north pole and in the southern hemisphere it starts at the pole until it reaches the equator.

This system causes difficulties in countries that are involved in more than one zone, in the case of Colombia it is between the 17, 18 and 19 zones. Additionally, it has the peculiarity of having a segment in the northern hemisphere and another in the southern hemisphere.
So the countries decide to choose false origins, to reduce the complexity of this, and that is why it is not possible for the coordinates to coincide with those shown by Google Earth.
To make the conversions, the Geographic Institutes provide information such as this:

http://www.unalmed.edu.co/~janaya/clase3/cambio_coord_datum.htm

You can also have a look at these links:

50. Miguel says:

good morning

When entering the website, because I was looking for the information of the coordinates that I detail below:

In the map of Colombia prepared by IGAC (Instituto Geografico Agustin Codazzi), the coordinates of the mentioned map do not coincide with the coordinates of the Google Earth map:

For example, the coordinates of the map of Colombia, to locate an exact site a little south of Puerto Wilches 1021223E, 1302614N, these coordinates can not locate with the Google Earth map, could explain that difference?
In addition, as a curious case, taking from the Google Earth map, more specifically in the department of Nariño it is observed that the coordinates that go from West to East, we take the case of Tumaco, is located in 748650 E, if we continue with the same coordinates towards the East, it is striking that when arriving at 833969E and it changes a little later to 166030E. It also happens that in Google Earth from the equator to the North begins in 0.0, however in IGAC has its own coordinate in the equator.
In conclusion, how can conversions be made from the coordinates of IGAC to Google Earth?
Thank you in advance for your valuable assistance in explaining this confusing situation.

51. Pablo says:

Very good adaptation of the work of Gabriel Ortis, I used it in Win Xp but I changed to W7 and I could not continue using it, it is very useful to pass the points to a kml file that reads Google Earth, if you give me an email I will send them the adaptation.

Thank you

52. g! says:

Sure, just leave the seconds blank.

53. Enter your name ... says:

if I do not have the seconds I can also convert them to utm ???

54. CARLOS says:

GRACIASSSSS.

a great tool to have the same to convert UTM coordinates to geographies

56. ARNALDO SALAZAR says:

I have tested it with coordinate points of the National Cartography of Venezuela and it gives the same result. Thank you

57. Javier says:

Hello,

thank you very much for your input.

58. g! says:

Vitos, to do the conversion in reverse, or from Geographical to UTM you can check this Geofumadas link

59. Vitos says:

I need to convert this data W 14 ° 51 ′ 16.59 »YS 90 ° 51 ′ 50.1» to UTM

60. Carlos says:

That great contribution, works perfect in almost all cases, but it is by the limiters of the method. Thank you for sharing it on the web.
A great greeting !!

61. andy says:

Thanks for sharing these tables with people.
They are of great benefit

62. Magin64 says:

1 Thank you GIG for the contribution in this blog, more than excellent, clickcidades (Invente congratulations computer!) I could download the Excel spreadsheet to UTM but the link that appears here could not do it, ie from UTM to geographies, some special directive ?. Thank you.

63. victor ramirez says:

It is an excellent tool ...
There are sometimes people who are very mean and do not like to share their knowledge but I see that you are generous ... thanks for your tool ...
move on ..

64. mercedes says:

I have to georeference an image of Bs. As., Argentina with points taken from google earth, does anyone know what the spheroid is and the datum that Google Earth uses and what area of ​​Argentina it is? To do the georeferencing, Erdas asks me for that data.
Many Thanks

65. rodrigo says:

Hi. Very good contribution. However, could you give me the formula to do it with a calculator?
Thank you

66. alonso says:

Excalente tool.
Thank you! And a greeting from Spain!

67. Benancio says:

utm geographic coordinates converter

68. Ronald says:

Thanks good idea

69. I suppose you have them in UTM, copy the coordinates in the Excel table, indicating in what area they are and convert them to geographic, so you will have them in the other zone, if you then want to pass them to utm in the other area, you take the converted geographical coordinates and raisings to utm, choosing the other zone.

70. Ronald says:

Hi, I have a set of data taken in utm in the 16 zone but I need to change them to 15 zone how I do it

Thank you

71. Between a geographical coordinate and a UTM there is no error, it is the same.

If you want to understand the theory to make the conversion, Gabriel Ortiz explains it in this article.

http://www.gabrielortiz.com/art.asp?Info=058a

72. Ramdwing says:

Very good his technique, but I need to know how to make the change, but not digital I am student of engineering of animal production stoy studying conservation of soils and waters, in this matter I am asked to show the calculations and determine the error between these two coordinates, I do not know How to make them. could you help me? The most important thing is to calculate the error between the two coordinates !!

73. You must see the corresponding area in Google Earth, because in Colombia the 17,18 and 19 zones coincide

74. Anonymous says:

Hi. I entered the database of geographic coordinates to pass them flat but the result I get is not what I expected. I require this transformation for coordinates in Colombia. What change should I make?

75. hello! Someone knows how I can go from UTM to Geograficas (degrees) but in decimals, not in minutes or seconds.

Is there any tool in excel that will allow me to do this?

76. Great Geofumadas and Gabriel Ortiz, thanks for your interest in helping others! From Peru I greet you ..!
cool!

77. GERARDO C says:

GOOD WORK ALREADY CARRY OUT SOME EXERCISES WITH YOUR INFORMATION AND IT IS VERY GOOD TO SAY TRUE ENOUGH GOOD, I HAVE A PROBLEM WITH THE TRANSFORMATION OF UTM OR GEOGRAPHIC CODES TO FLATS,, THAT IS TO SAY I NEED TO TRACE IN FIELD WITH REAL OR FLAT MEASURES STARTING FROM A BASE OF DATA AND PHYSICAL POINTS IN FIELD WITH UTM OR GEOGRAPHICAL COORDINATES AND OF COURSE CLOSE TO VERIFY THE ERROR WITH UTM COORDINATES AGAIN, OJALA CAN HELP ME

78. UTM Flayer expired, most Zonums programs were designed that way.

You can do conversions with the Excel template

79. J. Oliver García Rizo says:

You can do me the favor of obtaining me in antivirus ESET NOD 32, I thank you.

80. J. Oliver García Rizo says:

There is a UTM Flyer program, to make those conversions in google they gave it to me, but it had already expired, you can help me and give it to me, so that it does not expire.

81. J. Oliver García Rizo says:

In Nicaragua you work in Zone 16 and 17, somebody can help me.

82. J. Oliver García Rizo says:

I need to get the UTM Flyer program to move from UTM coordinates NAD 27 Central to Geografica in Google Maps

83. I guess that means: Zone 18, x = 338552 y = 9065052 in the southern hemisphere. Try it on the template. You will occupy a datum

84. Mauro jimenez nartel says:

PLEASE WISH HELP ME TO CONVERT UTM CORDENATES TO GEOGRAPHICAL CORDINGS DATA IS AS FOLLOWS:
WEST LENGTH 18L0338552
SOUTH LATITUDE UTM 9065052

85. Mauro jimenez nartel says:

Thank you for helping me do my job
West longitude 18L0338552
South latitude UTM 9065052

86. I received an email from Mario Sanchez that tells us that in order to speed up his work (he is studying the behavior of grazing sheep using GPS-GPRS collars) he added a series of tables to go from decimal to sexagesimal automatically and that this The result is inserted directly into the geofumed template that is shown in this post.

In addition it has added some formulas to calculate the distance between two coordinates and if it is available the time of taking of the coordinates also the speed of displacement is obtained.

He thought that maybe it could be useful to someone so he sent it and here they have the file with the settings.

87. Lorenia says:

Excellent tool, congratulations

88. Check the nomenclature that the Gabriel Ortiz calculator asks for

Valid forms of expression:
434156.35 4804758.33 102.44 (each position on a line, first X and then Y. Z is optional.)
433785.44 4803721.57
Use a space or tab to separate the X and Y coordinates, and in your case Z.

If you are putting the comma, that is bothering you.

89. JAVIER CRUZ says:

I need to convert X, Y coordinates to UTM coordinates

I have entered the data in the CARORDOGRAPHIC COORD CONVERSOR of «Gabriel Ortiz». but it does not throw the data with which I compare it.

Could anyone help me?

The data is as follows: X = 622,552.17 / Y = 2,062,181.26

The data to be returned is: N 64 ° 24 ′ 46.02 ″ E

But this does not come when introduced.

The HUSO that I introduce you is: 15 that corresponds to Campeche, Mex.

What am I doing wrong?

Thanks for the help in advance.

90. alfonso says:

Excellent converter and best method of teaching there is but to thank this great work. thank you very much

91. Anonymous says:

Excellent converter

92. luis felipe says:

This exclente the method of teaching. Please send it to this email. thank you very much

93. luis felipe says:

That's great for an apprentice like me. You. Would you kindly send me this email? Many thanks and best wishes with those wise teachings.

94. Anahí, this post Shows the example you requested, from both the southern hemisphere and Bolivia

Anahí,
If you put in the Menu / View / Grid the zones appear, as long as you have activated the UTM in Tools / Options / 3d View.

96. Anahí says:

What a good job, it helps a lot, a question for Bolivia as demonstrating the UTM coordinate variation in the 19, 20 and 21 regions.
I want you to help me find the graph to show the students the coordinates in each zone.

97. Carlos Flores says:

Congratulations, it really is an excellent tool and a good job.

98. orestes says:

first congratulate you for the different jobs you do second for the scope of providing your knowledge 'to other people who, like me, lack a lot of information, more than enough reasons for you to move forward luck

This site uses Akismet to reduce spam. Learn how your comment data is processed.