Export improvement (layout, total expense and CSV compatibility)
As in Webapp, the CSV export is not useful : there is no total expense, and no detail of repartition. I recommend finding example on the ShareTheBill app with an excellent export tool, and wonderfull layout (i have example on old holidays data);
In France, CSV is not well recognized because of separator trouble, and a replacement in text editor is not enough because also the decimal will be changed... Could it be options to define separators before?
Thanks for the suggestion! Have you taken a look at the monthly PDF export for groups on the website? The csv export is meant as a simple summary, not something that would include lots of details.
The PDF export is unfortunately not sufficient, because data can't be extracted from it. I need an export that contains the data I need and also can be read by a program or a script. The CSV export is almost enough but misses some things.
In the API and CSV export, transactions don't have as much detail as what I enter in the app/webapp. It makes sense because there are a lot of entry options. Yet currently this means from the CSV/API I can't tell how much I paid for a given thing.
For example if A and B buy food together where A pays $5 and B pays $15 and they want to share the costs equally, the resulting CSV entry will say "cost: $20, A: $-5, B: $5". If instead B pays $20 and they split it so that A owes $5 and B owes $15, then we get also "cost: $20, A: $-5, B: $5". So I can't tell how much A and B each actually paid from the CSV entry. But I would like to know this for my own accounts.
Could you pleas eadd more info to the API and/or CSV so that we can distinguish those two cases?
Here's a potential solution: distinguish the inputs and outputs to each transaction. For the first example, it would look like "cost: $20, A paid: $5, A owes: $-10, B paid: $15, B owes: $-10". For the second, "cost: $20, A paid: $0, A owes: $-5, B paid: $20, B owes: $-15".
Hi - currently , when I export expenses from a group onto excel, it shows who owes how much but it doesn’t give the details of the total spend made on a particular item / details of who spent it.
This makes it very hard to review the overall expense incurred. Is it possible to integrate these details onto the excel file that gets generated when I export ?
There should be an option to export all friends and balances to a spreadsheet. This would include balances for all friends across groups.
Context is I am trying to balance out my account and need to send payment details to all of my friends. Currently this takes about 5 clicks per person as well as copy-pasting the settle reminder message. Even then the message doesn't contain the amount.
The spreadsheet export should contain name, email and balance for each friend.
Soniya Louis commented
In Export Spreadsheet there should be a detail about who owes how much and who need to pay how much ?
for example x needs to pay y RS 100 for abc and x owes RS.100 in total
Hey Splitwise Team,
I like the export function but at least here in Germany excel uses ";" as sepperator for .csv files. On pc this isn't a big thing but I can't find a workaround on the smartphone. It would be great if you could either choose the seperator or even better to choose .xlsx format!
Thank you for your great work :)
Have you considered exposing an API? Then I could create my own spreadsheets/invoices/email reminders/whatever.
I use the "download as CSV" functionality quite a lot – it's helpful for getting a quick overview of all the data, and for checking what's changed since the last time I reviewed my transactions. But it would be a lot more useful if it also included item splits as separate rows.
Of course, you'd want these to be distinguishable as itemized rows. A few possibilities to allow this: leave off the date from item rows (so it's visually clear they're attached to the previous transaction); indent the description text with a few spaces; or prefix the item description with "Transaction name: ".
Almost every single transaction I'm involved in is itemized, so it'd be extremely helpful to me for the item information to be more accessible.