About Compare Excel Files
See exactly what changed between two versions of a spreadsheet. Match rows by position or by a key column such as ID, then review highlighted changes and export a report listing every changed cell.
How to use Compare Excel Files
- Upload the original (A) and the new version (B).
- Choose how to match rows — by position or by a key column.
- Click “Compare” and download the diff report.
Limitations
- Everything runs in your browser’s memory, so the practical file size depends on your device. As a rough guide: up to ~50 MB or ~500,000 rows works well on a modern laptop; phones and tablets handle much less.
- Very large files can make the tab slow or crash. If that happens, split the file first or use a desktop computer.
- Outputs keep values and formulas’ results but not formatting, charts, images, pivot tables or macros.
Frequently asked questions
Why use a key column?
If rows were inserted, deleted or re-sorted, matching by an ID column compares the right rows with each other.
Can I ignore case and spaces?
Yes, both options are available.
What does the report contain?
A summary sheet with every row’s status and a “Cell changes” sheet listing old and new values.
Disclaimer: Excel Tools by gumber.ai is a hobby project and is completely free to use. It is provided “as is”, without warranty of any kind. Always double-check results before relying on them, and keep a copy of your original files.
Related tools
Remove Duplicates
Find and remove duplicate rows based on all columns or just the ones you pick.
Excel VLOOKUP
Pull matching values from a second table into your sheet — no formulas, no #REF errors.
XLOOKUP / INDEX-MATCH
Look up any column in any direction and return one or many result columns.
HLOOKUP Tool
Lookups for horizontal tables where headers run down the first column.