Compare Excel files by ID, not row position
Updated
Match records by ID, even when rows and columns move.
Show an example
Match the old and new supplier lists by SKU, then compare Price against Unit price. A reordered row is still the same record. Repeated or empty IDs are reported separately, never silently paired.
Method and limits
SheetMatch reads the first row as headers. Choose one key column per table and map the fields to compare. Unique keys are matched regardless of order. Duplicate and blank keys are isolated for review. Counts for changed, added and missing records refer to unique keys; duplicate and blank counts refer to rows across both inputs. The report lists each affected field with source row numbers.
Formula cells use their saved results; formulas are not recalculated or compared as code. Save and recalculate your workbook in Excel first. Formatting, merged cells and macros are not compared. Store IDs with leading zeros as text. Numeric tolerance uses an absolute difference and decimal-point numbers; comma decimals and currency-formatted text are compared as text. Review the report before changing business records.
XLSX or UTF-8 CSV · 10 MB per file · 20,000 rows per sheet · 100 columns · 500,000 cells per workbook
Privacy
Your files stay on this device.
PrivacyOpen the tool