How to compare two Excel files

Start with the question you need to answer

Before selecting files, decide what represents a record. In a product list, it may be one SKU. In an order export, it may be one order line. That decision determines how the comparison connects rows. It is more important than whether the rows happen to appear in the same order.

For example, a supplier may sort an updated price list by product name while the old list is sorted by SKU. Comparing line 2 with line 2 would mix up products. Matching by SKU lets the tool find the same product wherever it appears.

Prepare copies of the two versions

1. Keep your original files unchanged and work with copies if you need to clean headers.
2. Use .xlsx or .csv, with headers in the first row and one record per data row.
3. Make column names distinct. Use consistent names for fields that should be compared.
4. Check that identifiers are present and stable. Keep leading-zero codes as text in the source files if those zeros matter.
5. Remove unnecessary large ranges from a copy if the workbook exceeds the cell limit.

A workbook’s displayed formatting is not its underlying data. A number shown as 00123 through an Excel display format may still be stored as 123. This tool cannot recover zeros that are only formatting. Verify how your identifiers are stored before interpreting additions and removals.

Choose files and pair the sheets

Open the comparison workspace and choose both versions. File cards show when a workbook is ready. Sheets with the same name are paired automatically; if a sheet was renamed, select its updated counterpart yourself. Unpaired updated sheets are included as added sheets, and original sheets without a counterpart are treated as removed.

Choose how the rows match

Enter a key column, such as SKU, on each side. For a composite identifier, enter several names separated by commas, such as Order, Line. The number and order of identifying columns must correspond. You can use different key header names on the two sides, but matching data fields still depends on their header names.

Adjust only the settings you need

Ignoring outer spaces or letter case can suppress differences in text values that are irrelevant to your review. A numeric tolerance can suppress small numeric discrepancies. These settings do not normalize row identifiers. Start with exact comparison unless you have a clear reason to relax it.

If your concern is whether a formula changed, enable formula-text comparison. If you leave it off, the tool compares stored cell values. It does not run Excel’s calculation engine, so a saved workbook can contain stale formula results.

Review, then export

Run the comparison and check missing or duplicate key flags before trusting the totals. Inspect several known changes in the detail table. Then download the Excel report for a complete record of the summary, changes and review flags. The on-screen view is paginated; the export includes the complete result.