What's inside
=DISTANCE()=CLEAN_ADDRESS()=INSTAMAP()=SORT_BY_DISTANCE()- →Put your work/school anchor in B1 — every listing shows its distance from it.
- →The shortlist map gives you the geography at a glance; share it with a partner.
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
How do I compare commute distance across listings?
Set your anchor (office, school) once in B1; =DISTANCE(address, $B$1, "mi") fills per listing. Sort by that column with =SORT_BY_DISTANCE().
Can my partner see the shortlist on a map?
Yes — the =INSTAMAP() link is live and shareable; it updates as you add or remove properties.
More templates like this
Browse the full gallery →