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.

https://connect.garmin.com/modern/proxy/userprofile-service/userprofile/personal-information/weightWithOutbound/filterByDay?from=1483228800&until=1527807599999
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]

 

2 thoughts on “Exporting Weight data from Garmin Connect

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

    https://stackoverflow.com/questions/15164237/how-do-i-convert-a-unix-epoch-timestamp-into-a-human-readable-date-time-in-excel/15164420

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

    1. 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 🙂

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.