DataMimiDataMimi

Compare two Excel files

See which rows were added, which were removed, and which cells changed between two versions.

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Compare two Excel files

  1. 1Select your files, or drop them on the page
  2. 2Run it — nothing to set up
  3. 3Download comparison.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

Questions

How does it match rows between the two files?

It looks for a column whose value is unique on every row in both files — an invoice number, an order ID, an SKU — and matches on it. If there is none, it compares whole rows instead and tells you so.

What if the columns are in a different order?

Columns are matched by name, not position. Columns that exist in only one file are listed separately.

What does the result contain?

A workbook with the rows only in the first file, the rows only in the second, and — when rows can be matched — one line per changed cell showing the old and new value.

Does 500 vs 500.00 count as a change?

No. Numbers are compared as numbers and text is compared without surrounding spaces, so formatting differences are not reported as changes.

More Excel tools

See all