1. Home
  2. Spreadsheets & Data
  3. Compare Excel Files

Compare Excel Files

Compare two spreadsheets cell by cell and highlight what changed.

For every format and option in one place, use Excel & CSV Workbench →

Runs in your browser · No upload
The table opened in the workbench is the left one and the table you load below is the right one. Pick key columns to match rows, or compare two lists one column each.

Operations

Compare two tables cell by cell on key columns, or find what two lists share and what only one has.
Second table
Load the second table (file or paste).
Key columns (leave empty to compare row by row)
Result: Same · Changed · Added (right only) · Removed (left only). Changed cells are highlighted.
Files are processed in your browser and never sent to a server.

How to use

  1. Open the reference (left) .xlsx or .csv file first. This page opens with a Compare two tables step already added.
  2. In the step card’s Second table, drop or paste the file to compare against (the right one) and check its sheet, encoding and header setting.
  3. Choose the compare mode: cell by cell to match whole rows, or two lists to compare the values of one column on each side.
  4. For cell by cell, pick the key columns (the column that identifies a row, such as an employee or order number) and set the case, space and number options.
  5. Changed cells are highlighted in the result table, and you can get everything from the changed cells list and the change-list CSV below.

Cell-by-cell results

A Compare result column is added after the left table with one of four values.

Result Meaning
Same Every compared column of the matched row is equal
Changed A match exists but at least one cell differs (those cells are highlighted)
Removed Only in the left table (a row that disappeared on the right)
Added Only in the right table (appended at the bottom, whole row highlighted)

Here is a comparison of two tables on id.

id name qty
Left 1 Kim 10
Left 2 Lee 5
Left 3 Park 7
Right 1 Kim 10.0
Right 2 LEE␠ (trailing space) 6
Right 4 Choi 1

The result is id 1 Same (10 and 10.0 are equal as numbers), id 2 Changed, id 3 Removed, id 4 Added, and the report reads Same 1 · Changed 1 · Added 1 · Removed 1 (2 changed cells). The change list has two lines: 2 | name | Lee → LEE␠ and 2 | qty | 5 → 6. Surrounding spaces are ignored by default but case is not, so Lee and LEE differ. Turn on ignore case and name matches, leaving qty as the only changed cell.

Comparison rules

  • Number comparison (on by default): numbers with the same value are equal, such as 10 and 10.0 or 1,000 and 1000. A text with leading zeros such as 007 is treated as a code, not a number, so it differs from 7. Turn it off to compare the text exactly.
  • With key columns, rows with the same key are paired. When a key repeats, rows pair up in the order they appear and the unpaired side becomes removed or added. Key values follow the same rules (spaces, case, numbers).
  • With no key columns, row N is compared with row N. Compared that way without a key, the example above gives Same, Changed, Changed because ids 3 and 4 differ in row 3, and one inserted row would shift everything after it, so use a key column when you can.
  • Columns are matched by name. Order does not matter, and columns found on one side only are not compared; their names are listed in the step report.
  • The changed-cell list holds up to 50,000 entries and the page shows 200 lines; the CSV contains the whole list (up to 50,000).

Comparing two lists

Compare one column on each side to get a three-column table of In both / Left only / Right only. Use it to check a name list or find what is missing. Duplicates collapse into one, blank cells are skipped, and the same rules (spaces, case, numbers) apply.

If the left column is x, y, Z, (blank), x and the right column is y, z, w, (space), then y is in both, x and Z are left only, and z and w are right only (In both 1 · Left only 2 · Right only 2). With ignore case on, Z and z match, so y and Z are in both, x is left only and w is right only.

Your files are processed only in your browser and are never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.