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
- Drop your Timeline export on the box above. Excel is selected.
- Set the period — for example one tax year — under From and To.
- Click Download. Prefer separate files? Choose one of the CSV options.
What is in the workbook
| Sheet | Columns |
|---|---|
| Places visited | Arrived, left, minutes, place, type, address, latitude, longitude, Google Maps link |
| Trips | Start, end, minutes, mode (driving, walking, cycling, train…), distance in km and miles, from and to coordinates |
| Distance per day | Date, total km, and km per travel mode |
| Track points | Every 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.