Import data from splitwise.

oss-apps / split-pro

Open source alternative to Splitwise

https://splitpro.app

GNU Affero General Public License v3.0

127 stars 10 forks source link

Import data from splitwise. #29

Closed KMKoushik closed 2 months ago

KMKoushik commented 3 months ago

Currently export option is only available for splitwise pro users. Need to figure out way to make it wotk for everyone!

dfego commented 3 months ago

Hi there! So there is an "Export as spreadsheet" option in Splitwise for each group. It's kind of annoying to find, but it exports as a csv file. Accessible on the web version if you go to a group, then click the gear icon on the right side, then "Export as spreadsheet".

That would seem to be the most straightforward way to let anyone import their data!

The format is (for the one I downloaded):

Date
Description
Category
Cost
Currency
Person1
Person2

In my case, Person1 is the other person in the group and Person2 is me. Not sure how standardized that is, or if larger groups have more columns.

KMKoushik commented 2 months ago

@dfego Yeah, I saw this. Did not like this way though. I have 3 main issues with this approach.

I have to manually import for each group.
Then I have to manually assign Person 1, Person 2 etc to splitpro account
For non-group balance there's no export option.

I have a sample PR here: https://github.com/oss-apps/split-pro/pull/37

This will fetch all the group and non group balances. Basically create 100% import with very less efforts. I found a way to download splitwise data. You can test it here: https://export-splitwise.vercel.app/

This PR is almost done! With some UI changes and testing, should be available soon!

dfego commented 2 months ago

Interesting! I just downloaded mine. They certainly make you jump through a lot of hoops to get it.

Can't wait to see this get in, then I can try this out!