ramblings about cars, tech, web development and more. BOTB Winner in 2010

Exporting Weight data from Garmin Connect

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]



Adding days to a date in Excel


Validate MRZ passport numbers with Regex and PHP


  1. ah

    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).

    =CONVERT([cell],”g”, “lbm”)

    • 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 🙂

  2. D. Anderson

    This is useful – thanks. I made a python script to plot the data and convert to CSV:

  3. Josenivaldo Benito

    Thanks a lot for this

  4. Yorgo

    Would this be possible for all the other data ?
    Like heart rate, stress levels minute by minute, etc ?

  5. Nic B

    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

  6. Josh

    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.

  7. Johann

    So there is only one entry per day? Your last measurement gets replaced? Too bad…

  8. 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.

    • Gert-Jan

      Bit late, but the last epoch-date needs to be appended with 9999.

  9. Pap

    How to export weight data to garmin Connect?

  10. Thomas

    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?


  11. ML

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by WordPress & Theme by Anders Norén