How to use Compare Excel files
Compare two spreadsheets using key columns. Review added, removed, and changed rows, then download the results as Excel.
When to use this tool
If the original has A001, A002, A003 and the update has A001, A003, A004, A004 is added and A002 is removed. Changed values for A003 appear alongside their previous values.
Choose files and settings
Choose two files and their sheets → Choose unique key columns → Review and save XLSX. Keep the original files until you have checked the output.
Before you save
The first row must contain headers. Choose keys that uniquely identify each row.
Supported features and limits
Both sheets must have the same headers, but column order may differ. Duplicate or empty keys stop comparison. Add another key column or clean the rows. Displayed values are compared as text. Formulas, styles, colors, and comments are not compared; formulas are not recalculated.
Check the result
Compare input and output row counts. Check leading zeros, blank values, and unmatched rows. Formatting and recalculated formulas are not part of the output.