Excel Workbook Comparison Tool: How to Compare Files

For Microsoft Excel for Microsoft 365 on Windows, the dedicated workbook comparison tool is Spreadsheet Compare, available with certain Office editions and organizational licenses. Open it from the Windows Start menu or, when the Inquire add-in is available, use Excel’s Inquire tab and choose Compare Files; it reports differences between two workbooks, including changes to cell values, formulas, and formatting.

What an Excel workbook comparison tool does

A workbook comparison tool examines two Excel files and presents differences in a more structured way than opening each file and switching between them. This is useful when a budget, inventory, forecast, or reporting workbook has been edited by different people or saved as multiple versions. Instead of relying on memory or scanning every sheet, you can inspect reported changes and decide whether each one is expected.

Spreadsheet Compare is designed to identify differences between workbook contents. Depending on the comparison settings and the files, its report can include changed cell values, formulas, formatting, and other workbook elements such as defined names. It shows where changes occur and provides detail for reviewing them. It is an inspection tool: it does not automatically determine which version is correct, merge edits safely, or replace one file with a reconciled workbook.

That distinction matters. A report can show that a total changed, but the reviewer still needs to establish whether the change came from a valid update, an altered formula, or an accidental edit. Comparison is a way to find and assess differences, not a substitute for checking the business meaning of the data.

Where to find Spreadsheet Compare

Spreadsheet Compare is a Windows desktop utility associated with certain professional or enterprise editions of Microsoft Office. It is not a feature that every Excel license includes. Its availability can depend on the Office edition and how an organization deployed its Microsoft 365 Apps, so the application or add-in may be missing even when Excel itself is installed. Check your organization’s license or Microsoft’s current product documentation if you need to confirm eligibility.

On a Windows computer where the utility is installed, search the Start menu for Spreadsheet Compare and launch it. The application provides an option to compare files; select the older and newer workbooks and start the comparison. In supported Excel installations, the same comparison may be available through the Inquire add-in:

In Excel, select File > Options > Add-ins.
At the bottom, set Manage to COM Add-ins and select Go.
If Inquire appears in the list, select its checkbox and choose OK.
Open the Inquire tab and select Compare Files, then choose the two workbooks.

If Inquire is not listed, that does not mean the workbook is damaged. The feature may not be included in that Office edition or deployment. These Windows instructions do not apply to Excel for Mac or Excel for the web, which do not provide the same Spreadsheet Compare workflow. Mac and web users can use an available alternative, such as a formula-based check, or perform the comparison on a supported Windows installation.

How to prepare the files and read a comparison

Before comparing, make sure you have identified the correct files and their dates. Keep an untouched copy of each original, and use clear names such as Forecast_before_update.xlsx and Forecast_after_update.xlsx. If the workbooks contain confidential information, store them in an approved location and avoid uploading them to an unapproved online comparison service.

For a clean comparison, check that the files are genuine versions of the same workbook. If one file has been reorganized substantially, with sheets renamed, rows inserted, or columns moved, the report may show many differences that reflect layout changes rather than meaningful data edits. If the files contain links to external workbooks or rely on refreshed data, note that context before interpreting changed results.

After running a comparison, review the summary and then inspect the reported changes in context. A changed formula may explain why several result cells differ; treating every changed result as an independent error can lead to the wrong conclusion. Conversely, matching displayed values do not prove that two formulas are identical. If the tool identifies a formatting change, consider whether it affects readability or signals a changed number format, rather than assuming the underlying value changed too.

Start with the overall number and types of differences, then review high-impact sheets and totals.
Check formulas and their precedent cells when calculated results differ.
Confirm that inserted, deleted, or moved rows have not shifted the meaning of the comparison.
Record which differences are accepted, corrected, or still need investigation.

What the comparison can and cannot tell you

A comparison report identifies differences; it does not explain their cause. For example, if a department’s quarterly expense is different, the tool can help locate the changed cell and reveal whether its formula or formatting also changed. It cannot tell you whether the department submitted a corrected invoice or whether the new number is authorized. That requires source documents and judgment from someone familiar with the workbook.

It is also important to distinguish a cell’s formula from its displayed result. A formula can be changed while producing the same result at the moment of comparison, or a result can change because its inputs changed even though the formula did not. Calculation settings, external links, volatile formulas, and data refreshes can affect what a workbook displays. If a difference seems surprising, check the formula bar, inputs, calculation status, and workbook dependencies rather than relying on the headline result alone.

Spreadsheet Compare is not a collaborative merge system. It will not automatically combine two edited copies while resolving conflicts, nor does a comparison itself protect either original. Save a separate working copy before making corrections. For shared workbooks, version history and a clear approval process can help explain who made a change and when, while comparison helps pinpoint what is different.

