What's inside
=CLEAN_ADDRESS()=CITY()=POSTCODE()=INSTAMAP()- →Paste names and addresses — formatting does not matter.
- →Clean address, city and postcode columns fill themselves.
- →The map link shows everyone at once — handy for planning visits 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 it fix inconsistent address formats?
Yes — =CLEAN_ADDRESS() standardises each entry to the full postal form, whatever state it was pasted in.
Does it work for international addresses?
Yes — the geocoder resolves addresses in most countries and =COUNTRY() can add a country column.
Is there a limit?
The free tier covers 100 lookups/day (1,000/day with a free email unlock) — results are cached, so re-opening the sheet does not re-spend it.
More templates like this
Browse the full gallery →