Data template

Compare Two Excel Files Template

Spot added, removed and changed rows between two versions of a file — a clean diff for spreadsheets.

Use this template free →
Opens in your browser with sample data · export to Excel any time · your data stays yours

Prefer the spreadsheet? Bank Reconciliation with Auto-Match · Data Cleaning Checklist Template · Data Validation Rulebook & Quality Score — free with an account, 3 free downloads.

See inside before you download: Bank Reconciliation with Auto-Match · Data Cleaning Checklist Template · Data Validation Rulebook & Quality Score

compare-two-excel-files · sample dataResult
Rows added
36
Rows removed
12
Rows changed
58
Unchanged
7,904

What's inside this template

Row-level diffAdded, removed and changed, separated.
Cell highlightsSee exactly what changed.
Match on a keyCompare by ID, not row order.
Export the diffShare what moved.

How it works

Open the template

It loads with realistic sample data so you see a finished result immediately — nothing to set up.

Swap in your data

Type over the sample values, or upload your own file and map the columns in a couple of clicks.

Read, export, share

The Compare Files tool recalculates instantly. Export to Excel or send a live link.

Related templates

Common questions

How do I find what changed between two versions of a file?

Match rows on a key column, then compare the remaining fields. You get three lists: rows added, rows removed, and rows where a value changed, with the before and after side by side.

Can it compare files with columns in a different order?

Yes — matching is by column name and key, not by position, so a reordered or re-exported file still compares cleanly.

What if the two files have different column names?

Map them once — 'Customer' to 'customer_name' — and the comparison runs against the mapping. This is the normal case when comparing exports from two different systems.

Start from the Compare two file versions template

Open it with sample data, swap in your own, and export in seconds — no formulas, no blank page.

Use this template free →
No card required · works in your browser · export any time