Compare two Excel files
Drop the old version, then the new one. Rows are matched by a key (an employee number, a reference) or by position, and you get an annotated workbook: green for what arrived, red for what left, yellow for what changed.
What this tool does
- The key suggested automatically when a column identifies every row; several columns allowed.
- Columns matched by name, even if their order changed; added or removed columns flagged.
- 12 and "12" are different, 0.1 + 0.2 and 0.3 are equal: we compare the way a spreadsheet calculates.
- An annotated result workbook, and a sheet listing every changed cell, before and after.
What it does not do: Values are compared, not formulas or formatting. Without a key, a row inserted in the middle makes everything after it look changed: the screen says so, and suggests a key when it finds one.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Merge Excel files : Files and sheets in a single table, even when the columns are not in the same order.
- Look up between two files : VLOOKUP between files, without a formula, and the list of what found nothing.
- Reconcile two lists : Statement and ledger, file and export: what matches, and the differences.
- Split a file : One file per branch, per sales rep, or per batch of rows, header repeated.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.