What's the easiest way to export the activities data to Excel in a tabular way?
The export option output is in Json but then to convert to CSV or XLS format is a hard task. The editors does not recognise the format and the conversion is not accurate.
Hi, in Garmin Connect website, go to the Activities page, and then click "Export CSV" at the upper right corner of the screen:
Hi, specifically what data you are looking for?
The "Export CSV" option exports the *summary* data from activities. In my case it exports 46 different data fields for each activity (yours may vary). As users we have no control over what data fields are included.
And yes it seems to export the data only for the activities that are currently displayed on the Activities page (which I agree is not helpful). To export for *all* activities in our history, we need to keep scrolling down the Activities page until we reach the beginning, and then use the Export CSV option. (In my case the file includes all of my 4+ years of activities.)
I think there is also a script-based way to export the summary data (in JSON only?) but I'm not familiar with it. There are other posts here on the forums that explain it. It's not a normal user interface feature of Garmin Connect.
If instead you want the actual *real-time* data from an activity (second by second) in CSV format, there is no direct option for that in Garmin Connect. We can only export the FIT files and then need a 3rd-party tool to convert them to CSV format (I prefer Fit File Repair Tool, but others such as Golden Cheetah might work too).
To export an activity's FIT file, click the gear icon at upper right corner, and then select "Export Original":
If we want the FIT files from many activities, we could request a bulk data download of all our Garmin account data by logging in here and selecting "Export Your Data". We eventually receive an email link to download a large zip file. The activity FIT files are in separate zip files in the folder DI_CONNECT > DI-Connect-Uploaded-Files. Unfortunately these FIT filenames do not match the activity numbers in Garmin Connect so we have to manually search for specific activities by trial and error. And in any case we still need to use a 3rd-party tool to convert the FIT files to CSV format.
