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.

Lat google earth

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.

Lat google earth

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.

Geoutm Downloads


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. Good afternoon,

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

    Thank you

  3. 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.

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

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

  6. 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.


    Efrain Peña Borda

  7. 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.

    I await your prompt reply, thank you.

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

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

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

  11. Hello José Luis
    No problem, the template contains columns where it supports the input in decimal format.
    Once you buy it, contact us and we will tell you how to do it.

  12. 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


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

  15. How do I convert UTM coordinates to geographic coordinates?

  16. 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.

  17. 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?

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

  19. 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.

  20. 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

  21. X = 439188.2040 and Y = 316859.3910

  22. 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.

  23. 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

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

  25. You click on the link that says:

    Here you can download

    Or on the button that says "buy now"

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

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

  28. 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?

  29. 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.


  30. 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.

  31. 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.

  32. Hi miguel. Regarding your question:
    -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:

    You can also have a look at these links:

  33. 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.

  34. 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

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

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

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

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

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

  40. 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 !!

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

  42. 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.

  43. 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 ..

  44. 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

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

  46. 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.

  47. 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

  48. 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 !!
    Thanks in advance!!

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

  50. 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?

  51. 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?

    Thanks for your time, and once again great geofumadas ..!

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


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

  55. 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.

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

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

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

    WEST LENGTH 18L0338552

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

  61. 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.

  62. 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.

  63. 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.

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

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

  66. 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.

  67. 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.

  68. 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.

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

  70. 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

Leave an answer

Your email address will not be published.

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