In this article:

How to Make a Map in Google Sheets (2024 Guide)

May 8, 2024

How to Create a Map in Google Sheets

To insert a map in Google Sheets, you can use the geo chart feature. Here's how to do it: 

Step 1: Prepare Your Data

Your dataset should have at least two columns:

Column A: Geographic locations (e.g., countries, states, cities). Ensure these are spelled correctly for Google Sheets to recognize them.

Column B: Numeric data related to each location (e.g., population, GDP).

For this example, let's say we want to visualize the population of various countries. Your data might look something like this:

insert map in google sheets

Step 2: Select Your Data

Click and drag to highlight both columns of your data, including the header row.

how to make a map in google sheets

Step 3: Insert the Chart

With your data selected, go to the menu, click on "Insert," and then select "Chart."

how to create a map in google sheets

Step 4: Change to Geo Chart

By default, Google Sheets will select a chart type for you. To change it to a geo chart:

1. Find the "Chart type" dropdown menu.

2. Scroll down and select either "Geo chart" for a colored map or "Geo chart with markers" if you prefer markers to represent your data points.

Below is what the geo chart should look like: 

You can move or resize the chart as needed.

Step 5: Customize Your Geo Chart

After selecting your chart type, you can customize its appearance:

Click on the "Customize" tab in the "Chart editor."

Here, you can adjust various settings like the chart's and labels' colors.

We hope that this article has helped you and given you a better understanding of how to make a map in Google Sheets. If you enjoyed this article, you might also like our articles on how to make a Pareto chart in Google Sheets and how to use the Google Sheets MAP function.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->