UTM coordinates in google maps

Google is perhaps a tool with which we live almost weekly, for not thinking that every day. Although the application is widely used to navigate and move through directions, it is not so easy to visualize coordinates of a specific point, nor in geographic format, much less coordinates UTM in google maps

This article, apart from showing you how to visualize the coordinates in Google Maps, will teach you to become an expert in visualizing those coordinates in Excel, convert them to UTM and even draw them in AutoCAD.

Utm coordinates on google maps

In the previous display, a Google Maps view appears, with the necessary options to locate a position. You can enter at the top a specific address, or the name of a city, or by looking for the list that is in the top right display.

Once selected, the map is located at the selected address.

We can click anywhere on the map, and we display an indicator of the coordinate in decimal format and also sexagesimal (degrees, minutes and seconds).

As you can see, the decimal coordinate 19.4326077, -99.133208. It means 19 degrees over the equator and 99 degrees from the meridian Greenwich, towards the west, that's why it is in negative. In the same way, this geographical coordinate is equivalent to the latitude 19º 25 '57.39 "N, length 99º 7' 59.55" W. The upper part shows the UTM coordinate X = 486,016.49 Y = 2,148,701.07 which corresponds to the 14 zone in the northern hemisphere.

Ready. With this you have learned to locate a point in Google Maps and know its UTM coordinate.

How to save several coordinates of Google Maps.

Previously, it has been explained how to visualize individual points, both its geographical coordinate and its coordinate in Universal Traverso de Mercator (UTM).

If we want to save several points on Google Maps and visualize them in an Excel file, then we must follow this procedure.

  • We entered Google Maps, with our Gmail account.
  • In the left menu we select the option "Your places". Here we will see the points that we have labeled, routes or maps that we have saved.
  • In this section we choose the option "Maps" and create a new map.

As you can see, here are several features to create layers. In this case, I created the 6 points of the vertices and also the polygon. Although the functionality is simple, it allows to change color, style of the point, description of the object and even add an image to each vertex.

So you move to the area of ​​your interest and draw the layers you think are necessary. It can be a layer for the vertices, another layer for the polygons of the terrains and another layer for the buildings, if you are going to draw them.

Once finished, to download it, select the three vertical dots and save it as a kml / kmz file, as shown in the following image.

The kml and kmz files are the formats of Google Maps and Google Earth in which the coordinates, routes and polygons are stored.

Ready. You have learned how to save different points in Google Maps and download them as a kmz file. Here's how to view these coordinates in Excel.

How to see Google Maps coordinates in Excel

A kmz is a set of compressed kml files. So, the easiest way to unzip it is as we would do with a .zip / .rar file.

As shown in the following graphic, it might be that we do not see the file extension. For this, we must do the following actions:

  • The option to see the extension of the files is activated, from the "View" tab of the file browser.
  • The extension from .kmz to .zip is changed. To do this, a soft click is made on the file, and the data that is after the point is modified. We accept the message that will appear, indicating that we are changing the file extension and that it could become unusable.
  • The file is decompressed. Right mouse button, and "Extract in ..." is selected. In our case, the file is called «Geofumadas Classroom Ground».

As we can see, a folder was created, and right inside you can see the kml file called "doc.kml" and a folder called "files" that contains the associated data, in general images.

Open KML from Excel

Kml is a format popularized by Google Earth / Maps, which was before the Keyhole company, hence the name (Keyhole Markup Language), therefore, it is a file in XML structure (eXtensible Markup Language). So, being an XML file must be able to be viewed from Excel:

1 We changed its extension from .kml to .xml.

2 We open the file from Excel. In my case, I'm using Excel 2015, I get a message if I want to see it as an XML table, as a read-only book or if I want to use the XML source panel. I select the first option.

3 We search the list of geographic coordinates.

4 We copy them to a new file.

And voila, now we have the file of the coordinates of Google Maps, in an Excel table. In this case, starting from row 12, in column U the names of the vertices appear, in column V the descriptions and the latitude / longitude coordinates in column X.

So, with copying the X columns and the AH column, you have the objects and coordinates of your Google Maps points.

Interested in something else?

Convert coordinates from Google Maps to UTM.

Now, if you want to convert those geographic coordinates that you have in the form of decimal degrees of latitude and longitude to a format of projected UTM coordinates, then you can use the template that exists for that.

What are UTM coordinates?

UTM (Universal Traverso Mercator) is a system that divides the globe in 60 zones of 6 degrees each, transformed in a mathematical way to resemble a grid projected on an ellipsoid; such as is explained in this article and in this video.

As you can see, there copies the coordinates shown above. As a result, you will have the X, Y coordinates and also the UTM Zone marked in the green column, which in that example appears in the 16 Zone.

Send the coordinates of Google Maps to AutoCAD.

To be able to send the data to AutoCAD, you only have to activate the command of multiple points. This is on the "Draw" tab, as shown in the drawing on the right.

Once you have activated the Multiple Points command, copy and paste the data from the Excel template, from the last column, to the AutoCAD command line.

With this, your coordinates have been drawn. To visualize them, Zoom / All can be done.

You can buy the template with Paypal or credit card. Acquiring the template gives you the right to support by email, in case you have a problem with the template.

11 Replies to "UTM coordinates in google maps"

  1. xfavor how to convert addresses into coordinates


  3. I need to apply my utm coordinate to my phone as I do thanks

  4. I understand but I can not explain it in Espanyol:

    Google Maps requires coordinates in decimal format so you have to convert your UTM coordinates to display it.

    Convert the UTM coordinates at my website - http://www.hamstermap.com and you can google maps to display them.

    Alternatively, if you have multiple locations to display, you can place them on Google Maps using QUICK MAP tool on the same site.

  5. What happens is that it is not a Google application, although it is developed for Chrome.
    And I think Google also leaves basic things out for other companies to take advantage of and develop them ...

  6. Tremendo the programita, I will install it now. What I do not understand is how they do not apply standard for all browsers, regardless of chrome is google, would facilitate the use of google maps on all platforms.


  8. This is very good I would like to download the free program, tell me how to work with all those references, they are very useful for topographic surveys in coasts lagoons very closed by their mangrove and I have cost work and eh used google heart and it is very different this is more full.

  9. Always the articles published by geofumadas are very excellent, very interesting, continue like this.

Leave an answer

Your email address will not be published.

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