To export Splitwise, open a group or friendship, open its settings menu on the website, and choose “Export as spreadsheet.” On mobile, the export option is at the end of the group's or friendship's horizontal header menu. The CSV can be opened in Excel; you do not need to switch expense apps to use this guide.

Jump to export steps, Excel instructions, balance columns, Tricount exports, or importing into Splitpond.

Export a group or friendship on web or mobile

WebsiteMobile app
  1. Sign in to Splitwise.
  2. Open the group or friendship you want.
  3. Use its settings icon and select the spreadsheet export.
  1. Open the group or friendship.
  2. Scroll right through the horizontal menu in its header.
  3. Tap Export at the end of that menu.

These are the routes documented in Splitwise's export help. Save the file, open it, and check the group name and entries before relying on it as a backup. Repeat for other groups or friendships you need.

How to open the Splitwise CSV in Excel

A CSV is a text spreadsheet, not an Excel .xlsx workbook. Keep an untouched copy of the export, especially if you may import it into another app.

  1. Open Excel and start a blank workbook.
  2. Choose Data → From Text/CSV (in some versions, under Get Data → From File).
  3. Select the export. Check the preview's encoding and delimiter: UTF-8 and comma should display the names and columns correctly.
  4. Load the data. Check dates and amounts before calculating totals.
  5. To keep formulas or formatting, save your working copy as Excel Workbook (.xlsx).

If double-clicking the CSV already displays everything correctly, that is fine. If names show broken characters or an entire row appears in one column, use the import preview instead. Microsoft explains the UTF-8 import options for Excel. You can also import the CSV into Google Sheets or another spreadsheet editor.

What the Splitwise CSV columns mean

The group-export format supported by our importer begins with these columns:

Date, Description, Category, Cost, Currency, Alice, Bob, Charlie

ColumnHow to read it
DateThe transaction date.
DescriptionThe transaction label. Quoted descriptions may contain commas.
CategoryThe expense category; Payment identifies settle-up transfers in this format.
CostThe transaction amount. Do not count payments as new spending.
CurrencyThe currency code. Keep different currencies separate when calculating totals.
Each member's nameThe change to that person's balance, not a separate record of their payment and share.

Splitwise's balance guide also explains the member columns. For an expense, think of the number as amount paid minus share owed. A positive net amount increases what the person is owed; a negative net amount increases what they owe.

A worked example: $45.60 shared by three people

Suppose Alice pays $45.60 for groceries and Alice, Bob, and Charlie each owe $15.20. This illustrative row would look like:

2026-05-01, Groceries, Groceries, 45.60, USD, 30.40, -15.20, -15.20

Alice's column is +30.40, not 45.60: her payment minus her own share. Bob and Charlie each have −15.20. Together the three balance changes sum to zero.

The net columns do not uniquely identify the original payers and shares. The same net changes could result from different payment arrangements. Multiple positive numbers are not a complete record of who paid how much; zero can also mean a person paid exactly their share. Matching final balances is not proof that every original allocation has been recovered.

Calculate totals without double-counting

  • Trip spending: sum expense costs separately for each currency, excluding settle-up payments and summary rows.
  • A person's balance: sum their transaction-column values, including payments, but exclude any Total balance summary row.
  • Category or monthly spending: use expense rows in a pivot table, again keeping currencies separate.
  • Sanity check: member balance changes should sum to zero per row, allowing for export rounding. Investigate discrepancies before editing amounts.

The Total balance row, when present, summarizes the transactions above it. Including it in a sum would count balances twice. Preserve refunds as refunds in your analysis; do not silently turn negative amounts into positive spending.

Can you export your entire Splitwise account?

Group and friendship CSVs are separate exports. For an account-wide export, Splitwise directs users to its support team. Pro subscribers also have a JSON backup option in the website's account settings under advanced features. See the official export instructions for that separate backup format. Splitpond's importer accepts the supported group CSV, not the account JSON backup.

A transaction CSV is not a complete copy of the app. Do not rely on it to retain receipt images, comments, or account details that are not in its columns. Save any supporting records you need separately and inspect your backup before closing an account.

What to check if the export looks wrong

  • No export button: check the group or friendship screen, not just general account settings. Follow the web route if your mobile menu differs.
  • Broken names or one long column: check the encoding and delimiter in the spreadsheet's import preview.
  • Unexpected dates: check the spreadsheet's regional date interpretation against the untouched CSV.
  • Missing transactions: confirm the file belongs to the intended group or friendship. Compare it with Splitwise before deleting records; contact Splitwise support if the source export is incomplete.

How to export a Tricount to CSV or Excel

The current Tricount app has no export button. Tricount's help center lists “Export tricount in CSV and PDF” among the Premium features removed with its new app, and asks you to email [email protected] for a CSV copy of a tricount. See the tricount FAQs and what happened to tricount Premium.

  1. Write from the email address linked to your Tricount account, and name each tricount you need.
  2. Do not send your password or any verification code; Tricount's help center warns never to share them.
  3. When the file arrives, keep an untouched copy and open it in Excel with Data → From Text/CSV, as described in the Excel instructions above.

Splitpond's importer reads Splitwise exports only, so it cannot convert a Tricount file. The simplest way to switch is to settle up in Tricount first, then start a fresh Splitpond group for your next trip. Our Tricount alternative guide compares the two.

Optional: import the CSV into Splitpond

If you want to continue tracking expenses here, open the Splitwise CSV importer on the homepage and select Choose Splitwise CSV. You can review the file before creating a group; choosing a file does not save it as a group.

  1. Use a group export in one supported currency and keep the original file.
  2. Review the people, entry counts, reconstructed transactions, preserved history, and every warning.
  3. Check the balance comparison. If the export has no usable total-balance row, the preview says those balances are not verified.
  4. Only confirm if the result is suitable, then compare the imported totals and balances with your source records before sharing the new group.

Mixed currencies and refunds are blocked rather than guessed. Transactions with no balance change can be retained as history without inventing a payer. Some other rows require reconstructed entries; the preview explains these limitations. This is a reviewed conversion, not a lossless copy of every original split. Our Splitwise migration guide explains what to check next.

If your goal is simply to close your account, keep your backup and follow the account deletion guide. Importing into Splitpond is optional.