Unable to import Fitbit data -- An error occurred with your upload. Please try again.

I just struggled for a few hours getting my historical weight information in to Garmin Connect, but just had a breakthrough that worked for me...and I figured I'd share for others for two reasons...

(1) my historical weight data was coming from a Nokia Withings scale and NOT from Fitbit
(2) even when I followed the steps in post #33, it wasn't quite working

For my ongoing weight data, I am syncing my Withings Weight to MyFitnessPal to Garmin Connect. I LOVE my new Slate VivoActive3 with an aftermarket black steel band and really wanted all my data in one place. Unfortunately, Connect doesn't sync directly with the Withings! But Withings + MFP calories + Garmin fitness mostly works for me.

My process to accomplish this was

1. Follow the steps in post #33 above to download a few records of data from an old Fitbit account. I actually used my wife's data. I'll attach a mostly empty file to this post other can use...

2. Download my entire Withings weight history from https://account.health.nokia.com/export/account_login?b=my_data (or any other weight source you have I guess)

2a. First thing I did to my data file was to look for duplicate dates (where I had two weigh-ins for some reason) and delete any 2nd (or subsequent) weights for any given day. I don't know if this is necessary or not, but it was one of the steps I took along the way to clean my raw data as I kept getting import failures.

3. Open the Fitfit file in Excel and paste in your date and weight columns into excel Cols A and B below the dummy / old data

4. It appears that Garmin Connect prefers dates and numbers in 'text' format (even in Excel) and that's the way the Fitbit data file is formatted.

4a. However, when you paste in your own data from Withings or another source, you will notice that it is NOT in text format since Excel prefers to format #s as #s and dates as dates. In my case, my Fitbit file had the data left justified, but my own data when pasted in was right justifed in a number/date format. Accordingly, I needed to transform my data into these formats and create blank data for any missing data (for me, I didn't have or want to load BMI or Fat data and they were in the file by default so I just put in 0s.

4b. Off to the right of your data, put the equation =TEXT(_Your_date_reference_cell,"yyyy-mm-dd") and copy it down the length of your entire data set. This will convert the date field into a properly formatted date as text.

4b. Off to the right of your Weight, BMI, and Fat columns, put the equation =TEXT(_Your_weight_reference_cell,"0.00") and copy it across 3 columns and down the length of your entire data set. This will convert the weight, BMI, and Fat fields into a properly formatted data as text.

4c. Copy these columns from your new equations and past them as "Paste-Special_as-values' underneath your old raw data

4d. If you didn't have BMI and Fat data like me, make sure you have 0.00 showing in the entire columns for those two fields. This was the last thing I corrected before my import actually worked. I had left them as blank rather than putting in 0s. Once I made this correction the import process completed successfully and my weight data showed up almost instantly in my weight graphs.

4e. Don't forget to delete your old raw data at the top and any of the helper equations you used to transform the dates and data formats. Only thing remaining in your file should be four columns in A, B, C, D. Headers in row 1. and your transformed data going down as many rows deep as needed.

After doing the above (and 15-20 intermediate tries to get this working), the import process finally completed successfully.

Since I still had some issues even after trying post #33 above (many thanks to superflask), I thought I would elaborate on my subsequent steps that ended in success!

Happy to help if anyone else has issues with my approach and example file.

greeenawayj