Insert map in Excel - get geographic coordinates - UTM coordinates

Map.XL is an application that allows you to insert a map inside Excel and get coordinates directly from the map. You can also display a list of latitudes and longitudes on the map.

How to insert the map in Excel

Once the Program is installed, it is added as an additional tab called "Map", with the features of Map.XL.

Before inserting the map you have to configure the background map, this is done in the "Map provider" icon. It is possible to configure background using both maps, image or hybrid from services:

  • Google Earth / Maps
  • Bing Maps
  • Open Street Maps
  • ArcGIS
  • Yahoo
  • Ovi
  • Yandex

The map appears anchored to the right, but it can be dragged so that it is floating, or at the bottom / top of the Excel table.

This video summarizes how the whole process explained in this article is done, worked on the vertices of a plot using Bing Maps as a background.

How to obtain coordinates from Excel

This is done with the "Get coord" icon. The procedure is basically:

  • Press «Get Coord,
  • Click on the map,
  • Click on the Excel cell
  • Paste, using «Ctrl + V», or the right mouse button and selecting Paste.

How to make a list of Coordinates

The template shown in the example video, is built by Geofumadas, and it allows you to paste the coordinates according to an identifier, so that later you will be conformed into a latitude and longitude table.

MapXL is free, and you can download it from this link. It will also download the Excel table used in the example.

Send the coordinates to the map.

This is done with the icon «Ad markers», having selected the area of ​​the table of interest. Then a form appears to indicate which field is the latitude, which is the Length, the coordinate detail and the symbology of the map. To remove them you just have to do "Remove Markers".

Download here Map.XL, including the Excel template.

This video shows the process explained in this article, using as example the signaling of the tour on a volcano, using Open Street Maps as background.

See UTM coordinates on the map from Excel:

This functionality shown above shows geographic coordinates to be displayed from the map in Excel. If what you want is to show on this map coordinates that are in Universal Traverso Mercator (UTM), you will have to use a template like this one. The example shown in the image and video does that:

you can get the template here.

9 Replies to "Insert map in Excel - get geographic coordinates - UTM coordinates"

  1. Is there a way to Search by Name or Address ??

  2. Hello, does it work correctly for Excel Office 365? I can not see the Map tab after installing it.

    Thank you

  3. Hello, the link to download map.xl is still not activated.

  4. Hello sir good morning.
    I downloaded the template but there is no link for the software itself.
    Please can u help.
    Regards

  5. How can i download the program map.xl with excel template

Leave an answer

Your email address will not be published.

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