What's inside
=CITY()=COUNTRY()=INSTAMAP()- →One row per contact; the city and country columns fill from the address.
- →Filter by the auto-filled city column to plan trips or events.
Set-up (60 seconds)
- Click "Make a copy" above — the template opens in your Google Sheets.
- Install the free InstaMaps add-on (100 lookups/day free; 1,000/day with a free email unlock).
- Turn the formulas on: in your sheet, open Extensions → InstaMaps → ⚡ Enable formulas (once per sheet). Any
#NAME?cells recalculate — reload the page if they linger. - Replace the sample rows with your data — every formula stays live.
Questions
Can I see all contacts on a map?
Yes — the =INSTAMAP() cell is a live map of every contact with an address; it updates as the list grows.
What if some rows have no address?
Rows without a findable address are simply skipped by the map and the enrichment columns show blank — nothing breaks.
More templates like this
Browse the full gallery →