Google Maps Timeline to CSV & Excel

Your Timeline as a spreadsheet: every place you visited, every trip with its distance and mode, and kilometres per day — a ready start for a mileage log.

Drop your Google Timeline export here Timeline.json (Android), location-history.json (iPhone) or your Google Takeout location history · never uploaded

Get your Timeline file

On your phone choose Export Timeline data and move the JSON to your computer (how to export Google Maps Timeline). The spreadsheet is calculated from it on your device.

Planning to use it for expenses or tax? Export soon after the period you need: Google only keeps Timeline on the phone, and deleting the app or switching phones without a backup removes the history.

Convert to Excel or CSV

  1. Drop your Timeline export on the box above. Excel is selected.
  2. Set the period — for example one tax year — under From and To.
  3. Click Download. Prefer separate files? Choose one of the CSV options.

What is in the workbook

SheetColumns
Places visitedArrived, left, minutes, place, type, address, latitude, longitude, Google Maps link
TripsStart, end, minutes, mode (driving, walking, cycling, train…), distance in km and miles, from and to coordinates
Distance per dayDate, total km, and km per travel mode
Track pointsEvery recorded location with its time

Building a mileage log

Filter the Trips sheet on driving, add a column for the purpose of each trip, and you have the basis of a business mileage log. Distances are Google's own estimates of the route; check them against your odometer if your tax authority asks for exact figures.

Want to see the routes on a map? Google Timeline to KML or GPX.

Private by design

Your location history is the most private data you have. This page reads it on your device: nothing is uploaded, no map service is contacted, and the preview is drawn locally without map tiles.

Free Forever Converter is not affiliated with Google. Google Maps is a trademark of Google LLC.

Frequently asked questions

How do I get my Google Timeline into Excel?

Export Timeline on your phone, drop the JSON here and download Excel: places, trips and distance per day in separate sheets.

Can I use it as a mileage log?

It gives you every trip with date, mode and distance. Add the purpose of each trip yourself, and check the rules of your tax authority.

Are distances in miles too?

Yes. The trips have both kilometres and miles.

What time zone are the times in?

The local time at the place where it was recorded, as Google stored it.

Is my data uploaded?

No. Your location history stays on your device.

Runs entirely in your browser, powered by a Google Timeline reader for the Android, iPhone and Takeout formats, built for this site. Built and tested by Diego Callegari · how we test · updated 26 October 2026.