This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to import data weight to garmin

Jan502 over 5 years ago

I don't have garmin weight scales and I would like to export from excel to garmin Connect all my historical weight.

How to do that?

In the icon cloud there is possibility to export

Body
Date,Weight,BMI,Fat,
12-02-2020,100.8,29.1,28.4,45.1

What about other data how to export?

I am not sure which parameter i should use to exper other data

Regarding link https://jhartman.pl/2016/12/10/withings-to-garmin-connect/

https://github.com/jaroslawhartman/withings-garmin-v2/commit/f174212d209829c116cd7d39d3dfd28a7df444da

+class Measurements(object):
+ # M or F
+ gender = 'M'
+ def getWeight(self):
+ return 100
+ def getPercentFat(self):
+ return 100
+ # www.medcalc.com/tbw.html
+ def getPercentHydration(self):
+ return
+ def getVisceralFatMass(self):
+ return 100
+ def getBoneMass(self):
+ return 100
+ def getMuscleMass(self):
+ return 100
+ def getActiveMet(self):
+ return 100
+ def getActiveMet(self):
+ return 100
+ def getPhysiqueRating(self):
+ return 100
+ def getMetabolicAge(self):
+ return 100
+ def getVisceralFatRating(self):
+ return 100

Top Replies

All Replies

0 7401252 over 4 years ago in reply to trux

Trux- it worked, finally. I had viewed examples in the forum as if they were concatenated with commas between (instead of actual columns). Your example zip was immensely helpful. Thank you!

0 trux over 4 years ago in reply to 7401252

7401252 said:
I had viewed examples in the forum as if they were concatenated with commas between (instead of actual columns). Your example zip was immensely helpful.

The zipped example was in exactly the same format as all the sample code I provided earlier in this thread too. None of them was using any columns, It was always just a Comma-Separated list of Values (CSV). All you needed to do was copying and pasting the code into a csv file, using a simple text editor, such as Notepad.

0 KrapfenKringel over 4 years ago in reply to trux

Im' trying to get this to work, can't see my error. Even tried my values with , instead of . as its setup in my accout, but this just gives the error message faster. Also noticed that BMI is shown with . in Garmin Web while weight and fat uses , so I even tried to do that with the file, but no.

Body
Date,Weight,BMI,Fat
"2021-09-08","73.4","23.2","16.5"
"2021-09-03","73.7","23.3","18.2"
"2021-09-01","73.3","23.1","18.7"
"2021-08-26","73.8","23.3","18.0"
"2021-08-20","74.2","23.4","17.8"
"2021-08-12","74.7","23.6","18.3"
"2021-08-07","75.0","23.7","17.9"
"2021-07-25","74.5","23.5","19,1"
"2021-07-17","74.1","23.4","17.8"
"2021-07-09","74.2","23.4","18.9"
"2021-07-04","74.7","23.6","18.9"
"2021-06-29","74.3","23.5","18.4"
"2021-06-26","74.1","23.4","18.2"
"2021-06-19","74.0","23.4","17.8"
"2021-06-17","74.9","23.4","18.2"
"2021-06-15","74.2","23.4","17.7"
"2021-06-12","74.2","23.4","18.0"
"2021-06-09","74.7","23.6","17.7"
"2021-06-06","74.0","23.4","17.5"
"2021-06-02","74.2","23.4","17.5"
"2021-05-28","73.5","23.2","18.8"
"2021-05-26","73.3","23.1"."18.7"
"2021-05-24","73.3","23.1","18.5"
"2021-05-17","72.8","23.0","18.3"
"2021-05-15","73.0","23.1","16.9"
"2021-05-12","73.4","23.2","18.4"
"2021-05-10","73.4","22.9","18.5"

0 MJunge75 over 3 years ago in reply to KrapfenKringel

Hope this helps someone:
After reading through this and several other threads and experimenting with different combinations, I was able to transform my Withings weight data and import it to Garmin successfully. I didn't encounter any limitations and was able to import my data for one year with >80 measurements in one step.

Maybe the confusion in this thread is a result of different language settings at Garmin and the values in the file.
I'm using the Garmin website in 'German' as my primary language.

I did test it with different combinations (without quotes, dots instead of commas, semicolons instead of commas), nothing but a CSV-file with this format has worked:

Body
Date,Weight,BMI,Fat
"02-01-2022","75,4","23,27","14,10"
"01-01-2022","75,0","23,15","14,00"

The Garmin import is very picky about the file structure

The first line has to contain 'Body'
Second line 'column headers' in English
All next lines are the measurements encapsulated in double quotes and comma separated. The values have to use a comma as the decimal delimiter Also each measurement has to provide all three values. If a value is missing, the import fails.

Withings to Garmin - Step by step

Export Withings data and import the weight.csv to Excel (if the import doesn't work because of your language settings, replace all commas in the file first with semicolons in a text editor)
Keep only the Date, Weight and Fat column
Add a BMI column between Weight and Fat and calculate the BMI value
Export as CSV file
Open the CSV in a text editor and search/replace so that file looks like the example above
Import the file at Garmin, Choose English as language

0 junkyjunky over 3 years ago in reply to MJunge75

Thank you!!!! Just so everyone is sure, including the values inside quotations is very important regardless of your decimal format!

0 pshare over 3 years ago in reply to MJunge75

Take a look at this thread particularly near the end where a procedure is described. It won't help with history but it automates transfer of data going forward. If it works for Renpho I have to believe it works for Withings and other brands.

https://forums.garmin.com/apps-software/mobile-apps-web/f/garmin-connect-web/283812/syncing-weight-data-from-renpho-scale-to-the-garmin-app

0 Pramsent1 over 2 years ago in reply to MJunge75

I used exactly your structure and even your data (also german as language) but still not working - any advise?

0 junkyjunky over 2 years ago in reply to Pramsent1

Look up to MJunge75 response. The file needs to be a .CSV and be in the format posted above. For me, I built an excel file that looked like the following table, then saved as CSV. From their I opened it in a text editor to make sure the format stuck. I found it duplicated the quotation marks, so I had to do a find and replace to get it right.

Date	Weight	BMI	Fat
"24-09-2022"	"175.4"	"23.8"	"17.8"

0 KrapfenKringel over 2 years ago in reply to Pramsent1

I got it working but I can't remember how it did it, it's been to long already.

Ok I tried it again I got it working in this format using a *csv file:

Body
Date,Weight,BMI,Fat
"2021-09-08","73.4","23.2","16.5"

Important is that after selecting the file you chose "language English" because that's whats used in the file and the correct number format, in this case using . as separator as . was used in this example, if you use , in your data it should work to, but select the correct one. The other settings were fine on standard for me.

0 MJunge75 over 2 years ago in reply to Pramsent1

Pramsent1
I'll import my own weight data since February and check my own instructions above while doing that ;-)
At latest during the weekend, I'll leave an updated post here.