What's inside
=DISTANCE()- →One row per trip: date, from, to, purpose — the miles compute themselves.
- →The total row sums automatically; multiply by your rate for the claim.
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 accurate are the distances?
=DISTANCE() returns straight-line distance between the two addresses. For reimbursement many policies accept it; where road miles are required, treat it as the auditable minimum.
Does it work with just town names?
Yes — =DISTANCE("Austin, TX", "Dallas, TX", "mi") works with towns, full addresses or postcodes.
More templates like this
Browse the full gallery →