Compare Excel Files with Reordered Rows
A useful spreadsheet diff depends on matching the right records. Compare by cell position when row order is stable; choose a key column when records have moved.
By Utilify team · Updated
Choose position or key matching
Utilify matches worksheets by name. With an empty key-column setting, it compares values at the same cell addresses. That is useful for a template or report whose rows stay in place. Sorting one file can otherwise turn a small change into many apparent differences.
If rows moved, choose a stable ID column by letter, header name or number. Prefer unique, non-empty IDs. Repeated keys are paired in occurrence order; they cannot reliably identify which duplicate record moved. Check the sheet report if a key column was missing and the tool used positional comparison.
Original: ID 101 → 20, ID 102 → 30 Modified: ID 102 → 30, ID 101 → 25 Key column: ID Changed: ID 101, value 20 → 25
Understand what is being compared
The result lists added and removed sheets and rows, plus cells whose displayed value changed. Formula evaluation, formatting, charts and macros are outside this comparison. A formula with a stale cached result can therefore require a fresh calculation in Excel before you compare the workbooks.
Review the total difference counts as well as the preview. Large reports may show only a capped set of differences even though their counters cover the complete comparison. Inspect a few changed IDs manually before relying on a reconciliation report.
Keep workbook contents on your device
Both files are read inside your browser and are not uploaded for comparison. Use fictional workbooks to learn the settings, then compare your own files. Very large workbooks depend on available browser memory; split them into smaller sheets when necessary.