--- title: "Mapping Amplitude Data via Google Sheets Add-on - Adam Greco" description: "Learn how to plot Amplitude data on Google Maps using the Amplitude Google Sheet add-on tool and geographic reports." canonical: "https://amplitude.com/en-us/blog/mapping-amplitude-data" --- # Mapping Amplitude Data via Google Sheets Add-on - Adam Greco Learn how to plot Amplitude data on Google Maps using the Amplitude Google Sheet add-on tool and geographic reports. Source: https://amplitude.com/en-us/blog/mapping-amplitude-data --- [Adam Greco](/blog/author/adam-greco) [Former Product Evangelist, Amplitude](/blog/author/adam-greco) [](https://www.facebook.com/sharer/sharer.php?u=https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fmapping-amplitude-data)[](https://www.linkedin.com/sharing/share-offsite/?url=https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fmapping-amplitude-data)[](https://twitter.com/intent/tweet?url=https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fmapping-amplitude-data\&text=Mapping%20Amplitude%20Data%20via%20Google%20Sheets%20Add-on)[](mailto:?subject=Checkout%20this%20Amplitude%20Article\&body=Check%20this%20out%3A%20https%3A%2F%2Famplitude.com%2Fblog%2F%2Fblog%2Fmapping-amplitude-data) In a [recent blog post](https://amplitude.com/blog/google-sheet-add-on)**,** I demonstrated how to install and use the Amplitude Google Sheets add-on to embed data into a Google Sheet. After you embed data into a Google Sheet, you can manipulate it any way you want. You can also take advantage of other features and Google Sheet add-ons. In this post, I will show how you can combine the Amplitude Google Sheet add-on and [Google Maps](https://www.google.com/maps/about/mymaps/) to visualize Amplitude data on a map. First, let’s create a report in Amplitude that has geographic information. In my previous post, I showed a report of my blog post views by city: Next, I embedded this report into a Google Sheet: After you have the data in Google Sheets, you can make a new tab and reference this data. In this case, I want to sum all blog post views by city, so I use formulas to do this in a new tab: *Note that for Google Maps to work, the data you want to map has to be in the first tab of the Google Sheet, so at this point, you need to make the tab above the first tab in the sheet.* Next, you can open [Google Maps](https://www.google.com/maps/about/mymaps/) (which requires a Google Account) and click the button to create a new map: Then you will see a blank map, and you will click on the Import link under the first map layer and select the correct Google Sheet: After you select the correct Google Sheet, Google Maps will ask you to identify the column representing the demographic information (e.g., city, state, country). You will have to do this twice: After you click the finish button, you will see your data plotted on a Google Map: Within Google Maps, you can make edits, such as changing the markers, the type of map, or displaying the actual numbers. Those settings are located under the data layer (in this case, the link labeled “Uniform Style”). You may also see cases where Google Maps didn’t recognize the city, but those should be rare. I suggest adding a title to the Google Map. You can also import multiple map layers, so if you want to see the same data for different date ranges, you can label each import with the date. You can see the title and data label here: If you want to see a short video of me walking through the steps above, see below. [](https://info.amplitude.com/Digital_Analytics_Platform_Buyers_Guide) ##### Want to know what your users actually do? Amplitude turns product behavior into decisions your whole team can act. [Get started free](/signup?source=blog-analytics\&topic=analytics\&siteLocation=blog-inline-cta) About the author Adam Greco Former Product Evangelist, Amplitude [More from Adam](/blog/author/adam-greco) Adam Greco is one of the leading voices in the digital analytics industry. Over the past 20 years, Adam has advised hundreds of organizations on analytics best practices and has authored over 300 blogs and one book related to analytics. Adam is a frequent speaker at analytics conferences and has served on the board of the Digital Analytics Association. [More from Adam](/blog/author/adam-greco) Topics [Analytics](/blog/tag/analytics) [Data](/blog/tag/data) #### Recommended Reading [Read ](/blog/lessons-from-consolidating-our-mcp-server) [Insights](/blog/lessons-from-consolidating-our-mcp-server) ###### [Lessons from consolidating our MCP server](/blog/lessons-from-consolidating-our-mcp-server) [Oct 6, 2026](/blog/lessons-from-consolidating-our-mcp-server) [10 min read](/blog/lessons-from-consolidating-our-mcp-server) [Read ](/blog/what-ai-engineers-do) [Insights](/blog/what-ai-engineers-do) ###### [What AI engineers do in the age of agentic code](/blog/what-ai-engineers-do) [Oct 1, 2026](/blog/what-ai-engineers-do) [14 min read](/blog/what-ai-engineers-do) [Read ](/blog/jev-analysis) [Insights](/blog/jev-analysis) ###### [An analysis of Jev: Faster and cheaper, but watch the accuracy](/blog/jev-analysis) [Sep 28, 2026](/blog/jev-analysis) [13 min read](/blog/jev-analysis) [Read ](/blog/ai-context-configuration) [Product](/blog/ai-context-configuration) ###### [Your agent isn’t broken. It’s guessing.](/blog/ai-context-configuration) [Sep 23, 2026](/blog/ai-context-configuration) [6 min read](/blog/ai-context-configuration) #### Explore Related Content [101](/compare/top-feature-flag-solutions-for-product-teams) ###### [9 Top Feature Flag Solutions for Modern Product Teams in 2026](/compare/top-feature-flag-solutions-for-product-teams) [Jan 27, 2026](/compare/top-feature-flag-solutions-for-product-teams) [Integration](/blog/amplitude-hubspot-behavioral-analytics) ###### [Using behavioral analytics for growth with the Amplitude app on HubSpot](/blog/amplitude-hubspot-behavioral-analytics) [Jun 17, 2024](/blog/amplitude-hubspot-behavioral-analytics) [10 min read](/blog/amplitude-hubspot-behavioral-analytics) [Personalization](/blog/identity-resolution-insights) ###### [Identity resolution: The secret to a 360-degree customer view](/blog/identity-resolution-insights) [Feb 16, 2024](/blog/identity-resolution-insights) [10 min read](/blog/identity-resolution-insights) [Product](/blog/warehouse-native-technical-deep-dive) ###### [Inside warehouse-native Amplitude: A technical deep dive](/blog/warehouse-native-technical-deep-dive) [Jun 27, 2023](/blog/warehouse-native-technical-deep-dive) [15 min read](/blog/warehouse-native-technical-deep-dive) [Guide](/resources/boost-customer-engagement) ###### [5 Proven Strategies to Boost Customer Engagement](/resources/boost-customer-engagement) [Jul 12, 2023](/resources/boost-customer-engagement) [Video](/designing-high-impact-experiments) ###### [Designing High-Impact Experiments](/designing-high-impact-experiments) [May 13, 2024](/designing-high-impact-experiments) [Startup](/blog/direct-to-consumer-marketing-tactics) ###### [9 direct-to-consumer marketing tactics to accelerate ecommerce growth](/blog/direct-to-consumer-marketing-tactics) [Feb 20, 2024](/blog/direct-to-consumer-marketing-tactics) [10 min read](/blog/direct-to-consumer-marketing-tactics) [Growth](/blog/analytics-product-market-fit) ###### [Leveraging analytics to achieve product-market fit](/blog/analytics-product-market-fit) [Jul 20, 2023](/blog/analytics-product-market-fit) [10 min read](/blog/analytics-product-market-fit)