I suggest you ...

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.

12 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Michaël Serisier shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    declined  ·  AdminSplitwise Support (Admin, Splitwise) responded  · 

    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.)

    26 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • ANONYMOUS commented  ·   ·  Flag as inappropriate

        WE NEED IMPORT ABILITIES! ITS LITERALLY THE MOST BASIC AND USEFUL FEATURE YOU SHOULD HAVE!

      • kiran mahale commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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...

      • Daria commented  ·   ·  Flag as inappropriate

        I would like to be able to upload all expenses using a CSV file, to add multiple entries in one go.

      • Avi commented  ·   ·  Flag as inappropriate

        Definitely looking for this feature as well! Looking forward to updates.

      • Jayaprakash Sundararaj commented  ·   ·  Flag as inappropriate

        +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  ·   ·  Flag as inappropriate

        +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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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.

      • Peter commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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?

      • Eric commented  ·   ·  Flag as inappropriate

        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.

      • Ronit commented  ·   ·  Flag as inappropriate

        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  ·   ·  Flag as inappropriate

        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.

      ← Previous 1

      General

      Feedback and Knowledge Base