Garmin connect is a great place to collect all of your fitness data together from your weight to calories burnt etc.
Recently I was asked if I could get the weight at a out of the site for use in EXCEL so I had a little dig around and found the following:
Once you are logged into the Garmin Connect portal you can then copy/paste this URL into your browser bar hit return and you’ll see the data.
Copy and paste the WHOLE document or save it to your hard drive and then head to https://json-csv.com/ where you can convert that data to a CSV for use in Excel etc
To edit the start and end dates you will need to use the website https://www.epochconverter.com/ and replace the numbers in from=[FROM EPOCH] and until=[TO EPOCH]
Thanks for this – a bit tricky to get to work. First, the second number in the link needs to be an Epoch number for the last date you want. That converts to May 30, 2018. You need to replace it with the last date in your string using the Epoch converter link, followed by 4 9’s
Once you have the data into an Excel spreadsheet, you don’t need the Epoch converter, just use this link to convert the Epoch date to a readable date (atlhough for Mac I found you need to use 1900 not 1904) to get the right date).
Finally, in Excel, if you want to convert to pounds, use this formula, with [cell] equalling the cell with the weight figures (appearing in grams).
Thanks for the extra work on this. I got the data my friend needed but this is all very helpful. I’ll probably create form to get the data out soon 🙂
This is useful – thanks. I made a python script to plot the data and convert to CSV:
Thanks a lot for this
Would this be possible for all the other data ?
Like heart rate, stress levels minute by minute, etc ?
To get Heart Rate info from Garmin Connect try this:
Again you’ll need to be logged in first. If anyone can help with a programatic way of logging in I’d be happy to find it 🙂
curl -b cookies-connect-garmin-com.txt https://connect.garmin.com/modern/proxy/userprofile-service/userprofile/personal-information/weightWithOutbound/
you can export the connect.garmin.com cookie from Mozilla Firefox as follows:
(make sure you have “remember me” option set when logging in to connect.garmin.com)
Have you made any progress on the logging?
I know it needs to get the SESSIONID, but do not seem to be able to generate one.
I am not thinking Selenium for logging but was hoping an API route is aviabale.
Do you know the syntax to extract a range of dates data fro HeartRate, and maybe Sleep as well? Or only one at a time? https://connect.garmin.com/modern/proxy/wellness-service/wellness/dailySleep?date=2019-01-01
I’ve been wanting to track and compare my weight data with the various calorie data, specifically the “Calories Remaining” data. My goal is to correlate weight changes over time with remaining calorie data. Where are you guys finding these URLs and parameter names (e.g. weightWithOutbound, dailyHeartRate, dailySleep) for exporting data? Is this documented anywhere? I’d love to extract more of my personal data from Garmin Connect and post process it myself.
So there is only one entry per day? Your last measurement gets replaced? Too bad…
If you want a days worth of heart rate info try the following:
Do you guys get complete weight data using this method? Even if if set the epoch values until current date, the last data I get is from 2018.
Bit late, but the last epoch-date needs to be appended with 9999.
How to export weight data to garmin Connect?
I’ve been using this method for years now to periodically download and graph my data, But it recently stopped working. I just get a “402 – page not found”, when I click on the link. Anyone else got the same problem? And more importantly, any idea how to fix it?
me too… very sad
Has there been any resolution to the “402 – page not found” issue. I have also used this for several years and am disappointed to lose the functionality.