Fitbit Aria Weight Data Export Download

Summary

The Fitbit Aria scale automatically uploads your daily weight and percent body fat measurements to the cloud. This data is available when logged into the Fitbit website.

You can see charts of your progress, and a list of the 10 most recent weigh-ins. Your comprehensive data can be downloaded as an Excel workbook here https://www.fitbit.com/export/user/data

Download Feature Missing Data

If you use the download feature, the resulting download is limited. For example, the time of your weigh ins will be missing, and if you’ve been tracking your high and low weight for the day, that information will be lost. Only one weight per day is provided in the download. Another example of missing data is with sleep tracking. The download doesn’t include when you went to bed and when you woke up.

On the Fitbit data download page, you’ll find this statement: “Your data belongs to you.” It’s great that they make some provision for getting data out of their site. However, it’s odd that they wouldn’t just allow the download of all the data including the details that are actually there.

How to Get Your Detailed Weigh-in Data

To get your detailed weight data, including the time of weigh-in and multiple measurements per day, follow these steps:

  1. Login to the Fitbit website.
  2. Go to this page https://www.fitbit.com/weight
  3. Scroll down to see Measurement History.
  4. Click the Load 10 more option.
  5. Keep clicking the button to reveal as much data as you’d like. Unfortunately, if you’ve been using Fitbit for years and only just recently decided you’d like your detailed data, you’ll need to click the Load 10 more button a lot of times to see all your data.
  6. Once you’ve revealed as much as you want, highlight all the values and then copy them (using CTRL+C or the right mouse click menu).
  7. Paste this information into Notepad (on Windows) or TextEdit (on Mac).
  8. Select all the text and then copy and paste it into Microsoft Word. Putting the text into Notepad or TextEdit first helps to remove the formatting from the text. This can also be done within Word, but people may find it easier to use these intermediary programs instead.
  9. Use the Replace function in Word (found under Edit > Find in some versions) to make the following replacements:
    1. Replace the days of the week with nothing. Be sure to include the comma and space. This will help cleanup the date information so it can be recognized by Excel. So, as an example, replace “Sunday, ” with nothing. Do this for all days of the week.
    2. Replace the word ” at ” including the spaces around it with the year for the exported data. This will make the data information complete and recognizable by Excel later.
    3. Replace “Delete Measurement” with “^t” which is the symbol for a tab. This will put a tab between the date  and the weight measurement that follows.
    4. Replace ” kg ” with “^t” to insert a tab separator there. Or, if you used pounds then replace ” lb ” with a tab.
    5. Replace “% fat” with nothing. This will remove the % symbol and the word fat.
    6. If you had some weight measurements that didn’t include the percent body fat, then your previous replacement of ” kg ” would not have replaced the kg where there was no space after kg. So, replace ” kg” with nothing to ensure it’s gone. This needs to be done last because for the other entries, a tab needs to be inserted.
  10. At this point, you should be left with a clean listing of entries for your weigh-ins. Copy and paste this into Excel.
  11. Excel should automatically place the data in separate columns.
  12. Now you have your detailed weigh-in data.

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s