Spreadsheet Diff (Added, Removed and Changed Cells by Key)

Compares an old and a new table and lists the differences cell by cell.

Use the tool

Why this tool exists

Before you replace a file, see what really changed. Match rows by a key column when the order may differ, or by position when it cannot. The result shows removed rows with a minus, added rows with a plus and changed cells as old to new.

Colour is never the only signal. Columns that exist in only one table count as differences too. The key column must be unique in both tables; if not, the tool says so rather than guessing.

How to use it

  1. Paste the old table in the first box and the new one in the second.
  2. Enter the key column, or clear it to match by position.
  3. Read the summary counts and the table.
  4. Copy the text list of changes.

Frequently asked questions

What if rows moved?

With a key they are matched wherever they are.

Are numbers compared as numbers?

No, as text, so 2.5 and 2.50 differ.

Added columns?

Shown as changes from "(no column)".

Large files?

Fine to some tens of thousands of rows.