Import your Splitwise data: groups, expenses, debts, and friends

Short answer

You can import Splitwise data into SplitMyExpenses by exporting a Splitwise group or friend CSV, uploading it to SplitMyExpenses, choosing whether to import expenses or balances, mapping members, and reviewing the completed import.

Splitwise import is now supported!

One of the most requested features is here: Bring over your data from Splitwise to SplitMyExpenses! Import your groups, expenses, balances, and friends. You can import your data from Splitwise by going to the Splitwise imports page and uploading your exported file from Splitwise.

Did you know you can import friends as well as groups? Both have an export button on Splitwise, so you can choose which one you want to import!

How to export your Splitwise data

Read Splitwise's official guide to get your .csv file for a group or friend.

You can edit the exported data to do any adjustments you like, but the final .csv needs to have the following columns:

1. Date - The date of the expense (ex: 2022-08-06)
2. Description - The description of the expense (ex: Pizza)
3. Category - The category of expense (e.g. Groceries, Rent, Utilities, etc.)
4. Cost - The total cost of the expense (ex: 10.00)
5. Currency - The currency of the expense (ex: USD)
6. Net balance, per person - one column per person in the group with the amount they owe or are owed for the expense (ex: -5.00)

NOTE: The export must be in English since the column names are used directly to map the data. If you need to change your Splitwise language, you can do so in your Splitwise account settings.

How to import your Splitwise data

1. Go to the Splitwise imports page
2. Upload your exported .csv file from Splitwise
3. Choose whether you want to import expenses or only balances
4. Map group members from Splitwise to SplitMyExpenses users
5. Click Finish import

Important notes

Splitwise does not export user emails

Splitwise only provides group member names in the exported .csv file, so you need to map those names to SplitMyExpenses users. You will do this after you import your file.

Importing expenses vs. balances

By default, SplitMyExpenses will import group member balances for the group by creating an expense in each currency, to make sure the balances are accurately reflected by the group's expenses.

You can also include the group's expenses in the import, which will create expenses for each expense in the .csv file. By default, this is limited to the past 1 month of expenses, but you can upgrade to a paid plan to import more expenses.

Note: The imported balances will be correct no matter how many expenses you import (1 week, 1 month, 3 months, or no expenses at all). The only difference is that if you import expenses, you will see those expenses in the group's expense list.

SplitMyExpenses will create an expense capturing the debts for the sum of the missing expenses that were not imported, if there are any, to ensure the math is correct.

FAQ

Can SplitMyExpenses import Splitwise groups?

Yes. SplitMyExpenses can import Splitwise group exports, including balances and optional expenses, then map Splitwise member names to SplitMyExpenses users.

Can SplitMyExpenses import Splitwise friends?

Yes. SplitMyExpenses supports friend imports as well as group imports, so one-to-one expense histories can move over too.

Do imported balances stay correct if I import only recent expenses?

Yes. SplitMyExpenses creates balance adjustments for expenses that were not imported so the final group or friend balance still matches the export.

Conclusion

Export your Splitwise data, import to SplitMyExpenses, configure your import settings, and you are good to go! You can now use SplitMyExpenses to manage your group's expenses, debts, and balances. After the import is complete, SplitMyExpenses can become the source of truth for future group expenses and balances.

If you have any questions, or you need some help, please reach out to us: support@splitmyexpenses.com.

By Bradley Bernard

Creator of SplitMyExpenses.com