Compare aligned cells with a formula

When you do not have Spreadsheet Compare, a worksheet formula can check corresponding cells if both versions have the same layout. For example, assume the current workbook has sheets named Sheet1 and Sheet2 and you want to compare their cells at matching addresses. In a separate comparison sheet, enter the following in A1 and fill it across and down for the area you need to inspect:

With the compared values in Sheet1!A1 and Sheet2!A1, this formula returns Different if those cells are 120 and 125, respectively, and Same if both contain 120: =IF(Sheet1!A1=Sheet2!A1,"Same","Different")

This is a simple value check, not a full workbook comparison. It compares the values Excel evaluates in those cells, so it does not flag two different formulas if they currently return the same value. It also does not inspect formatting, comments, sheet structure, or named ranges. Excel’s ordinary equality comparison is not case-sensitive for text, and errors in a compared cell can cause the comparison formula to return an error. Resolve those limitations or use a dedicated tool when the workbook’s structure and formulas matter.

For a visual scan, you can also use conditional formatting on one range to highlight cells that differ from a corresponding range on another sheet. That approach requires a suitable rule and correctly aligned ranges; it is less convenient when sheets have different shapes or rows have been inserted. For lists of records, compare stable identifiers, such as an invoice number, rather than assuming that the same record remains on the same row.

Choosing between tools and alternatives

The right approach depends on how the workbooks differ and what you need to verify. A dedicated comparison is usually the most useful choice for reviewing two versions of a complex workbook on a supported Windows installation. A formula or conditional-formatting check can be enough for a small, consistently arranged range. For records that have been sorted or reordered, matching on a unique key is safer than comparing cells by position.

Spreadsheet Compare: Best when you need a broad review of two workbook files, including formula and formatting differences, and your Office setup includes it.
Cell formulas or conditional formatting: Useful for a limited, aligned area when you can define exactly what counts as equal.
Excel tables and lookup-based reconciliation: More appropriate when rows may move and records can be matched by a reliable ID. Check that each ID is unique and account for records present in only one version.
Version history or a document-management system: Helpful for recovering earlier saved versions and understanding change history, but not necessarily a detailed cell-by-cell comparison report.
Third-party comparison software: A possible option for unsupported Office editions or specialized workflows. Review its privacy terms, file handling, supported Excel features, and licensing before using it with sensitive workbooks.

Power Query can help shape and reconcile tabular data, but it is not a direct replacement for a workbook-difference report: it is aimed at importing and transforming data, and you must design the matching and comparison logic. Likewise, viewing two windows side by side can make manual review easier but does not automatically identify every changed formula, format, or workbook element.

Common problems and safer review practices

A large report does not always mean that the underlying data has been extensively edited. Differences in sheet structure, formatting conventions, or row order can produce noise. Before drawing conclusions, verify that the two files represent comparable states and that corresponding sheets and records are being matched correctly. If one workbook contains an extra row, for instance, position-by-position checks below that row may compare unrelated records.

Protected sheets, password-protected files, unsupported workbook features, and external data connections can also affect what can be opened or interpreted. Do not remove protection or bypass organizational controls simply to run a comparison; ask the file owner for an authorized copy or access. For files with macros, use trusted copies and follow your organization’s security rules. A comparison report is not a malware scan and does not establish that either workbook is safe.

Keep a review trail for decisions that affect important figures. Note the workbook names, comparison date, significant differences, and who approved any corrections. Never overwrite the only copy of an original while investigating. For financial, regulated, or operational workbooks, use the organization’s required review and retention procedures in addition to any Excel tool.

Frequently Asked Questions

Does every version of Excel include Spreadsheet Compare?
No. Spreadsheet Compare and the Inquire add-in are available only with certain Windows Office editions or deployments. If neither the application nor Inquire appears, check your license and deployment with your administrator.

Can I compare two Excel files in Excel for Mac or Excel for the web?
Those versions do not offer the same Spreadsheet Compare tool found in supported Windows installations. You can compare a small aligned range with formulas or another approved method, or use a supported Windows computer if your license includes the utility.

Will Spreadsheet Compare show which formulas changed?
It can report formula differences between workbooks, which helps distinguish a changed calculation from a changed result. Review the formulas and their inputs to understand the effect; the report does not decide whether a formula change is correct.

Can I compare workbooks when rows have been sorted or inserted?
Yes, but row shifts can make a position-based comparison confusing or produce many apparent differences. For records that may move, match them by a stable unique identifier and check for missing or duplicate IDs.

Does comparing files merge the changes?
No. The comparison identifies differences for review; it does not safely merge edits or choose a winning value. Make any approved changes in a separate working copy and preserve the originals.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.