How to map addresses from a Google Sheet

By Jake Marsh · Updated

To map addresses from a Google Sheet, geocode them with the Geocode & Map Addresses add-on so each row has Latitude and Longitude, then open Extensions > Geocode & Map Addresses > Map preview, pick those columns and click Show map. Pins appear for every row, grouped where they're dense, and you can color them by any column and make a share link for people who don't have the sheet.

Steps

  1. Geocode the addresses. Open Extensions > Geocode & Map Addresses > Open geocoder, pick the address column (or street, city, state and ZIP), click Check rows, then Geocode N rows. Skip this if the sheet already has latitude and longitude.
  2. Open Map preview from the menu, or click See them on a map when the geocoding finishes.
  3. Pick the Latitude and Longitude columns. Columns named Latitude are picked for you.
  4. Choose a Pin label, such as the customer name, so each pin says what it is.
  5. Choose Color by to color the pins by a column such as sales rep, region or status. The most common values each get their own color, and the rest are grouped as Other.
  6. Click Show map. Zoom and pan like any web map. With more than 200 points, nearby pins are grouped into numbered clusters that split apart as you zoom in.
  7. Click Share link to make a web page with the same pins and labels. Anyone with the link can open it for 90 days, without the spreadsheet or a Google account.

Example

A territory review for a sales team with 1,800 accounts:

AccountRepStatusLatitudeLongitude
Harbor SupplyDanaActivefrom geocodingfrom geocoding

Color by Rep shows each rep's territory at a glance and where two overlap. Color by Status shows where the lapsed accounts cluster. A share link goes into the meeting invite so everyone sees the same map.

What goes into a share link

A share link stores a copy of the pins, labels and colors you chose, not the spreadsheet. Pick a label column that's fine for anyone with the link to see. The link doesn't update when the sheet changes: make a new one after you edit the data. Share pages aren't listed in search engines.

Limits

  • The map shows up to 10,000 rows.
  • Rows without valid coordinates are skipped and counted.
  • Maps and share links use no lookups, though they need an active trial, plan or lookup pack.
  • Geocoding covers the United States, Canada and Mexico. Coordinates from anywhere can be mapped.

If your contacts live in HighLevel rather than a spreadsheet, Zonewell for HighLevel puts them on a map inside the CRM.

What it costs

Try it free for 250 lookups or 14 days, whichever comes first. No card needed. Then it's $9.99 a month or $79 a year per Google account with 5,000 lookups every month, and lookup packs of 5,000 for $10 that never expire. Mapping the coordinates you have uses no lookups. See the Geocode & Map Addresses page to install it.

Geocode & Map Addresses by Great Work

Geocode, reverse geocode and map addresses in Google Sheets. No API key needed. $9.99 a month or $79 a year per Google account.


Questions

Does the map change anything in my sheet?

No. Map preview only reads the latitude, longitude, label and color columns you pick. Nothing is written to the sheet.

Do I have to geocode before mapping?

Only if the sheet has addresses without coordinates. If it already has latitude and longitude columns, open Map preview and pick them.

Can I color pins by a column?

Yes. Color by takes any column, such as rep, region or status. The most common values get their own colors and the rest are shown as Other.

How long does a share link last?

90 days. After that it stops working; make a new one from Map preview if you still need it.


More Geocode & Map Addresses guides


More Google guides