What's inside
=VISIT_ORDER()=ROUTE_LINK()=INSTAMAP()- →Paste your farm addresses in column A (up to 500).
- →=VISIT_ORDER() numbers them in nearest-neighbour walking order — sort by column B and go.
- →The =ROUTE_LINK() cell opens the route in Google Maps on your phone (11 stops per link).
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 get the best order to knock doors?
The =VISIT_ORDER() formula computes a nearest-neighbour sequence for the whole list — each stop is the closest unvisited address to the last one. Sort your rows by that column.
Can I navigate the route on my phone?
Yes — =ROUTE_LINK(A4:A8) builds an official Google Maps directions link through those stops. Open the sheet on your phone and tap it.
How many addresses can the template handle?
Up to 500 per map/territory. For bigger farms, split by street or area — one =INSTAMAP() per range gives each patch its own live map.
More templates like this
Browse the full gallery →