GeoGeek

Create an interactive map in Google Docs

To easily make an interactive map based on a spreadsheet, the fastest way you can opt for is Google Docs, requiring no GIS knowledge or software. Besides, it takes very little time to do it, at the most a minute.

The first thing you need to do is take the information to a Google Docs spreadsheet. The structure is simple, two columns are required: the first with the geographic reference and the second with the data to map. This process is done through geocoding, which is the coincidence of a name with its respective location (city, country).

For this example the data of the Happy Planet Index 2016 was copied, it is very simple, from an Excel table can be copied and pasted, or in turn import the table into Google Docs.

Once you have the table within Google Sheets, you must select the columns to participate. From the Insert menu, select Chart, on the right side of the panel that displays Chart type and select Geo chart.

In the same Chart editor panel you can customize the colors as well as the input data, for example you could select the column corresponding to life expectancy.

Once all the design settings have been made, in the map menu on the top right-hand side you can save it as an image or publish the graphic to share the link or insert it into a web page.

One thought on “Create an interactive map in Google Docs”

  1. Driss Arabe says:

    Very intetesting.Thanks for sharing.

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent posts

  • Problems when importing an Excel table into ArcGIS
  • Create an interactive map in Google Docs
  • Symbols not showing correctly in ArcMap
  • Differences between GIS and CAD
  • View the relief of a satellite image in ArcGIS
  • Real-time wind mapping
  • QGIS 2 Manual PDF
  • How to composite satellite image bands in ArcGIS
  • Band combination list for Landsat 8
  • Download Landsat 8 satellite images
  • Download Excel template to convert between Geographic Coordinates and UTM
  • How to calculate the area, perimeter or length in ArcGIS?

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 49 other subscribers

%d bloggers like this: