I am tryng to export an entire stream of data from GC so that I can have second-by-second data (simplest example HR and time, watch is set for 1 second recording) into excel. I seem to be only able to download each lap (even downloading TCX file gives multiple lines, but they are the same data over and over until the next lap). Any advice?
Triathlon Forum
Login required to started new threads
Login required to post replies
Re: How to export ALL data from Garmin connect to Excel (or matlab) [J_R]
[ In reply to ]
This is kind of a roundabout way to do it. Set up Garmin Connect to sync to strava, then once everything has moved over to strava go to their settings page and export all your activities?
Re: How to export ALL data from Garmin connect to Excel (or matlab) [J_R]
[ In reply to ]
I'm not familiar with any GC API, but my guess would be that the "stream of data" you are looking for is the file for the activity. What is a TXP file?
In GC, click the gear icon in the top right (I'm in modern view), then click "Export to TCX". Specifications for tcx XML are here: https://en.wikipedia.org/.../Training_Center_XML. From there you can play around with getting it into Excel/Matlab/whatever. Maybe something like this https://forums.garmin.com/...d-analyze-with-Excel
In GC, click the gear icon in the top right (I'm in modern view), then click "Export to TCX". Specifications for tcx XML are here: https://en.wikipedia.org/.../Training_Center_XML. From there you can play around with getting it into Excel/Matlab/whatever. Maybe something like this https://forums.garmin.com/...d-analyze-with-Excel
Re: How to export ALL data from Garmin connect to Excel (or matlab) [mcnnr27]
[ In reply to ]
mcnnr27 wrote:
I'm not familiar with any GC API, but my guess would be that the "stream of data" you are looking for is the file for the activity. What is a TXP file? In GC, click the gear icon in the top right (I'm in modern view), then click "Export to TCX". Specifications for tcx XML are here: https://en.wikipedia.org/.../Training_Center_XML. From there you can play around with getting it into Excel/Matlab/whatever. Maybe something like this https://forums.garmin.com/...d-analyze-with-Excel
Typo, TCX. Edited.
I was able to get one TCX to Excel on one smaller file. The "time" is the GPS time of day, with no running time, but oh well. Kind of frustrating that they have a nice export to CSV, but only for the splits.
Re: How to export ALL data from Garmin connect to Excel (or matlab) [J_R]
[ In reply to ]
J_R wrote:
mcnnr27 wrote:
I'm not familiar with any GC API, but my guess would be that the "stream of data" you are looking for is the file for the activity. What is a TXP file? In GC, click the gear icon in the top right (I'm in modern view), then click "Export to TCX". Specifications for tcx XML are here: https://en.wikipedia.org/.../Training_Center_XML. From there you can play around with getting it into Excel/Matlab/whatever. Maybe something like this https://forums.garmin.com/...d-analyze-with-Excel
Typo, TCX. Edited.
I was able to get one TCX to Excel on one smaller file. The "time" is the GPS time of day, with no running time, but oh well. Kind of frustrating that they have a nice export to CSV, but only for the splits.
Yes the data points go by time of day, usually GMT if I recall. What do you mean by running time? Elapsed time into the run? How about (time at current point - time at first point)?
Re: How to export ALL data from Garmin connect to Excel (or matlab) [J_R]
[ In reply to ]
You can load a TCX file into Golden Cheetah and then export to a CSV file. You will get time, distance, speed, altitude, HR, power, cadence but not things such lat/long
If for many files you could get tapiriik to sync Garmin Connect to a dropbox folder, suck all the files into Golden Cheetah and do a batch export to CSV files. (I think, have not tried this)
If for many files you could get tapiriik to sync Garmin Connect to a dropbox folder, suck all the files into Golden Cheetah and do a batch export to CSV files. (I think, have not tried this)
Re: How to export ALL data from Garmin connect to Excel (or matlab) [J_R]
[ In reply to ]
What have you done with the original files that were recorded on your device? The location of the recorded data from your device is generally accessible on your computer or on the device itself if a mass storage device. If you can access those then another option is to download Garmin Training Centre and import your files into that. From there you can export as .csv to Excel. GTC is no longer supported but still works. Be cautious if you do try bulk export as it did have a habit of falling over when stressed.
Trust me I’m a doctor!
Well, I have a PhD :-)
Trust me I’m a doctor!
Well, I have a PhD :-)
Last edited by:
PhilipShambrook: Oct 8, 15 15:35
Re: How to export ALL data from Garmin connect to Excel (or matlab) [marcag]
[ In reply to ]
marcag wrote:
You can load a TCX file into Golden Cheetah and then export to a CSV file. You will get time, distance, speed, altitude, HR, power, cadence but not things such lat/longOnce you have the file imported to Golden Cheetah you can copy/paste all data from the Edit tab to Excel.
The next version (3.3, scheduled to end of the year) will have an API to access all the data, including metrics and metadata directly from R/Python/Orange/Matlab/etc
Ale Martinez
www.amtriathlon.com
Re: How to export ALL data from Garmin connect to Excel (or matlab) [Ale Martinez]
[ In reply to ]
Ale Martinez wrote:
marcag wrote:
You can load a TCX file into Golden Cheetah and then export to a CSV file. You will get time, distance, speed, altitude, HR, power, cadence but not things such lat/longOnce you have the file imported to Golden Cheetah you can copy/paste all data from the Edit tab to Excel.
The next version (3.3, scheduled to end of the year) will have an API to access all the data, including metrics and metadata directly from R/Python/Orange/Matlab/etc
Perfect. Golden Cheetah did the trick. Thanks all!