Quick Answer
Excel's built-in comparison tools — the Inquire add-in and Spreadsheet Compare — require Office Professional Plus or Microsoft 365 Business Premium licenses, and neither handles structural differences like added/removed rows or changed column orders. Browser-based Excel comparison reads both files directly without conversion, compares sheet by sheet and cell by cell, and outputs a structured difference report for any Excel file regardless of your Office license.
What is Excel file comparison? Excel file comparison detects every changed cell, added row, deleted row, and added or removed sheet between two Excel workbook versions — without requiring Microsoft Office Professional Plus or any desktop software.
Fast Fix (60 Seconds)
Need to compare two Excel files right now:
- Open Excel Compare — no installation, no Office license required
- Upload File A (your baseline) and File B (the updated version)
- Select which sheets to compare (or compare all sheets)
- Click Compare
- Download the difference report showing every changed cell with old and new values
Tested using SplitForge Excel Compare against .xlsx files ranging from 500 rows to 500K rows, March 2026.
TL;DR: Microsoft's Spreadsheet Compare requires Office Professional Plus ($439/year per seat) and only works when both files have identical sheet structures. For files with added rows, reordered columns, or multiple sheets with different names, it produces incomplete or misleading results. Browser-based Excel comparison uses the SheetJS library to parse both files natively, compares by key column or row position, and handles structural differences gracefully — at no cost and with no data leaving your machine.
Table of Contents
- Fast Fix (60 Seconds)
- Why Excel's Built-In Comparison Tools Fall Short
- How to Compare Two Excel Files — Step by Step
- Common Excel Comparison Scenarios
- Handling Common Comparison Challenges
- Additional Resources
- FAQ
Your finance team sends a revised budget model every quarter. 847 rows, 23 cost centers, zero change log. You need to know exactly what changed between the Q2 and Q3 versions — which line items increased, which were cut, which were added — before the board presentation in 90 minutes.
You open both files side by side in Excel. You scroll through 800 rows looking for differences. You try conditional formatting — it highlights cells that are different, but only if both files are on the same worksheet, with the same layout. You try the Inquire add-in. It's greyed out — your organization uses Microsoft 365 Business Standard, not Professional Plus.
You end up copying both sheets into a third workbook and writing IFERROR(IF(A2=B2,"","CHANGED"),"MISSING") across 50 columns. It takes two hours to build — longer than you had — and produces a column of "CHANGED" flags with no context about what actually changed.
This is the standard Excel comparison problem. The tools that exist are either locked behind premium licenses or too rigid to handle real-world file variations. For more on Excel file size and architecture constraints, see our complete guide to Excel row limits and large file solutions. For CSV-based comparison workflows, see our guide to comparing two CSV files.
Why Excel's Built-In Comparison Tools Fall Short
Spreadsheet Compare (Microsoft) requires Office Professional Plus or Microsoft 365 Apps for Enterprise. Per Microsoft's official documentation, it is not available in standard Microsoft 365 subscriptions. Most business users don't have access to it.
Even when available, Spreadsheet Compare works best when both files have the same structure — same number of rows, same column order, same sheet names. If File B has new rows inserted in the middle, Spreadsheet Compare compares by row position, not by key — flagging every row below the insertion point as "changed" even when the values are identical.
The Inquire Add-In has the same license restriction and the same structural rigidity. It also doesn't export a machine-readable difference report — you get a visual overlay, not a downloadable CSV.
Manual VLOOKUP or conditional formatting requires both files to be in the same workbook, works only one column at a time, and breaks when row order differs between the two files.
Browser-based comparison solves the license problem (runs in any browser, free) and the structural problem (supports key-based row matching, not position-based matching).
Symptoms that tell you your Excel comparison method failed: The difference count changes when you sort either file before comparing (position-based failure). Cells flagged as "changed" show identical values when you look at them (encoding or locale mismatch). Every row below row 500 shows as different after you insert one row at row 499 (position-based cascade). The comparison completes with zero differences found — but you know values changed (formula vs. value mismatch, or the tool is comparing formatted display strings rather than underlying values).
Methods That Seem Like They Should Work (But Don't)
Excel "View Side by Side" (Synchronous Scrolling) Arranges two workbooks horizontally for manual visual comparison. Usable for files under 50 rows. At 800 rows across 20 columns, a human eye misses changes. Symptoms of failure: analyst reports "no differences found" then finance discovers 14 changed values a week later.
Conditional formatting with =A1<>Sheet2!A1
Compares cell positions, not row content. Insert one row in Sheet 2 and every cell below it flags as different — including identical values. Produces thousands of false positives for any file where rows were added or removed.
Copy-paste IFERROR formula approach
The IFERROR(IF(A2=B2,"","CHANGED"),"MISSING") pattern produces a binary flag with no context. You know something changed but not what it was, what the old value was, or what the new value is. Useless for audit reporting.
Microsoft Spreadsheet Compare Only available with Office Professional Plus — most users don't have it. When available, it compares by cell position, not by key column. Inserting a row in the middle of File B causes it to flag every row below the insertion as "changed." It also cannot export a machine-readable difference report for downstream processing.
Third-party Excel diff tools (xlcompare, Diffchecker) Upload your file to their servers. For confidential financial models, budget workbooks, or HR data, this creates compliance exposure. Most are also position-based and share the row-order limitation.
How to Compare Two Excel Files — Step by Step
Step 1: Open both files in Excel Compare
Navigate to Excel Compare. Upload File A and File B. The tool reads both .xlsx and .xls formats natively using SheetJS — no conversion to CSV required. Per ECMA-376 Part 1 §12.2, each worksheet's cell data is stored in a separate XML file within the workbook's ZIP archive, which is why key-based comparison can match rows regardless of their physical position in the file.
The tool shows you a summary of both files: sheet count, row count per sheet, and any sheets that exist in one file but not the other.
Step 2: Select your comparison mode
Key-based comparison (recommended for data files): Select a column that uniquely identifies each row. The tool matches rows by key value regardless of row position. Rows added, deleted, or reordered between files are correctly identified.
Position-based comparison (for fixed-structure reports): Compares row 1 to row 1, row 2 to row 2. Useful for financial models or reports where row positions are fixed and meaningful.
Step 3: Select sheets to compare
If both files have multiple sheets, choose which sheets to compare. You can compare all sheets at once or focus on a specific sheet. Sheets that exist in File A but not File B are flagged as deleted sheets, and vice versa.
Step 4: Run the comparison
Click Compare. The tool processes both files and generates the difference report. For a 100K-row, 20-column Excel file, this typically takes 8–12 seconds.
Step 5: Review and export the results
The results are organized in four categories:
- Changed cells — cells where the value differs between File A and File B, with old value, new value, sheet name, and cell reference
- Added rows — rows in File B not present in File A (key-based mode) or rows beyond File A's row count (position mode)
- Deleted rows — rows in File A not present in File B
- Added/deleted sheets — sheets present in one file but not the other
Export the full report as a CSV or XLSX for sharing with your team or attaching to an audit log.
Common Excel Comparison Scenarios
Quarterly financial model review
Compare this quarter's budget model against last quarter's to identify every changed assumption, revenue figure, or cost line item. Use key-based comparison on the line item ID column. The difference report becomes your change log.
Contract version comparison
Two versions of a pricing contract in Excel format. Key on the item number column. Identify which line items had prices changed, which were removed, and which are new additions — before legal sign-off.
Data pipeline QA
Compare the output of a revised ETL pipeline against the known-good baseline output. Any discrepancy at the cell level indicates a pipeline regression. Position-based comparison works well here when the output structure is fixed.
Audit trail generation
Your ERP exports financial data to Excel weekly. Compare this week's export against last week's to detect any retroactive changes to closed period entries — a common internal audit requirement.
Handling Common Comparison Challenges
Files have different column orders
The tool aligns columns by header name, not position. Column order differences between files don't affect comparison accuracy.
Files have merged cells
Merged cells in Excel store their value in the top-left cell of the merge. The tool reads merged cells correctly — the displayed value is used for comparison.
Files have formulas
The tool compares computed values, not formula strings, by default. If a formula changed but produces the same result, it won't be flagged as a difference. Enable "Compare formulas" mode to detect formula changes regardless of output value.
Files have different sheet names for the same data
Map sheets manually in the configuration step. Tell the tool that "Budget_Q2" in File A corresponds to "Budget_Q3" in File B — it will compare those sheets directly.
Edge Cases That Break Excel Comparison
Merged cells Excel stores the value of a merged cell only in the top-left cell of the merge. The other cells in the merge are empty. A position-based comparison tool sees the non-top-left cells as blank — producing false differences. Key-based comparison avoids this by operating on cell values, not positions.
Hidden rows and columns Excel allows rows and columns to be hidden without deletion. Hidden rows still contain data and are included in sheet XML — but they won't be visible in the spreadsheet view. A comparison that doesn't account for hidden rows may miss genuine differences.
Date serialization differences
Excel stores dates as serial numbers (days since January 1, 1900). The same date can be represented as 44930 (serial), 2023-01-01 (ISO), or January 1, 2023 (formatted) depending on cell formatting. Two cells with the same underlying serial number but different display formats will appear as "different" to a naive comparison. Compare underlying values, not display strings.
Formula vs. computed value
=SUM(A1:A10) and 55 may represent the same value, but the formula and the static value are structurally different. Choose whether to compare formulas or computed values before running comparison — both are valid but answer different questions.
Sheets with the same name across files When both workbooks have a sheet named "Summary," comparison tools assume they correspond. If "Summary" in File A is the executive summary and "Summary" in File B is a data summary, the comparison produces meaningless results. Verify sheet correspondence before running.
Currency and locale formatting
$1,000.00 and €1.000,00 may represent the same underlying number formatted for different locales. Comparison tools that operate on display strings will flag these as different. Compare underlying numeric values when possible.
Additional Resources
Microsoft Documentation:
- Microsoft Spreadsheet Compare documentation — official tool requirements and limitations
- Microsoft Excel specifications and limits — row limits and structural constraints
Technical References:
- SheetJS Community Edition documentation — Excel file parsing library used for browser-based processing
- MDN: File API — browser-native file reading without upload
- MDN: Web Workers API — background processing for large Excel files