How to export Google Fit data to Excel, Strava and Garmin Connect
Short answer: Google Fit has no “export to Excel” button. You ask Google Takeout for your Fit data and receive a ZIP with hundreds of small files. To get a spreadsheet and uploadable workouts, add that ZIP to FitTakeout in your browser: it gives you one Excel workbook, CSV files, and each workout as TCX and GPX.
1. Get your export from Google Takeout
- Open takeout.google.com and sign in with the Google account you use in Google Fit.
- Press Deselect all, then scroll to Fit and tick it.
- Press Next step. Keep the file type .zip, and press Create export.
- Google emails you a link when the archive is ready. Google’s help says most people get it the same day, that the archive expires in about 7 days, and that each archive can be downloaded 5 times (Google Account Help, “How to download your Google data”).
- Download the ZIP. You do not need to unzip it.
2. What is inside the ZIP
Everything is under Takeout/Fit. Folder names are translated if your Google account is not in English; the file names are not.
| Folder | Files | What they hold |
|---|---|---|
| Daily activity metrics (“Daily Aggregations” in old exports) | 2020-10-17.csv, one per day, plus a one-row-per-day summary file | A row every 15 minutes: move minutes, calories, distance, heart points, heart rate, speed, steps, weight, and one duration column per activity. The columns differ from day to day. |
| All Data | derived_com.google.weight_….json, raw_com.google.heart_rate.bpm_….json… | One file per data type and app: every data point with its time in nanoseconds. derived_ files are Google’s merge of all apps; raw_ files are one app each. |
| All Sessions | 2020-10-17T21_05_00-07_00_WALKING.json | One file per workout or sleep session: activity, start, end, duration, and totals (calories, steps, distance, heart points). |
| Activities | 2020-10-17T21_05_00-07_00_PT1H14M_Walking.tcx | One TCX file per workout, with its track points. Many have no GPS position. Less precise ones are in a “Low Accuracy” subfolder. |
The files for steps, distance, speed, calories, activity segments and location in “All Data” hold one entry per sample and are the bulk of the export: 10 to 60 MB each in an export of a few years. Their totals are already in the daily CSV files.
3. Convert it in the browser
- Open FitTakeout.
- Drop the ZIP on the page, or choose it. If you already unzipped it, choose the
Takeout/Fitfolder. Nothing is uploaded: the files are read on your computer. - Check the preview: days, workouts, weigh-ins, heart-rate readings, nights of sleep, other health types, and the files that were skipped and why.
- Press “Build my export” and download
fittakeout-export.zip.
4. What you get, and what to do with each file
| File | Contents | Use it in |
|---|---|---|
google-fit-history.xlsx | Sheets Daily, Workouts, Weight, Heart rate, Sleep. Numbers as numbers, dates as dates. | Excel, Google Sheets, LibreOffice, Numbers |
daily.csv | One row per day with every column found in any daily file. Sums for steps, calories, distance, minutes, points and durations; maximum of “Max” columns, minimum of “Min” columns; distance in km and miles; durations in minutes; sleep minutes and weight of the day. | Any spreadsheet or script |
workouts.csv | One row per session: local start and end, activity, duration, distance, calories, steps, heart points, points with GPS, and the name of its TCX and GPX file. | Any spreadsheet |
weight.csv | Date-time (UTC and local), kg, lb, source. | Any spreadsheet |
heart-rate.csv | Every reading: date-time, bpm, source. | Any spreadsheet |
sleep.csv, sleep-nights.csv | Segments with stage; and one row per night with minutes asleep and per stage. | Any spreadsheet |
other-….csv | Any other health type in your export: height, blood pressure, blood glucose, oxygen saturation, body fat, body temperature, nutrition, hydration… | Any spreadsheet |
workouts/tcx/ | Each original TCX, unchanged, renamed like 2020-10-17 2105 Walking.tcx. | Strava, Garmin Connect |
workouts/gpx/ | A GPX 1.1 file for each workout with at least 2 GPS points: latitude, longitude, elevation, time, heart rate when present. | Strava, Garmin Connect, mapping tools |
README.txt | What each file is, which time zone was used, and what was skipped and why. | Read it first |
About averages: an “Average” column (speed, heart rate) is Google’s own figure for the day when the export includes Google’s summary file. Without that file it is the plain mean of the 15-minute rows that have a value, which is close to, but not the same as, the number the app showed.
5. Upload workouts to Strava
Strava’s help says it accepts TCX, FIT and GPX files, each 25 MB or smaller, up to 25 at a time for subscribers and 15 at a time for others: “How Do I Bulk Upload Activities to Strava?” and “How do I Get My Activities to Strava?”. Put the files you want in one folder, log in on the Strava website, open the upload page for files, and select them in batches of that size. Use the GPX or the TCX of a workout, not both, or you will get it twice.
6. Import workouts into Garmin Connect
Garmin’s help page “How to Manually Upload Activities to Garmin Connect” lists .fit, .gpx and .tcx files and describes the “Import Data” option on the Garmin Connect website. Check that page for the current size limits before a large import. Steps, weight and sleep are not imported this way.
7. Apple Health and Samsung Health
FitTakeout does not write into either app. We found no screen in Apple’s Health app or in Samsung Health for importing a CSV, TCX or GPX file of past steps or workouts, so there is no file we could produce for them. On Android, Google Fit can sync with Health Connect, Google’s way of sharing data between health apps (Google Fit Help, “Health Connect on Google Fit”); what another app reads from Health Connect is up to that app. Your full history stays with you as a spreadsheet either way.
Do it in your browser
Add your Takeout ZIP. FitTakeout shows what is inside, then gives you one Excel workbook, the CSV files and your workouts as TCX and GPX. Nothing is installed and nothing is uploaded. Free: the whole daily table, the first 5 workouts and the first 30 records of each health record. Full: $9 one-time.
Convert my Fit exportWhat it does not do
- It does not import into Apple Health, Samsung Health or Garmin directly. It gives you files.
- It does not read the per-sample files for steps, distance, speed, calories, activity segments and location. You get those per day, from the daily files.
- It does not read a ZIP64 archive (one ZIP over 4 GB): unzip it and add the folder. A needed file over 150 MB is skipped and reported.
- It has been tested with exports from English-language accounts.
- It is not a Google product.
FAQ
Do I have to unzip the Takeout file?
No. Add the ZIP as it is. Only the files that are needed are read from it.
Does it work on a Mac or a Chromebook?
Yes. It runs in a current browser on Windows, Mac, Linux or ChromeOS.
Are the times converted?
Daily rows keep Google’s day. Workout times are the local times in Google’s file names. Health records are written in UTC and in the time zone of your browser.
Is anything uploaded?
No. The files are read in your browser and the ZIP is built there.