Export activities to csv/xls

Hello,

How can I download a report on my activities for the last 6 months to a csv or excel file?

I’m looking at my activities in ‘list’ format, and I select and customize columns, but would be great if I could export that report to my laptop for additional anaylsis.

Is this possible?

If you can access the “curl” command line application (maybe so on a Mac), https://forum.intervals.icu/t/api-access-to-intervals-icu/609 may be helpful.

I’m not sure about a web interface though.

You can find a CSV download option for activity summary data in /activities/options

1 Like

That’s useful, but what I wanted to find was to do a bulk export, from the report, would be a bulk export, and allowing to choose what columns to export, like you can view (but not download) on the ‘activities’ view page below

Have you tried the download? What you are describing sounds like what it gives you - just you’ll have to discard the “extra” columns yourself when open the csv in your preferred programme. But if you’re bothering to do extra analysis that doesn’t seem like much of a hurdle.

1 Like

Agreed, that’s what i’ve been doing discarding the extra columns and rows, was looking for additional control on the export

I have this on the todo list and should get to it soon.

Is this maybe available somewhere already?

Not yet …

@david

My latest CSV export doesn’t show data for each day, eg. the icu_resting_hr column has data for a day, then blank cells, another cell with data and then more blank cells.

Does it only pull from Garmin, or is the daily HRV data in this column too? I don’t wear my Garmin 24/7 and use the HRV4Training app to send to Dropbox daily.

Edit: I know it’s the FIT file a it shows at the end of the table, but is there anyway to get the rest of the data entered manually, or from Dropbox, into that same table?

The activity CSV download only includes activities and the wellness fields (resting HR, weight) that get copied onto those. The wellness CSV download has a record for every day and includes everything selected:

1 Like

Thanks, never though to look in the wellness list to see the download option.

Is there a way to include the external id in the export? @david Is this an easy change?

I just added that.

2 Likes

@david
On the activities.csv download, there are some fields missing from the report. It also doesn’t allow these fields to be added when getting data using Excel’s Power Query. I use this method to automatically retrieve the data instead of manually downloading the activities.csv file.
image

Missing fields, that show in the API call.

  • feel
  • coach_tick
  • total_elevation_gain
  • icu_power_hr"

There may be more, but these are the ones I’m hoping will be added, please.

Below is an example of “feel” showing in the API, but not in he CSV export and Excel.
image

Here are the error messages when trying to add these to the Power Query expression in Excel.