Resyncing weight data

1

Can anyone tell me how to resync weight data for historic activities? When I started using Intervals my weight imported in lb’s rather kg’s . Does give me some impressive w/kg figures though.

2

Here’s how I would do it:

  1. Options
  2. Wellness
  3. Download the data (wellness.csv)
    Open in Excel
    Add a column next to the weight column
    =[column with weight] / 2.2
    Fill down
    Copy and paste as value into weight column
    Delete column with formula
    Make sure the date (column A) is in yyyy-mm-dd format
    Save
  4. Upload into wellness.
    image
    image828×1243 195 KB
3

Thanks, I’ll give that a go.

4

Also check:
Does it show Kilograms in Settings?

5

All done. Thanks for your help. The download csv brings the date wrong date format into excel. Easy to sort but might catch some people out. I may have done something wrong TBF.

6

I mentioned about the date format, as I have previously been caught out by it. The format is correct in the CSV file, so the computer’s format is the problem.

This is the data layout in the csv download file

image
image147×206 2.15 KB

7

Can I import CSV date with only date and weight columns, with proper headers? I have a lot of data in Withings (back from 2006) which I would import starting from 2017. Intervals have my weight data only since date when I connected Withings with Garmin.

8

Yes, you can do that.
Just make a csv with only date (in the correct format) and weight (in Kg or pd as in the settings units) and upload that.

image
image666×630 52.3 KB

Example
date,weight
2023-03-14,65.8
2023-03-13,66.1
2023-03-12,66.2

1 Like
9

Thank you, thats nice and easy way to do it.

1 Like
10

I did the import. Not so easy. If there happen to be workout that day and no weight entry in CSV file, it keeps old weight value. If there is new weight value import it replaces old workout weight.
That means that all workouts in past years still uses same weight and import worked only for rest days.

I could create in excel weight entry for every day in period I want to import, but that would mean instead 370 entries I would get 2723 entries, one for each day since Oct-1, 2015 (day I bought power meter).

That would mean slower charts probably and data in days where there was no actual weight-in.

Edit 2: a workaround: Is there a way to get CSV list with all the dates I have workout? Then I could do Excel magic and create weight entries for these dates based on my weight data.

11

Thanks for the question @Rob_Starkey and reply @Gerald, I’ve just successfully synced all my weight history since 2017 from the Android app Libra, after a little bit of cleaning up of the CSV to remove unused columns and duplicated entries :pray:

1 Like