All Collections
How To
Use Google Sheets to display regional maps on your dashboards and web reports
Use Google Sheets to display regional maps on your dashboards and web reports

Everything you need to know about creating and displaying Google Sheets maps on dashboards and web reports

Tom Delbaere avatar
Written by Tom Delbaere
Updated over a week ago

Using map widgets is a great way of showing your clients a visual illustration of segmented geographical data.

For customers with a global reach, you can follow these steps to add a global map widget to your dashboards or reports, to show your selected data segmented by country.

Map widgets are currently only available at the country level, and are not available for all metrics. If you are wanting to display a more zoomed in regional map view instead, you can follow the below steps to use Google Sheets to create regional maps, and to then embed the map onto your custom dashboards or web reports.

To add a map to your Google Sheet, start by adding the location names and numeric data values which you would like to display on the map, on to separate rows and columns.

Select the location names and numeric data, and select "Insert" > "Chart" > "Chart type" > "Geo Chart" or "Geo chart with markers".

This will give you the option of showing either a colored geo chart or a geo chart with colored markers based on the selected locations and data values.

You can then customize the map to your specific preferences, by double clicking on the map and selecting "Customize."

Under the "Customize" section you will be able to customize the chart style by background color, chart border color, and font. A suggestion would be to choose an ocean colored background to give your map a more realistic look and feel.

You can also customize the colors of the locations or location markers based on the "maximum", "middle", "minimum", and "no value" numeric data values assigned for each location on the map.

Under the "Customize" section you will also be able to choose the region where you would like your map to zoom into by selecting "Geo" > "Region filter" > Select the location to zoom into.

Hovering over a location will display the location name and assigned numeric data value on the map.

Below are the available regions that Google Sheets allows it's maps to be zoomed in to:

  • World

  • Africa

  • Asia

  • Europe

  • North America

  • South America

  • Oceania

  • United States

Once your Google Sheets map is ready, you can then embed the map as an iFrame, to display this on your dashboards or web reports. To do this, within Google Sheets select "File" > "Share" > "Publish to web" > "Embed" > Select the Sheet > Copy the iFrame code.

With your Google Sheets iFrame code ready to go, head to your custom dashboard or web report and select "Add Widgets" > "Objects" > "Embed" > Drag the Embed widget on to the custom dashboard or web report > Edit the Embed Widget > Select "General" > Paste in the Google Sheets iFrame code within the "iFrame" section > Select "Save."

Note that embed widgets are not supported in PDF downloads, as PDF files do not allow for embedded content.

What's Next:

Did this answer your question?