Compare Excel Files

Compare two spreadsheets by key column to find edits, additions, deletions, and moved rows.

Quick start

  1. Upload the files from before and after the edit.
  2. Pick the key column that pairs the rows.
  3. Review the changes, apply them, and download the result.

Example

Add a 30-row original product table and its revised copy, then choose Code as the key column. Only the 4 changed stock cells (for example, P-1002 from 25 to 30), 2 added rows and 1 deleted row appear in the result. The 25 unchanged rows are only counted, and each changed cell shows its before and after values side by side.

Product table with code, product, price and stock columns and no change marks
BeforeAn original product table with no marks showing how it differs from the revised file
Comparison result listing changed cells and added or deleted rows by product code
AfterChanged cells, added rows, and deleted rows highlighted by product code

A revised spreadsheet arrived, but you cannot tell what changed

Compare two spreadsheets by key column to find edits, additions, deletions, and moved rows. Choose which changes to keep and create a final workbook.

How to use it

  • Upload the original and revised workbooks.
  • Choose one or more key columns with unique row values, such as an order number or product code.
  • Review edits, additions, deletions, and moves. Choose how to handle each and download the final workbook and change list.
  • Rows with blank or duplicate keys are listed for review.

Find only the changes between two spreadsheets

When a revised file arrives without highlighted edits, finding changes across hundreds of rows by eye is difficult. It gets harder when the row order changes.

This tool matches rows by key rather than position. It reports changed, added, deleted, and moved rows; you can combine up to two keys, such as branch and product code.

Duplicate or blank keys cannot be matched confidently and need review. Renamed columns are treated as different columns. Values such as the number 100 and text “100” may also compare differently.

What this helps with

  • Opening two workbooks side by side and scanning by eye → Compare rows by key and choose changes individually.
  • Finding Excel’s built-in comparison features → Upload the files and select the key columns.
  • Using XLOOKUP, which may silently take the first duplicate → Review duplicate keys instead of accepting an uncertain match.

Limitations

  • Blank and duplicate keys are not matched automatically. Fix the source or add another key.
  • Columns with different names are treated as different columns.
  • Formatting-only changes are not detected; values are compared.