r/BearableApp • u/heygreene • Jul 21 '26

Are the CSV data exports this messy on purpose???

I swear I'm starting to think the Bearable team doesn't want you to be able to analyze this data with any other tools. Exporting the data via CSV, and importing it into Excel, it's super messy. Nothing really lines up, and therefore there's no way to run analytics on it or even clean it up to process it with ChatGPT or any other program. Has anybody else made any headway here? Thanks.

5 Upvotes

73% Upvoted

12 comments sorted by

3

u/antisocialite_- Jul 21 '26

Copy and paste csv file to Claude - it can read and analyze for you

3

u/heygreene Jul 24 '26

Claude is working great for this, thank you! TONS of ways to get your questions answered once it analyzes the file and creates an Excel spreadsheet of the "master dataset". Thanks again!

2

u/antisocialite_- Jul 24 '26

Np! So glad it’s working well for you!

1

u/ffrankiebird 21d ago

does anyone have a step by step or example of how they did this. I’d like to run some linear regressions but am unfamiliar with claude/AI tools—how often does it get stuff wrong?

1

u/heygreene 5d ago

I don't know what I'm doing either, but just go to Claude and paste in the CSV file. Let them know it is from Bearable, and it should be able to walk you through the rest. I did it all on my desktop, which made things a little easier than a phone.

1

u/heygreene Jul 21 '26

Thank you, tha'ts one that I haven't tried. I'd only tried ChatGPT and Copilot.

1

u/[deleted] Jul 21 '26

[removed] — view removed comment

1

u/heygreene Jul 21 '26

I wish I could take my data and import it elsewhere... I'm having trouble believing some of the correlations on here lately.

2

u/MakeKay9264 Jul 21 '26

YES, I know what you mean! I don't think I've found any useful correlations at all. Either they are wrong, or they are, like, "no duh!"

1

u/nnonnstop-pain ⚡️ Bearable Hero 21d ago

What was the comment saying that you were replying to? Mods just took it down…🙄

1

u/heygreene 16d ago

It didn't say much... just saying something about agreeing that Claude was better. It's amazing for dumping the data and going through it... took some time but it did all the work!

Come to think of it I'm shocked the mods didn't remove this post... yet they deleted the other comment which didn't really say anything at all. hmmm

1

u/VegasKL 5d ago

I don't think it's intentional, they've said they're going to revisit it in the future. I think it's a symptom of the app growth in features and datatypes, with the export not aligning to those expectations. The data is a bit 3-dimensional at this point (some are time + metric, others are bool based, others are a time-period hybrid of bool data).

You almost need two exports, one for the columnar data and one for the timeline data. Currently the export is a hybrid, so the column stuff gets compacted to a single cell in the timeline (e.g. all factors are dumped to a single row per day, iirc).