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 *

Do you want to ask a question in the forum?

Recent posts

  • Drawing in QGIS with better accuracy than AutoCAD
  • QGIS Training Manual PDF
  • GeoLove moves millions
  • What’s new in ArcGIS Pro 2.1?
  • Identify ridgelines from a mountain in ArcGIS
  • Problems when importing an Excel table into ArcGIS
  • Create an interactive map in Google Docs
  • Symbols not showing correctly in ArcMap

Subscribe to Blog via Email

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

Join 92 other subscribers