Sales template

Merge Two Spreadsheets Template

Match two files on a shared key without writing a single VLOOKUP, XLOOKUP or INDEX-MATCH. Pick the key, pick the join, and get one clean merged table — with unmatched rows flagged instead of returning #N/A.

Use this template free →Prefer the Excel guide?

Opens in your browser with sample data · export to Excel any time · your data stays yours

Prefer the spreadsheet? Download the .xlsx — free with an account, 3 free downloads.

See inside before you download: Merge Two Spreadsheets Template

merge-two-spreadsheets · orders × customersJoined

Output rows

Matched

Unmatched

Columns added

Order	customer_id	Amount	Customer	Tier
#1043	C-201	£1,240	Northwind Traders	Enterprise
#1044	C-208	£560	Acme Corp	Pro
#1045	C-201	£2,100	Northwind Traders	Enterprise
#1047	C-199	£430	unmatched	—
#1048	C-208	£1,750	Acme Corp	Pro

One row (C-199) has no match — flagged, not a silent #N/A.

What's inside this template

✓

No formula neededPick two files and a key — the merge just happens.

✓

Unmatched rows flaggedNo silent #N/A: rows without a match are highlighted so you can chase them.

✓

Left or inner joinKeep every left row, or only the matches.

✓

Multiple columns pulled inBring across several fields at once, not one at a time.

✓

Match-rate summarySee how many rows matched at a glance.

✓

Export the resultDownload the joined file or share a link.

How it works

Choose two files & a key

Point at the shared column (e.g. customer_id).

Pick the join

Keep all left rows, or matches only.

Export the merged table

Download or share — unmatched rows flagged, never hidden.

Related templates

Common questions

How do I merge two spreadsheets on a common column?

Pick both files, pick the shared key — an order ID, an email, a SKU — and the join runs. No formula, and no dragging a lookup down ten thousand rows.

What happens to rows that don't match?

They're flagged rather than hidden. A VLOOKUP returns #N/A and gets filtered away, which is exactly how unmatched records quietly disappear from a report; here they're shown so you can decide what to do.

Can I join on more than one column?

Yes — a composite key of two or more columns, which is what you need when a single field isn't unique, like date plus store.

Merge two files in seconds

Pick the key, pick the join, and get one clean table — no VLOOKUP, no #N/A.

Use this template free →

No card required · works in your browser · export any time