How to use
- Open the reference (left)
.xlsxor.csvfile first. This page opens with a Compare two tables step already added. - 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.
- Choose the compare mode: cell by cell to match whole rows, or two lists to compare the values of one column on each side.
- 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.
- 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
10and10.0or1,000and1000. A text with leading zeros such as007is treated as a code, not a number, so it differs from7. 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, Changedbecause 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.
Related tools
- Pull columns across by key: VLOOKUP Two Files
- Clean duplicates before comparing: Remove Duplicate Rows
- Compare JSON data: JSON Diff
- Compare two texts: Text Diff
- Stack several steps: Excel & CSV Workbench
Your files are processed only in your browser and are never sent to a server.