json extract

[mikeemonkey]

Hi,

First time Ive tried to export my historical data, even though Ive been using FitBit since 2015. I wasnt  expecting a JSON format, is there any option to change to CSV?

Having to wrangle all these files (100's and different fomats) in Python to merge will be a pain in the a**. I can imagine a lot of user are less computer literate than me and wouldnt have a clue.

Am i missing an option setting somewhere?

TIA

[PureEvil]

@mikeemonkey,

Welcome to the community!

There are two options to download your data under your settings, the first option downloads as a CSV:

I hope this helps.

[mikeemonkey]

That's for the 31 days data not the full extract

[Rich_Laue]

Most spreadsheet programs are able to view JASON files @mikeemonkey 

[PureEvil]

@mikeemonkey,

I understand that downloading that way is only for one month at a time.  However, it takes about one minute to download each month (and I wasn't going that fast):

And, from your profile, it looks like you've been on Fitbit since 2015, so that's about 70 months?  Yes, that may be 70 minutes, but your original post was five days ago...  You would've been done many days ago by now.

I'm a software engineer and work on automation, and sometimes the best answer is to do it manually.

I hope this helps.

[mikeemonkey]

Thanks for the response. It looks like the only option is to write some pyhton code to merge these files.

The CSV/Excel ouput is aggregated to day level though, the JSON export is at a lower level of granularity. Thats why I didnt orginally go with this.

[HughDodson]

I don't 'wrangle in Python' (though I did once lead a 'Giant Python' team!), am not a computer programmer, have the same problem, and am not amused by Fitbit's output. My version of Excel does not seem to open files with this extension.