This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Export everything from activities page to Excel

Former Member over 15 years ago

Hi,

I see this has been requested before, but I'd like to request it again. It would be very useful.

I'd like to be able to export my entire history (from the activities list) to Excel. My history is getting rather large and I am worried that if the Garmin servers ever go down catastrophically I would lose it all, so I would like a backup copy in xlsx format.

Hope you people at Garmin can do this at some point. It would be much appreciated.

Many thanks.

p.s - Thanks for coming up with the forerunner 405 cx. This was one expensive watch but it's some of the best money I've ever spent :)

0 Former Member over 14 years ago

I'm just seeing this thread now - 1.5 years later. It's unfortunate that one can still not export the activities list as a simple CSV file. Some workarounds that I've found: (1) parse the TCX file yourself (complex); (2) Use firefox to same the activities page as "complete HTML" then reopen this and export as TEXT (seems to get some of the information in a semi-organized fashion); and (3) Use the RSS feed data.

0 Former Member over 14 years ago

Customizing Activities

Since I have over 12 years of my daily run/bikes in Excel I have keen interest in exporting Garmin Connect "Activities" to Excel for safe keeping and further analysis. I think logically it belongs in the Reports section as a detailed report type.

As a temporary and imperfect Work Around here is what I am doing to get data into Excel.

1) At the end of a month and on the Activities screen I set the "show filter" to display the prior months activities. Then sort/add/remove columns appropriately.

2) Holding the cursor down I select all the displayed rows including titles and do a "Copy".

3) Paste into Excel worksheet. Delete rows with header garbage and other weird stuff that also gets inserted.

I am using a Mac / Firefox / Microsoft Office.

*Problems:
- For some reason if I don't select the titles then all data gets inserted into one single column in Excel.
- The Activity "Description" cannot be displayed so I can't transfer it.

I just saw this thread, and have been using the described work around myself. I can live with the clumsyness of the work around, but I really miss having the activity descriptions included. The stuff I write in the description makes the data much more valuable. Without it it is just a dry list of numbers. Has anyone found a work around for including descriptions yet ?

0 Former Member over 14 years ago

If the REPORT function had an additional option of "detail" (which would list the activities without summary breaks), then everything else already is in place to output the raw activity data to a .csv file.

0 Former Member over 13 years ago

Garmin isn't interested in their customers. Thay don't listen and the don't understand their customers. I hope that will change, but for now it is as it is...:mad: