Strava guides 3 MIN READ
Get your Strava activities into Excel, Google Sheets or ChatGPT
Strava has no spreadsheet export on the activity page. The bulk export does the job: one CSV with every activity you have ever uploaded. How to get it, what the columns are, and what to do with it.
There is no spreadsheet button in Strava. The activity page exports track files, and the more menu has no CSV in it. The table you want exists, though — Strava writes it every time you request your account archive.
Get the CSV
- On strava.com, hover over your name (top right) and open Settings, then My Account.
- Under Download your account, choose Get Started and Request download.
- Strava emails a link when the archive is ready. It can take several hours for a large account.
Inside the zip is `activities.csv`: one row per activity, with the date, the name, the sport, the distance, the time, the elevation, and the filename of the matching track file in the `activities/` folder. The bulk export guide describes the rest of the archive; for a spreadsheet, the CSV is the only part you need.
Open it in Excel, Numbers or Google Sheets — it is a plain comma-separated file and needs no conversion. Distances are in metres in the raw file, so divide by a thousand or let the sheet do it.
What the table is good for
The things the Strava interface makes awkward: totals per month, per sport, per year; the longest ride of 2024 found by sorting one column; a count of how many times you ran on a Tuesday. A pivot table on `activities.csv` answers most questions people pay a training app to answer.
It is also the fastest way to find a specific activity's file. Sort by distance, read the filename column, and the track is sitting in the `activities/` folder under that name — useful when you want one particular effort on paper and cannot remember the date.
Feeding it to ChatGPT or Claude
Searches for "export Strava to ChatGPT" have appeared, and the answer is the same CSV. Upload `activities.csv` to the assistant and ask it what you want to know — the file is small, tabular and exactly the shape those tools handle well.
Two cautions. The CSV alone does not contain your routes, only the summaries; that is the version to share. The `.gpx` and `.fit.gz` files do contain every coordinate, including where you start and finish most days — think before uploading those anywhere. Sharing a route safely is about the same problem.
The summaries have a second life
A year of rows is also the raw material for a stats print: distance by month, the longest streak, the split between sports, the hours of the day you train. That is what the data prints draw — from your own numbers, either through a connected account or from this same archive. The spreadsheet tells you the answer; the print puts it on the wall.
Questions people actually ask
- Can you export Strava data to Excel?
- Yes, through the bulk export. Request your account archive from Settings → My Account on the website; the zip includes activities.csv, which opens in Excel, Numbers or Google Sheets.
- Is there a CSV export for a single Strava activity?
- No. The activity page exports GPX, the original file and TCX — all track files, none of them a table. The spreadsheet lives in the archive.
- How do I get my Strava data into ChatGPT or Claude?
- Upload activities.csv to the assistant and ask. It is a plain table with one row per activity, which is exactly what those tools read well. Do not upload the GPS files unless you want them to have your routes.
- Does the CSV contain the GPS points?
- No. The CSV is the summary — date, name, sport, distance, time, elevation and the name of the track file. The points are in the .fit.gz and .gpx files next to it.
YOURS, FROM A FILE, IN 90 SECONDS
One effort. One sheet of paper.
Bring the file and every choice is yours: paper, treatment, colour, which numbers come along. Uncoated matte in 250 or 170 gsm, made to order at the facility nearest you, rolled in a tube.
Print it. FROM 439 kr