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

Historically backdating weight data from myfitnesspal to garmin connect

Former Member over 5 years ago

apologies if this has already been answered, I can’t find ANYTHING online for this.

i recently downloaded GC and synced everything up with MFP, only thing I’ve noticed is GC can only sync body weight data from MFP from the moment it connects, and I can’t find any way to get my historical MFP weight data into GC.

has anyone found a way to do this?

tried manually constructing a CSV file from MFP export but this has errors when uploading always, and I can’t find a template anywhere.

Garmin aren’t being massively helpful on it and keep linking me to all the import and export articles, which I’ve tried following and still doesn’t solve it.

any thoughts?

thanks in advance!

Top Replies

All Replies

0 trux over 5 years ago

Seeing that in Garmin Connect you can import FitBit weight logs, I would create an account at FitBit, enter there some weight data for a day or two, export it, and then edit the MFP file to match exactly the same format. Alternatively you can ask someone with a FitBit account to send you a sample weight log file, but i think doing it yourself would be quicker.

0 Former Member over 5 years ago in reply to trux

That is genius I have no idea why that didn’t occur to me *face palm*

will do that right now thanks so much!

I’ll update on here if it works, just in case anyone else has the same issue.

thanks again!

0 Former Member over 5 years ago in reply to trux

I’ve done it!

i did your method and was still having issues but after an hour of trawling excel columns the issue is with excel - if you are constructing your own file like me, unless you have a fancy macro running the file won’t save in the proper CSV format with “quotes” around the text fields.

i checked mine in a txt editor and found this was the case with my SEVEN different versions I had saved tinkering around with the formats.

i added quotes around the text fields and suddenly it uploaded successfully with a year of backdated data - happy days.

my experience - if anyone is looking to construct their own file or has issues like the above, make sure you have the below fields in your file formatted like the below:

“Body”

“Date” | “Weight” | “BMI” | “Fat”

did-my-yyyy | 00.0 | 00.00 | 0.00

hope that helps!

p.s - found when saving the excel as a csv with quotes it added extra quotes when viewing the txt file, so you have to go into the txt file and take out the extra quotes, then resave as a .csv and import which SHOULD work!

0 trux over 5 years ago in reply to Former Member

Nice! Thanks for the feedback!

0 4905986 over 3 years ago in reply to trux

In case anyone like me is still battling with this, I have found a solution (long winded!) but works!

My data was from a Sanitas (Lidl) scale and data can be downloaded from the online account.

Specific to this situation, the dates on the downloaded data aren't consistent!! It records the last part of the month with digits greater than 12 as DD/MM/YYYY but for the first part of the month as MM/DD/YYYY so need to check the downloaded data and amend as needed

(I used excel to separate text to columns with / as the delimiter, then formula =DATE(YYYY,MM,DD) in a 4th column, then copied and pasted values only to a 5th column (pre-formatted with the correct date type), and then deleted the first 4 columns).

The data then needs saving as a .csv file and I opened each file in Notepad to check for extra commas etc.

This was the format I found that worked - no inverted commas anywhere!! (after trying all the options with inverted commas suggested).

(I made sure all the data had the same number of decimal places etc. just to be on the safe side)

Body

Date, Weight, BMI, Fat

30/09/2021,58.1,20.1,19.4

29/09/2021,58.4,20.3,19.5

etc.

Hope it helps!