Allow importing expenses from a CSV file
I am currently switching from a competitor service and I really don't want to reenter all my sharing history with my friends. A csv import would be great.
Also, this would be quite useful when I go on holidays: I can create a csv file offline on my phone and import it into Splitwise when I get home.
We don’t currently have plans to create a CSV importer, as there’s no standard CSV format for split expenses (and creating one would be rather messy). Importing from a spreadsheet would definitely be a good feature, but not many people have asked for the ability to import, and as a small team we’ve had to prioritize other features for now. So sorry!
If you’re switching from another service, your best bet is to simply transfer over your total balances, rather than your complete expense history. First add the people you have balances with, then add an IOU with each person for your current balance (e.g. “I owe Anna $36 for past expenses”, “Fred owes me $82 for past expenses”, etc.)
-
kiran mahale commented
Currenly I am trying to credit card expenses into splitwise for the group. So adding the import csv format would be great. Otherwise typing all that expenses is cumbersome
-
Sebastian commented
I'd love to import my data and immediately see what the benefit of the service would be, but as it's not possible I guess I simply won't switch...
I cannot imagine it being that hard to add a CSV importer and allowing a user to tell you which column is a date, the name, the amount and the person...
-
Anonymous commented
Still not available?
-
Daria commented
I would like to be able to upload all expenses using a CSV file, to add multiple entries in one go.
-
Avi commented
Definitely looking for this feature as well! Looking forward to updates.
-
Lindsay commented
Can't believe there is no Excel import functionality; please implement!
-
Jayaprakash Sundararaj commented
+1 for this feature. I am not looking for transfering to difference service, instead i am looking for ways to send reminders about balances.
-
kieran commented
+1 on this request for import capabilities! Trying to switch over to using Splitwise (instead of Excel spreadsheets) for tracking shared expenses, but don't want to lose all the history.
-
John commented
I also would like to see upload from csv. It would be very easy for you to create a template for the upload with the appropriate headers and data types. I don't believe it is as complicated as it sounds. Also a lot of people are asking for it, especially if they are transferring from another service to yours because Splitwise is a great app tbh!
-
Harris Schneiderman commented
I would also find it very useful to be able to bulk upload multiple expense items at once in CSV format. Here are a few scenarios where this would be very useful:
1) Transferring expenses from a different service to Splitwise
2) Uploading an entire credit card statement (in CSV format) into SplitwiseI agree that I could just upload a single balance item. However, I would lose the details of the individual expenses. The detailed information is very important to be able to analyze where the money is being spent.
Conversely, it would be useful to be able to export the data in Splitwise to a CSV file. This would allow me to import the data into Excel and create pivot tables, sort, and analyze the information. Excel is a very powerful analytics tool that is widely used.
-
Peter commented
I second the request for the feature. I enter about 30 transactions per month and the lack of this feature has me looking for another service
-
Kaushal Mehta commented
It would be great if split wise allowed to import a group of transactions from a spreadsheet, so that they don't have to be added in individually.
-
Dmitry commented
There is a standard of CSV format for spit expenses which I found in another application which can and must be used IMHO for import and export expenses for further use in Excel or any personal finance applications supporting imports. For fixed (uneven) amounts:
Who paid,For who,Weights,How much,Currency,Purpose,When
Dima,"Dima, Mitrich, Sasha, Tigran",3000 4300 2200 2500,12000.000000,RUB,Restaurant,9/15/16 5:16 PMFor even amounts:
Dima,"Dima, Mitrich, Sasha, Tigran",Even,30000,RUB,Restaurant,9/15/16 11:26 AMCan you implement that as many people ask?
-
Eric commented
This may or may not help with switching from a competitor, but I have made my own uploader on github which takes your CSV file and as long as it has columns for date, amount, and a description it can upload them to splitwise.
I have only tested it on mac and linux, and it requires basic command line knowledge.
https://github.com/esecules/splitwise-csv
If there is interest I can work on more features. I am an independent developer with no affiliation to Splitwise. I simply use their API to post expenses gathered from a CSV.
-
Anonymous commented
I vote for csv import too.
-
Anonymous commented
PLEASE ALLOW FOR CSV IMPORTS!! It would be awesome!
-
Ronit commented
Would be great to allow importing from csv. I currently export my transactions from Mint or other payment provider, organize everything in excel and then manually enter in SW. An import tool would be amazing.
-
Ash commented
Importing a spred sheet in simple words
-
Ash commented
Lets say I have an excel/spread sheet mapped with names VS expenditure. Pass this as an input and wish to see the expenditures allocated to respective names.
-
Ashwin Tumma commented
Giving the users an ability of importing the expenses from a Google Spreadsheet or Microsoft Excel.
* Why this idea?
Before I was introduced to Splitwise, I used to maintain my expenses in a spreadsheet. Now, I wanted to add all those expenses to Splitwise. I had to manually type all the expenses, despite the fact that my expenses were in a well-formatted manner.* Code Suggestions
Ofcourse, I understand that the parsing logic for reading the spreadsheet, and deciding which field indicates what is just too complex, and the programmer is at the mercy of some regular expressions. But, I believe that such kind of problems can be easily tackled with incremental code deliveries and learning from the customer base.