How to Get Your Shared Expenses Into a Spreadsheet

A week-long trip ends, the app says one person owes $312.40, and somebody in the group asks where that number came from. Answering it by scrolling back through forty expenses on a phone screen is slow, and it rarely convinces anyone.

A spreadsheet does convince people. Every expense on its own row, every share in its own column, and a total at the bottom that either matches the app or doesn't. This covers why groups want that file, what a useful export actually contains, how to get one out of the main splitting apps, and where a plain spreadsheet still beats an app entirely.

Why Put Shared Expenses in a Spreadsheet

The reasons come up repeatedly, and none of them are about leaving the app you're using.

• Checking the math before a big settlement: When a trip ends with four people moving several hundred dollars each, someone wants to see the arithmetic laid out before the transfers go through.
• Sharing a summary with people who aren't in the app: A parent who funded part of a family trip, or a friend who joined for two days, will read a spreadsheet. They will not install anything.
• Feeding a household budget: If you already track spending in a personal budget sheet, the shared side has to get in there somehow, and typing it twice is how errors start.
• Year-end and tax records: Shared rent, shared utilities, and shared business travel all get easier to total when the whole year sits in one file you can sort and filter.
• Keeping a copy that isn't tied to an account: Groups get archived, people leave, and apps change their terms. A file on your own drive stays readable.

Those are all reporting jobs, and reporting is what spreadsheets are good at. If you're specifically leaving Splitwise and want your history moved somewhere else, our guide on getting your data out of Splitwise covers that case in detail.

What a Useful Export Actually Contains

Not every export is worth opening. The difference is whether it carries enough columns to reconstruct the split, or only the totals the app already showed you.

A useful export has a row per expense and these columns:

• Date: The date the expense happened, not the date it was entered. Trips get reconstructed day by day, and entry dates lump three days of receipts onto one evening.
• Description and category: Descriptions let you spot duplicates. Categories let you answer questions like how much the group spent on food versus lodging.
• Payer: Who actually paid. Without it, the balances can't be rebuilt from the file.
• Amount and currency: The original amount and the currency it was charged in. If the app converted anything, the converted amount and the rate used should be there too.
• Per-person shares: One column per participant showing what that person owed on that row. This is the column that makes the file worth having.
• Settled status and payments: Payments between people are transactions too. If they're missing, the balances in your sheet won't match the balances in the app.

A total-only export tells you the trip cost $2,847 and stops there. You already knew that. What you needed was the ability to sum one person's column and see that their share came to $683.20, then check that figure against what the app is asking them to pay.

Formats matter less than columns. CSV opens in Excel, Google Sheets, and Numbers, and it imports into almost anything. A multi-sheet Excel workbook is nicer to read because it can separate expenses, itemized receipts, and a balances summary onto their own tabs, but a well-shaped CSV is more than enough for checking math.

Exporting From the Main Apps

Export support varies more than you'd expect, and it changes. Confirm against the app's current help pages before you count on any of this.

Splitwise

Splitwise exports one group or friendship at a time. On the web, open the group and use the gear icon to choose the spreadsheet export; the help center also describes an Export option in the mobile apps. The file gives you one row per transaction with a cost column and a column per person showing that transaction's impact on their balance, which is exactly the shape you need for checking a settlement.

Two limitations are worth knowing. There's no single button that exports every group at once, so a year of splitting across four groups means four files. And the per-group spreadsheet export is documented without a Pro requirement, while the full account backup, which comes out as JSON rather than a spreadsheet, is described as a Pro feature. If your group history matters to you, it's worth confirming which of those you're actually getting before you cancel anything.

Tricount

Tricount's export story changed with its move under bunq. The help center states that Premium has been deprecated, and CSV and PDF export were among the features that went with it. The current guidance is to email support to request an export of your tricount in CSV or ODF. That's workable for a one-time record, but it isn't something you can do in the app on the evening a trip ends, and third-party extractor tools that read a share link are not affiliated with Tricount.

Settle Up

Settle Up lists Export to Excel as a premium feature, producing a full expense report as a spreadsheet of the group's history. CSV export has also been available, historically over email and reported by users as more reliable on some platforms than others. Premium is commonly reported at around $19 per year or roughly $3.49 per month (pricing varies by plan and region). If exporting is the main thing you want from premium, that's a small amount of money for a feature you might use twice a year.

SplitterUp

We build SplitterUp, so weigh this accordingly. Open a group's Settings and choose Export to Excel or Export as CSV, and you get a spreadsheet of the whole group. It includes a running balance so you can follow how each person's total builds up expense by expense, a day-by-day breakdown of every expense and who owes what, an itemized sheet for scanned receipts, and a final balances summary. It shipped in July 2026, and the intent was specifically the pre-settlement check: a trip with a lot of receipts spread across several days is hard to verify on a phone and straightforward to verify in a sheet. Exporting is part of the app rather than a paid add-on, and SplitterUp is free for a limited time with no subscription.

