IMPORTRANGE pulls a range from another Google Sheet into yours: =IMPORTRANGE("paste the sheet address here","Expenses!A1:E500"). The first time you use it, Sheets asks you to allow access. Stack two imports together, wrap them in QUERY, and you can total both partners' spending by category in one summary sheet.
How do I import one person's sheet?
- Ask your partner to open their expenses file and copy the address from the browser bar.
- In your summary sheet, type =IMPORTRANGE("address","Expenses!A1:E500") in a blank cell, pasting the address between the quotes. The second quoted part is the tab name, an exclamation mark, then the range.
- The cell shows #REF! with a message that you need to connect the sheets. Click it and choose Allow access.
- The data appears and keeps updating when your partner adds rows, with a short delay.
You need at least view access to their file. If you do not have it, the import fails and Sheets tells you so. Tab names with spaces need single quotes inside the double quotes, such as "'Apr 2026'!A1:E500".
How do I combine two sheets into one list?
Join the two imports with curly brackets and a semicolon, which stacks one below the other:
={IMPORTRANGE("address one","Expenses!A2:E500");IMPORTRANGE("address two","Expenses!A2:E500")}
Start at row 2 so the heading row is not repeated in the middle. Both sheets must have the same columns in the same order, for example date, merchant, category, account, amount. If your partner's layout differs, ask them to match yours or rearrange it with a small helper tab on their side. If your Sheets uses a different list separator because of regional settings, the stacking symbol may differ, so check the formula help.
How do I total by category across both?
Put the stacked data inside QUERY. Because the data now lives inside curly brackets, columns are named Col1 to Col5 rather than A to E:
=QUERY({IMPORTRANGE("address one","Expenses!A2:E500");IMPORTRANGE("address two","Expenses!A2:E500")},"select Col3, sum(Col5) where Col3 is not null group by Col3 order by sum(Col5) desc label sum(Col5) 'Total'",0)
The last 0 says the combined data has no header row, since we started from row 2. Say one sheet has Groceries 4,090 and the other has Groceries 2,200; the summary shows Groceries 6,290.
Which errors will I meet?
| Message | Meaning | What to do |
|---|---|---|
| #REF! You need to connect these sheets | Access has not been allowed yet | Click the cell, choose Allow access |
| #REF! Could not fetch the sheet | No access, or a wrong address | Check you have access and recopy the address |
| Imported range is empty | The named range has no data | Check the tab name and the range spelling |
| Array result was not expanded | Something sits in the cells below | Clear the cells under the formula |
| Loading... for long | A big or slow import | Reduce the range to what you need |
What does this setup not do?
- It does not check duplicates; if the same shared bill appears in both sheets, it will count twice
- It does not fix inconsistent category names, so agree on a shared list first
- It reads whatever is there, so a stray typed note in the amount column can affect totals
- It depends on both files staying in place; renaming a tab breaks the import
Agree on these before you start
- Same column order and the same category names in both sheets
- A fixed tab name that nobody renames
- Who owns the summary sheet
- A rule for shared bills, so each is entered once
- A monthly five-minute check that the totals match the bank
The method suits two people who are comfortable with sheets; the hard part is keeping both files consistent month after month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


