Splitwise can help move shared-expense history into a spreadsheet, but an export is not automatically a complete archive. Save the original file, inspect its rows, compare the totals, and keep receipts outside the CSV. That workflow works for roommates, travel groups, couples, and small clubs.

According to the Splitwise Help Center page on double-checking balances, the web app uses Recent Activity for exports, while the mobile app places the option in Activity. The page also describes a printable summary for reviewing balances. Exact columns and attachments still need checking. Forum requests can add context, not certainty.

How to export Splitwise activity

Start with the account copy. Don't change entries while you're collecting the file.

  1. On the web app, open Recent Activity. Scroll right in the horizontal header menu and select Export, following the path described by Splitwise's Help Center.
  2. On the mobile app, open Activity. Scroll through the activity menu and use Export when it appears.
  3. Check the balance view separately. The Help Center page describes a month or all-time dropdown and a View Printable Summary link below Settle Up.
  4. Save the untouched download. Use a clear name such as splitwise-export-original.csv, or keep the file's actual extension if it arrives as another spreadsheet format.

Menus can change. If your screen looks different, look for Recent Activity, Activity, Export, or Printable Summary rather than relying on an old screenshot.

What a Splitwise export can establish

An expense row can verify that a bill was recorded. It doesn't prove that the split still matches a later agreement, a cash payment, or a missing receipt.

Several Splitwise UserVoice requests about downloadable data and CSV layout and totals discuss the information users wanted. UserVoice is a feature-request board, though. Those posts are not a current column specification.

Use this conservative test before treating the file as your official record:

Record question Safe use of the export Check separately
Which expenses were recorded? Review the dates, descriptions, payers, and amounts that actually appear. Look for duplicate, blank, or missing rows.
What did each person pay? Use payer and amount fields as a starting point. Compare important reimbursements with receipts or payment records.
What does each person owe? Use per-person share fields only if they are clearly present. Recalculate the split from the agreed rule.
What is the current balance? Compare the file with the app's balance or printable summary. Record later settlements separately from original expenses.
Are receipts and notes included? Treat any visible links or notes as useful extras. Keep receipt images and important explanations in a separate folder.
Does it cover every group? Filter by group, person, and currency when those fields exist. Check whether one-to-one expenses or unrelated groups are outside the export.

The available research does not establish one universal column list or guarantee that every attachment, note, or settlement detail travels with a file. Use the app summary and original documents to fill gaps.

Import the file without losing rows

CSV files are plain text, but they can be fussy. General CSV import guidance for Google Sheets highlights delimiter, encoding, and date-format problems.

Turns out, a file can look fine and still put every value into one column.

  • Keep the original file untouched, then make a working copy.
  • In Google Sheets, use File and Import instead of opening the CSV blindly. Select the separator shown by the import preview.
  • If the data appears in one column, try the correct delimiter, such as comma or semicolon.
  • Check names with accented characters. Strange text can indicate an encoding problem.
  • Review the first several rows, the first date, and the first amount before importing the full history.
  • If the importer reports skipped rows, read the reason. Never silently replace an unreadable expense with zero.
  • If a trailing Total row appears, exclude it from line-item counts unless you are treating it as a summary value.

Compare at least one visible total with the app before you clean the working copy. A spreadsheet that imports quickly can still be wrong.

Build a two-tab shared-expense ledger

For ongoing records, separate the expense itself from each person's share. This prevents a full bill from being counted once for every participant.

Make an Expenses tab with one row per bill. Useful columns are Expense ID, Date, Description, Group, Payer, Amount, Currency, Split method, Receipt link, Status, and Notes.

Make a Shares tab with one row per person for each expense. Use Expense ID, Person, and Share. For every expense ID, the shares should add up to the recorded amount.

Then create a Summary tab. Assume the member's name is in A2, the paid amount goes in column B, the owed amount in column C, and the net position in column D.

