Motion Based offered an export function that made it possible to export running totals (duration, average speed, average heartbeat, average pace etc.) of multiple activities to MS Excel. Garmin Connect seems to lack this option, which would be very dissapointing since I used to export these data to MS Excel for further analyses and graphs. Am I right that there is no such export function anymore? Or do I fail to see it?
I don't know why anyone would try to bring a raw TCX into Excel, Excel can read any ASCII format, that doesn't mean that it should be used to do this.
The data needs to be in x, y, z1, z2, z3, z4..... format. TCX Converter does exactly this, and allows you to save to *.csv. Try it and see, I think it will allow you to get over most of your problems. I like the fact that I can control the axis scale of any charts I produce. When I go for a run, the initial rise of my heart rate from 60 to 130 + bpm is not interesting. The variations around150 are.
you can. please click the player link at the top of your detailed page, move the marker to the desired location and you can see the detailed summary for that location/time
I don't know why anyone would try to bring a raw TCX into Excel, Excel can read any ASCII format, that doesn't mean that it should be used to do this.
The data needs to be in x, y, z1, z2, z3, z4..... format. TCX Converter does exactly this, and allows you to save to *.csv. Try it and see, I think it will allow you to get over most of your problems. I like the fact that I can control the axis scale of any charts I produce. When I go for a run, the initial rise of my heart rate from 60 to 130 + bpm is not interesting. The variations around150 are.
Cheers
Jim
I tried tcx converter and I am sure I did something wrong. I let it do it's conversion thing and then saved as csv. I was hoping to see some nice simply laid out information in the columns but what I got was way too complicated and a bit like a raw tcx (although much simplified).
feature request is noted :-) thanks for the input and we'll get to it when we can.
devon
Hi Devon,
Please put me down for requesting this feature as well. I have little use for exporting weekly/monthly averages of my activities. I need to see each and every activity listed with its individual stats (avg hrt rate, max hrt rate, avg speed, max speed, etc.)
Motion Based offered an export function that made it possible to export running totals (duration, average speed, average heartbeat, average pace etc.) of multiple activities to MS Excel. Garmin Connect seems to lack this option, which would be very dissapointing since I used to export these data to MS Excel for further analyses and graphs. Am I right that there is no such export function anymore? Or do I fail to see it?
I was able to export to Excel using Garmin Training Center, although the process wasn't exactly streamlined. It took some additional steps because Garmin insert's random " marks around the commas on the export. I put full step-by-step instructions on my blog:
Mike Soltys. Tried your blog method in Garmin Connect 2017 version. Almost worked! Only issue is the Titles did not get separated out, because commas are not recognised as delimiters. Bit laborious then to retype the titles in correct place.
I used another method.
On the Garmin Connect page select Import CSV . You get a new web window with the data (not a csv file at all - what a Garmin cheat!) . Copy All data and paste into a blank Excel file. The problem here is that the elevation numbers are in format 1,234. This will screw up comma delimiting. Simply Reformat all numbers which have a comma included as a plain number. Do Replace ?1, with ?1 (Replace All), Dtto for "2 , to "2 , ditto for 3. This should clean up all the elevation numbers in meters. . If you use feet maybe you need to go a bit higher.! Save as csv file. Open new Excel file. Importing the csv file: Deselect all delimiters. Select delimiter Comma, and text delimiter None. Import. Replace all the " with nothing. Done.
