How to Compare Two Excel Files for Differences

How to Compare Two Excel Files Online (Free)

1. Open the Excel comparison tool and choose file A (for example the older export) and file B (the newer one). Both are parsed locally in your browser.
2. Pick the sheet to compare in each file — they default to the first sheet and can be compared even when the sheet names differ.
3. Pick the key column in each file: the column that uniquely identifies a row, such as an ID, SKU, or order number. It defaults to column A.
4. Keep “First row is a header” enabled when row 1 contains column titles.
5. Click Compare files, review the summary, and download the diff report named {file-a}-vs-{file-b}-diff.xlsx.

The key column matters: without it, a comparison can only line rows up by position, so one inserted row makes everything after it look “changed”. Aligning by key means an inserted customer shows up as one Added row instead of a hundred false changes.

• Compare Two Excel FilesKey-based diff with a downloadable report.

Reading the Diff Report

The downloaded workbook contains two sheets. Summary gives the counts at a glance: how many rows were added, removed, and changed. Changes lists every difference on its own row, with the key value, the column affected, and the old versus new content side by side.

• Added — a key exists in file B but not in file A.
• Removed — a key exists in file A but not in file B.
• Changed — the same key exists in both, but one or more cells differ; each differing cell is reported individually.

Your original files are never modified — the report is a separate new workbook, rebuilt from cell values, so formatting in the report itself is simplified.

How to Compare in Excel Manually (For Reference)

Excel ships comparison abilities, but each is a partial fit:

• View Side by Side (View tab) shows both windows and scrolls them together — useful for eyeballing, but differences are found by your own eyes.
• Spreadsheet Compare (included with Microsoft 365 Apps for enterprise and Office Professional Plus) produces a real cell-level diff, but it is a separate desktop program many installs simply do not have.
• The Inquire tab exposes workbook analysis and compare commands on the same enterprise editions.
• A formula approach — =A2=B2 filled down, or a COUNTIF/MATCH lookup per key — works on any edition, but you build it yourself every time and it does not produce a tidy change list.

None of these run on a phone or a machine without Office, and none produce a shareable change log — which is usually what a reviewer or manager actually wants.

Beyond Compare: Understanding the Combined Data

If the point of the comparison is not the differences but the data itself — totals, distributions, outliers across the merged result — the quick data-analysis tool summarizes a workbook without formulas: per-column type detection, basic statistics, and value counts in one pass.

• Analyze Excel DataInstant column-level summary of any workbook.
• Merge Excel FilesCombine the two files into one after comparing.