How to Compare Two Excel Files for Differences

Two versions of a spreadsheet look identical until the one changed number breaks a total three tabs away. Finding it by eye across thousands of cells is hopeless, and Excel's own comparison tools are surprisingly hard to reach — the Spreadsheet Compare utility only ships with specific enterprise editions, and the Inquire add-in isn't enabled by default. Here's a faster way to diff two spreadsheets and see every difference at once.

Compare two spreadsheets in the browser

1. Open the Compare Spreadsheets tool.
2. Load the old version on the left and the new version on the right. XLSX, XLS, and CSV all work.
3. Changed cells are highlighted, added rows marked, and removed rows struck through — so you jump straight to what moved.

The differences that matter most

• Changed values — a single edited figure that quietly changes a downstream total.
• Inserted or deleted rows — these shift everything below and are the usual cause of a reconciliation that no longer ties out.
• Reordered data — the same rows in a different order, which a naive line-by-line diff would wrongly flag as thousands of changes.

Match by key, not by position: when rows can move, comparing row 5 to row 5 is meaningless. Comparing by a stable identifier — SKU, invoice number, employee ID — catches the real changes and ignores reordering. That's the difference between a useful diff and a wall of false positives.

CSV exports from different systems

A common real-world job is reconciling two exports of the same data — a system report versus a physical count, or this month's export against last month's. CSVs are plain text, so they compare cleanly, but watch for cosmetic differences (quoting, date formats, trailing spaces) that aren't real changes. A structure-aware comparison focuses on the values in each cell rather than raw text, which cuts through that noise.

Formulas vs. values

Decide up front whether you care about the formula or the result. Two cells can show the same number while one is hard-coded and the other is a live formula — a meaningful difference when you're auditing a model, irrelevant when you're checking outputs. Know which question you're asking before you start.

Financial spreadsheets are sensitive, so it matters that the file is read locally in your browser and never uploaded to a server.

For budgets, monthly reports, and bank exports, the finance comparison tools apply the same private, in-browser approach to every spreadsheet you work with.