Skip to content

How to Build a Custom Google Map Using Addresses in Google Sheets

< 1 minute read

Sheets Green

Here’s a nifty trick that combines both Google Sheets and Maps. When you enter addresses into Sheets, you can then display all of the locations right in Maps, creating your own custom map. This is great for plotting business locations, deliveries, business contacts, or even just a personal travel itinerary.

  • In a Google Sheet, head up to the Add-ons menu item and select Get Add-ons. Search for Mapping Sheets, install it, and then approve any permissions it requests.
  • Next, head up to the Add-ons menu again. This time, you’ll notice that the Mapping Sheets item has been added to the menu. Select it, and then click on Start Mapping to start your project.
  • Enter in your data (addresses, coordinates, etc.) into your spreadsheet.
  • The add-on’s drop-down menus (on the right side of your screen) are important when you’re creating your projects. They tell the add-on where to look for the various data you need to build your map, so you can specify where the title comes from, what filter to use, and where the location is found in the spreadsheet.
  • When you click Build, Google Maps will start importing the data from the locations that you have specified. Once the build process is completed, just click on View to view the map.

Click here to watch this video on YouTube.

Sign up for our newsletter