Guide

How to export your Google Maps Timeline to Excel

Google lets you export your Timeline, but only as a JSON file: a long text file meant for computers, not people. Excel can't turn it into a useful table on its own. Here's how to get a proper spreadsheet instead, with every visit and journey on its own row, free and without uploading your history anywhere.

Step 1: export your Timeline from your phone

On Android it's in your phone's Settings under Location → Location services → Timeline → Export Timeline data, which saves Timeline.json. On iPhone it's in Google Maps under your profile picture → Settings → Personal content → Export Timeline data, which saves location-history.json. The full export guide has every step, and older history from a Google Takeout zip works too.

Step 2: open it in There I Went

1. Go to thereiwent.com on your computer, laptop or phone, and drop the file onto the page (or click Make mine and choose it). It's read in your browser; nothing is uploaded.
2. Used more than one phone? Drop all the exports in together. Where they overlap and agree, nothing is counted twice; where they disagree, you choose which phone was with you.
3. Pick the period you want with the date buttons or the timeline bar: one trip, one tax year, or everything.

Step 3: download the spreadsheet

Scroll to the Days per country table and click Download spreadsheet (Excel). You get one .xlsx file that opens in Excel, Google Sheets, Numbers and LibreOffice.

What's in the spreadsheet

• Summary: one row per country for the period you picked: days present, nights, and share of tracked days.
• Days: one row per date and country, so you can see exactly which countries you were in on each day.
• Complete Subset: every place visit and journey in the period you picked. It only appears when you've picked part of your history.
• Complete: every place visit and journey in your whole history.

The two Complete sheets have these columns: date, start and end time, duration in hours, type (visit or travel), place name, place type (home or work), city, country, latitude and longitude (and the end point of journeys), travel mode, distance in kilometres, and the file each row came from. Times are local to where you were. Dates are real Excel dates, the top rows stay in place when you scroll, and every column has a filter, so you can sort and filter straight away.

The File column only shows a file name where it changes, which keeps long sheets readable. To see it on every row (for example to filter by phone), set "Show the file name on every row" above that column to On.

Good to know

• Place names. Android exports don't include place names, only coordinates and Google's Home and Work labels, so those rows show the nearest city instead. iPhone exports and older Takeout files usually include names.
• For tax or visa records, the Summary and Days sheets are usually all you need. See counting days in each country for tax residency.
• Before sharing the file, remember the Complete sheets show exactly where you live and work. Delete them if the other person doesn't need them.
• Need CSV? Open the file in Excel and use Save As → CSV for the sheet you want.
• Days with no data aren't in the file at all. If your results warn that part of the period is missing, see why Timeline days go missing.

Is it private?

Yes. Your Timeline file is read and the spreadsheet is made inside your browser; neither is sent anywhere. The privacy policy has the details.