What's inside
=VISIT_ORDER()=ROUTE_LINK()=INSTAMAP()- →Paste the day's stops; =VISIT_ORDER() numbers the efficient sequence.
- →Sort by the order column, then tap the route link on your phone and drive.
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 does it decide the delivery order?
=VISIT_ORDER() computes a nearest-neighbour route from your first stop (or a start address you give it) — each next stop is the closest remaining one.
Can drivers navigate from the sheet?
Yes — =ROUTE_LINK() opens up to 11 stops in Google Maps; =WAZE_LINK() gives per-stop Waze links.
More templates like this
Browse the full gallery →