Summary field Formula in row 2
Paid =SUMIF(Expenses!E:E,A2,Expenses!F:F)
Owed =SUMIF(Shares!B:B,A2,Shares!C:C)
Net before settlements =B2-C2

These formulas assume one currency and a summary covering the same group. A positive net means the person paid more than their recorded share. A negative net means the person owes more than they have paid.

For multiple currencies, keep separate summaries. Do not add dollars, euros, or other currencies into one balance.

If people settle outside the expense ledger, add a Settlements tab with From, To, Amount, Date, and Note. Keep a payment separate from a new expense so the same money isn't counted twice.

Write down the split rule

Equal splits are easy to explain. They can feel wrong when one roommate has the larger bedroom or one traveler skipped an activity.

Usage-based splits work better for some utilities, groceries, or nights stayed. Exact amounts work well when each person ordered different items. Percentage splits can handle uneven contributions, but the percentage should be written down before the bill arrives.

Income-based contributions require more personal information and more trust. Limit access to that detail.

Reimbursement-after-proof is another option: record the expense as pending, attach the receipt, and mark it settled after the group agrees that payment was made. Thing is, the spreadsheet records the rule; it doesn't create agreement about the rule.

Adapt the record to the group

Roommates should track recurring utilities, rent-related reimbursements, deposits, and moving costs. Keep the original bill amount, not just each person's share, so a later adjustment has something to reference.

Travel groups need fields for category, trip segment, deposits, cancellations, and settlement status. Flights, lodging, rental cars, gas, meals, and shared groceries often follow different split rules.

Couples and families can label expenses as shared, personal, or reimbursable. That simple field prevents a joint budget from quietly absorbing an expense that was meant to stay separate.

Clubs, teams, and committees benefit from a named treasurer or editor, a regular review date, and a read-only summary for everyone else. The same structure works for recurring dues and one-time event costs.

Keep receipts and share the record safely

A CSV is not a photo archive. Keep receipt images in a separate folder and connect each image to the matching expense ID.

  • Name files with the expense ID and a short description.
  • Paste the receipt link into the ledger rather than embedding unrelated personal documents.
  • Add a note when an expense has an exception, refund, deposit, or partial reimbursement.
  • Share a cleaned summary with read-only access when possible, and limit edit access to people maintaining the record.
  • Remove unrelated personal information before sharing the file with a large group.

To be honest, this is the unglamorous part. It is also what makes a spreadsheet useful three months later, when nobody remembers why a charge was split unevenly.

When a spreadsheet should be the primary record

Use an export when you need historical activity, want to move records into another spreadsheet, or need a starting point for a group that is changing its workflow.

Start with a spreadsheet from the beginning when the group has only a few expenses, custom rules, or a strong need for receipt links and written exceptions. A simple shared sheet may be easier than repairing a file after the fact.

An app export is a snapshot, not a live sync. Keep the update cadence clear, such as after each recurring bill or once a week during a trip.

The material reviewed here does not establish a current subscription requirement for a full export. Don't promise that a particular plan includes a feature based on an old forum post. Check the export control available in the account and the current official help or plan documentation.

FAQ

Does exporting settle a Splitwise balance?

No. Exporting copies activity into a file. It does not send money or replace a separately recorded settlement.

Can I export receipts and notes with the expenses?

Don't assume so. The available sources do not establish a dependable built-in attachment export, so keep receipt images and important notes in a separate folder with links from the ledger.

Why did my CSV open in one column?

The file may use a different delimiter than your spreadsheet expects. Import it through the spreadsheet's import tool, try the correct separator, and check the character encoding if names display incorrectly.

Do I need Splitwise Pro for a full export?

The sources available here do not establish a current requirement. Check the account's export option and current official documentation rather than relying on an old forum claim.

Start with one recent utility bill or travel charge. Save the original export, create the Expenses and Shares tabs, compare one total and one balance, then add the receipt link before entering the rest of the history.