Find what changed between two spreadsheet reports
Compare equipment lists, tag registers and other report revisions with Excel Compare. Match rows by a unique tag or a combination of columns, review added and removed records, and export the differences.
- No account required
- Files processed locally
- XLSX, XLSM, XLS, CSV, TSV or pasted tables
What you can do with Excel Compare
Follow records across revisions
Match by key columns when rows have moved. A tag or a combination of columns identifies the record; renamed key columns can be mapped to their new names.
Focus on relevant changes
Ignore columns such as export timestamps, then review changed values, new records, removed records and skipped rows.
Take the review with you
Download a coloured result workbook or differences CSV. Check the workbook review notes for skipped rows and any export limits.
How it works
Open the two revisions
Choose the old and new reports, or paste both tables including their headers. Select the corresponding worksheet from each report and check the header-row setting.
Choose how records match
Use a unique key or several key columns for report revisions. Use cell position when the same cell addresses should be compared.
Review the differences
Inspect changed, added, removed and skipped rows before downloading the result workbook or CSV.
Your output: Result workbook and differences CSV. Your original files stay unchanged.
Before you start
Which spreadsheet formats can I compare?
Open XLSX, XLSM, XLS, CSV or TSV files, or paste tables from Excel with their header rows. The tool compares one worksheet from each report at a time. Each file can be up to 30 MB, with up to 100,000 data rows and 256 columns per worksheet.
Does it compare formulas, macros or formatting?
The tool compares saved, displayed cell values. It does not calculate formulas, execute macros, refresh external data or compare workbook styling. Recalculate and save both workbooks first. Different displayed number or date formats can count as value changes.
Should I compare by keys or by cell position?
Key matching works well when records move between revisions. Use unique tags or combine columns to identify each record. Position matching compares the same cell addresses, so inserted rows or columns can make later cells appear changed.
Why are some rows skipped?
In key mode, blank or repeated keys cause rows to be skipped; the first row with a repeated key is kept. Review the Skipped filter and the workbook’s Skipped rows sheet. Rename duplicate headers and fill blank headers, or compare by position.
Are reports uploaded or saved?
Reports are processed in browser memory and are not uploaded by the tool or saved to WordPress. Named comparison settings are saved locally only when you choose Save as. Downloaded results contain your report data. The website still loads application files normally.