Checking the Math Before You Settle

Once the file is open, the check takes about five minutes and follows the same sequence regardless of which app produced it.

Start with the total. Sum the amount column, then sum every per-person share column and add those sums together. The two numbers should match. If the shares total less than the expenses, an expense was split among fewer people than paid for it, or a percentage split didn't add up to 100%.

Then sum the final balances. Across the whole group, what everyone is owed and what everyone owes should net to zero, give or take a cent of rounding. A group of four that nets to $18.50 has a missing payment or a double-counted expense somewhere.

Then sort by amount, largest first. The biggest three or four rows drive most of the balance, and they're where a mistyped amount does real damage. A $1,240 rental split four ways instead of five moves $62 to the wrong person, and nobody catches that from a balance screen.

Then sort by date and scan for pairs. Two rows with the same amount on the same day are usually a duplicate from a slow phone, or occasionally two people who each paid for their own halves of the same thing.

If the trip crossed currencies, check the rate column on the foreign rows. Expenses are normally priced at the rate stored when the expense was created, so a euro dinner entered on day one and a euro dinner entered on day six can convert at slightly different rates. That's correct behavior, but it explains small discrepancies that otherwise look like errors. Our guide to splitting travel expenses goes further into how multi-currency trips go wrong.

Finally, confirm the settled rows. Payments already made should appear as their own transactions. If someone paid $200 back in cash and it was never recorded, the sheet and the app will agree with each other and both will be wrong.

When a Spreadsheet Is Better Than an App

Being honest about this matters more than pitching software. There are cases where the spreadsheet is the whole solution and installing anything is overhead.

• One-off splits among a few people: Three people, one weekend cabin, five expenses. A shared sheet takes two minutes and everyone can see it.
• Highly custom split rules: If a housemate pays 40% of utilities because of their room, 25% of groceries because they eat out, and nothing toward the parking space, a formula expresses that cleanly. Most apps handle custom percentages, but a formula you wrote yourself is easier to audit and easier to change in one place.
• Long-running amortization: A $2,400 sofa that one person bought and the other repays over eight months is a payment schedule, not really a shared expense.
• Groups where only one person will ever track anything: If nobody else is going to open an app, the file you email around is the record.

The tradeoffs run the other way as soon as a group gets busy. Someone has to keep the sheet current, and that person is doing manual entry from receipts in another language while everyone else is at dinner. Formulas break quietly when a row is inserted in the wrong place. Currency conversion has to be maintained by hand. And a spreadsheet won't tell four people the shortest set of payments that clears everyone out.

The practical arrangement for most groups is both. Use an app while the spending is happening, because entry is the tedious part, then export a spreadsheet at the end when someone wants to see the numbers. That's the workflow the export button exists for. For ongoing household budgets, the same pattern applies each month: track as you go, export when you reconcile.

If you haven't settled on an app yet, our roundup of the best expense splitting apps compares pricing, receipt scanning, and export support across seven of them side by side.

Frequently Asked Questions

Can you export shared expenses to Excel?

Most splitting apps export CSV, which opens directly in Excel, Google Sheets, and Numbers. A true Excel workbook with multiple sheets is less common. Settle Up lists Excel export as a premium feature, and SplitterUp exports either an Excel workbook or a CSV from a group's Settings.

Is exporting expenses free in most splitting apps?

It varies, and it changes. Splitwise's per-group spreadsheet export is documented in its help center without a Pro requirement, while the full account backup is described as a Pro feature. Settle Up puts Excel export in its premium tier. Tricount's help center says CSV and PDF export were part of the discontinued Premium plan and directs users to contact support instead. Check the current help pages before you rely on any of this.

What columns should a shared expense export have?

Date, description, payer, amount, currency, each person's share, category, and whether the expense has been settled. Without a per-person share column you can total the spending but you cannot verify who owes what, which is the reason most people export in the first place.

How do you check a group's balances in a spreadsheet?

Sum the amount column and compare it against the sum of every person's share; the two should match. Then sum the final balances across everyone, which should come to zero. Anything left over points at a missing expense, a duplicate, or a split that doesn't add up to 100%.

Is a spreadsheet enough for splitting expenses on a trip?

For a short trip with two or three people and a handful of expenses, yes. For a week abroad with several currencies, receipts to itemize, and everyone paying for different things, maintaining the sheet by hand becomes its own job. Most groups use an app for entry and a spreadsheet for the final check.