Related
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

Import weight history

Butscut
over 6 years ago

Hi,

I have 5 years of weight history exported from my withings scale via Nokia's health mate app. Data is in a CSV format. 

I am trying to import the data to garmin connect but the import fails each time. 

I have scoured the web and discovered that the csv file needs to be formatted like below, which I have copied exactly. Still no luck. 

I then tried to delete 90% of the data and only import a few weeks pf data. that failed to. 

Can someone at garmin please advise what the correct format is within the csv file that contains my weight history so that I can successfully upload this data. 

Many thanks

Body
Date Weight BMI Fat
11/05/2019        72.27             -               -  
12/05/2019        72.78             -               -  
18/05/2019        73.91             -               -  
19/05/2019        73.40             -               -  
20/05/2019        72.98             -               -  
21/05/2019        72.47             -               -  
  • 0 over 5 years ago in reply to Former Member

    From the info I've seen on the FitBit sites, the two headers come from the fact that the exported data can have several sections, such as Body, Activity, etc. So the first header is really the section marker and the second the column headers.

  • Former Member
    0 Former Member over 5 years ago in reply to Former Member

    I was looking for this! I formatted data as in your example and import was successful :) 

  • 0 over 5 years ago in reply to Former Member

    this was KEY.  i tried a lot of different ways but only after adding the BMI and Fat columns with 0 data did it work.

    Body
    Date,Weight,BMI,Fat
    dd-mm-yyyy,200,0,0
    ...

    thanks for the help,

  • 0 over 5 years ago in reply to BHOMSY

    The only thing I've had issues with when uploading data in the above mentioned format is that Garmin also adds a weigh-in time which throws off what date depending on when the time the data is uploaded. In order for the weight data to be uploaded to the correct Date, I have to change the Date by +1 day. For example, if my weight in was on 2020-08-06 (yyyy-mm-dd format), in order to upload to Garmin on that date, I have to change it to 2020-08-07 (yyyy-mm-dd). I normally upload my weight data in the morning and I noticed that Garmin defaults the time at which the weight-in occurred as 8:00 PM. So, if I upload data for today's date before 8:00 PM, Garmin will upload it to the day before. Any ideas on how to change this?

  • 0 over 5 years ago in reply to TAROBERTSMHC
    TAROBERTSMHC said:
    Any ideas on how to change this?

    You can try adjusting the parameter Upload Time Zone in User Settings » Display Preferences

  • 0 over 5 years ago in reply to trux

    I have it set to the correct timezone and it seems no matter what time of day I upload the weight data, it sets the weigh-in time at 8:00 PM. I saw this setting and figured it was for uploading of activities recorded on Garmin device not for importing data?

  • 0 over 4 years ago in reply to Former Member

    any possibility to upload Hydration and Muscle data???

  • 0 over 1 year ago in reply to Former Member

    I was able to import it as well, but the data does not show anywhere. Did you have the same issue?

  • 0 over 1 year ago

    Hi,

    please is there anybody who can provide correct format example for the import? I already tested everything I found via Google, every time it just say "Import Complete" but no data imported. Dont understand why Garmin keeps this as secret, I would expect some example or how to. 

    Thanks for help!

  • 0 over 1 year ago in reply to 7933931

    You can find the right format in countless threads here on the forum (including this thread). I am using this one:

    Body
Date,Weight,BMI,Fat
"2024-02-18","70.8","20.6","14.4"
"2024-02-19","71.2","20.7","14.6"
"2024-02-20","71.2","20.7","14.6"