Build a mileage log from your Google Maps Timeline

Get the trips into a spreadsheet

1. Export your Timeline from the phone (and older Takeout files if needed).
2. Open them in Trackmere. Each day shows visits and the journeys between them with the travel mode Google detected and the distance.
3. Export the Excel workbook or timeline CSV – one row per visit/journey with times and distances.
4. In Excel, filter to driving journeys, add a Purpose column, and mark business trips.

Check before you claim

• Travel mode is detected automatically and can be wrong (car vs bus vs taxi).
• Distances come from the recorded path and can differ from odometer or route-planner distances.
• Tax authorities often require a log with the business purpose of each trip and may expect it to be kept at the time – check your local rules (e.g. IRS Publication 463 in the US, HMRC guidance in the UK).

Going forward

Export your Timeline monthly and keep the file with your accounts, or keep a simple log alongside it.