Geo Maps in Google Sheets

Screen Shot 2017-06-26 at 16.25.57

Geo Maps are very useful when you want to show the data and distribution across the globe, Your data can be anything ranging from Sales, Profit, Health Care, Users, Population etc. With the help of google sheet you can import your data set and get a Geo map very quickly and without much of efforts.

Watch this video for creating Geo chart using Google Sheet or read the text below

Let’s see how to create the geo map for the 50 most populous country in the world:

Get the data for the first 50 most populous country from the wikipedia as declared by United Nations:

https://en.wikipedia.org/wiki/List_of_countries_by_population_(United_Nations)

Open a New Google Sheet and copy this data to the sheet:

https://docs.google.com/spreadsheets/d/1c-mdMxizEF92wJQIZ1NgDDBJ2QF_Um4yXa7-JvpYKmA/edit?usp=sharing

  • Insert > Chart > Map > Select Geo Chart

Screen Shot 2017-06-26 at 16.36.06

  • Select Data Range:

Screen Shot 2017-06-26 at 16.39.23

  • Geo Map:

Screen Shot 2017-06-26 at 16.39.37