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.)
Johan Jaimes commented
This would be great!
WE NEED IMPORT ABILITIES! ITS LITERALLY THE MOST BASIC AND USEFUL FEATURE YOU SHOULD HAVE!
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
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...
Still not available?
I would like to be able to upload all expenses using a CSV file, to add multiple entries in one go.
Definitely looking for this feature as well! Looking forward to updates.
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.
+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.
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 Splitwise
I 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.
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.
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 PM
For even amounts:
Dima,"Dima, Mitrich, Sasha, Tigran",Even,30000,RUB,Restaurant,9/15/16 11:26 AM
Can you implement that as many people ask?
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.
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.
I vote for csv import too.
PLEASE ALLOW FOR CSV IMPORTS!! It would be awesome!
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.
Importing a spred sheet in simple words