Compare Excel Workbooks: Methods, Steps, and Differences

How-to basics · Updated November 22, 2026

To compare Excel workbooks, use View > View Side by Side for a visual review, Spreadsheet Compare for a detailed report of cell and formula differences, or Power Query when you need to match and analyze larger tables. The right method depends on whether you want to spot layout changes, identify exactly what changed, or reconcile records between two files.

What comparing Excel workbooks can reveal

“Compare workbooks” can mean several different tasks. You might want to see whether two files contain the same numbers, find formulas that were edited, identify a deleted worksheet, or check whether formatting changed. These are not interchangeable checks: viewing two files next to each other helps with visual review, but it does not automatically flag every difference.

It also matters whether the files have the same structure. If the worksheets use the same names and rows and columns still represent the same records, cell-by-cell comparison is practical. If rows have been inserted, sorted, or rearranged, matching cell A10 in each file may compare different records. In that case, use a unique identifier—such as an invoice number or product code—to match rows before evaluating changed fields.

Excel’s built-in options serve different purposes:

  • View Side by Side: compares two open windows visually, with optional synchronized scrolling.
  • Spreadsheet Compare: produces a structured report of differences between two workbook files, when the tool is available in your Office edition.
  • Formulas: check selected cells or aligned tables when you can place the data in one workbook.
  • Power Query: imports, matches, and compares tables, especially when records may be in a different order.

Compare files visually with View Side by Side

For a quick review in Excel for Microsoft 365 on Windows, open both workbooks, then select View > View Side by Side. If Excel asks which workbook to compare with the active one, choose the other file. The two windows appear together. Select View > Synchronous Scrolling if you want scrolling in one window to move the other window as well. Select View Side by Side again to turn the arrangement off.

This approach is useful when checking reports with similar layouts, inspecting charts, or following a visible change through corresponding worksheets. It does not calculate a difference report, confirm that every cell matches, or necessarily pair up equivalent records. If the sheets have different row heights, hidden rows, zoom levels, or layouts, visual alignment can be misleading. Check the sheet names and headings in both windows, and remember that each file may show a different active worksheet.

To make the visual check easier, maximize Excel, use a consistent zoom level, and arrange the workbooks so the same columns are visible. You can also use View > Arrange All to organize open workbook windows. On Excel for Mac, the exact window-arrangement controls can differ by version; use the View tab’s window options if available, or arrange the open workbook windows through macOS. Excel for the web does not provide the same full desktop window-comparison workflow, so opening the files in the desktop app may be more convenient for this method.

Use Spreadsheet Compare for a difference report

Spreadsheet Compare is a Windows desktop tool designed to compare two Excel files and report differences in workbook content. Depending on your Microsoft 365 or Office license, it may appear as the Spreadsheet Compare app in the Windows Start menu or be accessible from Excel’s Inquire tab. The Inquire add-in and comparison tool are not included with every Office edition, so their absence does not mean Excel is malfunctioning.

If your edition supports Inquire but its tab is not visible, check File > Options > Add-ins. In the Manage list, select COM Add-ins and choose Go; if Inquire is listed, select its checkbox and confirm. When available, use Inquire > Compare Files and select the two workbooks. If the app is installed separately, open Spreadsheet Compare from the Windows Start menu and select the files there. The labels and availability can vary by Office installation.

The report can categorize differences such as changed cell values, formulas, and formatting, as well as some workbook-structure differences. You can inspect results by worksheet and difference type instead of searching through every cell manually. A formula change is significant even when the displayed result happens to be the same; for example, two different formulas may currently return 100 but behave differently when their inputs change.

Treat the report as a way to locate differences, not as an automatic judgment about which file is correct. Confirm important changes in context: a changed date may be an intentional update, while an unexpected formula replacement may need investigation. Spreadsheet Compare is not a general-purpose version-control system, and it does not resolve conflicts or merge both workbooks into a single authoritative file for you.

Compare aligned cells with a formula

A formula is useful for a small, controlled comparison, especially when you can copy the relevant worksheets into one workbook. First, make a copy of each source file or work in a separate comparison workbook. Copy the corresponding worksheets into that comparison workbook, naming them Old and New, and ensure the cells you intend to compare have the same meaning in both sheets.

With the values to compare in Old!A1 and New!A1, enter this formula in another cell, such as Check!A1:

=IF(Old!A1=New!A1,"Same","Different")

If both example cells contain the number 42, the formula returns Same. If Old!A1 contains 42 and New!A1 contains 43, it returns Different. Fill the formula across and down to check a rectangular range, adjusting the layout so each comparison result sits beside the corresponding data. If your sheet names contain spaces, Excel requires apostrophes around the names, as in 'Old Data'!A1.

This simple test has limits. Excel’s equals operator does not distinguish uppercase from lowercase in text, so “North” and “NORTH” compare as equal. It compares the underlying cell values, not whether fonts, fills, borders, or number formats differ. Also check how blanks and formulas returning an empty string behave in your particular layout; a displayed blank does not always mean the cells are identical in every respect. For a formatting audit or a thorough workbook-level comparison, use Spreadsheet Compare where available.

Use Power Query when rows need matching

When two files contain tables whose rows may be in different orders, Power Query can compare them by a key rather than by row position. This is often a better fit for customer lists, inventory exports, or monthly transaction files. Each table needs a reliable matching field, such as a unique order ID. If the chosen key occurs more than once, a merge can produce ambiguous or repeated matches, so check that the key is actually unique.

In Excel for Microsoft 365 on Windows, import each file using Data > Get Data > From File > From Workbook, then choose the relevant worksheet or table in the Navigator and load it to Power Query. In the Power Query Editor, use Home > Merge Queries, choose the second table, and select the key column in each table. Choose a join type that fits the question: a full outer join is useful when you want to retain records appearing in either table, while an inner join keeps only records that match on the key.

After merging, expand the columns you need to inspect, such as status, quantity, or price. Compare the old and new values in the resulting table and filter for mismatches or missing records. A row found only on one side may indicate a new or deleted record, but it can also mean the key changed or contains inconsistent spaces or data types. Clean and validate keys before treating unmatched rows as genuine additions or removals. Power Query is for transforming and analyzing data; it does not automatically identify every formula or formatting difference in the source workbooks.

Choose a method that fits the question

Start by defining what “different” means for your review. If the question is whether a report’s visible layout changed, open both files and compare them side by side. If you need a list of changed formulas and cell contents across two similar workbooks, check whether Spreadsheet Compare is available. If you need to verify a small range with matching rows and columns, a formula-based check may be quicker. If rows have moved or the files are exports with stable IDs, use Power Query to match records by key.

Consider the size and importance of the check as well. For a short list, manual inspection may be adequate, but a large workbook makes missed differences more likely. For a recurring monthly comparison, a repeatable Power Query process or a documented comparison workbook can reduce repetitive work. For a high-stakes review, combine methods: use a structured comparison to find changes, then inspect the relevant worksheets and formulas in their business context.

Common problems and checks before you trust the result

  • Rows are out of order: do not compare by cell address until you confirm that corresponding rows represent the same records. Match by a unique key when possible.
  • Formulas look the same but differ: inspect the formula itself, not only the displayed result. Relative references can point to different cells after copying or moving a formula.
  • Displayed values hide differences: number formats can make distinct underlying values look alike, or make equal values display differently. Decide whether you are comparing stored values, formulas, or appearance.
  • One workbook has extra content: check for hidden worksheets, filtered rows, hidden columns, and named ranges if the comparison tool or your review does not seem to account for expected content.
  • External links or refreshed data are involved: a workbook may show results affected by linked files or data refreshes. Record whether you are comparing the saved values or refreshed results, and avoid updating links unless that is part of the intended review.

Protect the originals while comparing. Work from copies when you plan to reorganize sheets, add formulas, or transform data. If a workbook contains sensitive information, use an approved location and share only the comparison output needed by its recipients. A difference report can itself expose values or formulas from both source files.

Frequently Asked Questions

Can Excel compare two workbooks automatically?
Yes, if Spreadsheet Compare is available in your Office installation, it can generate a report of differences between two files. Otherwise, Excel still offers visual comparison and methods such as formulas or Power Query, but these require you to set up the comparison.

Does View Side by Side tell me which cells are different?
No. It displays two workbook windows together and can synchronize scrolling, but it does not highlight mismatched cells or create a difference report. Use Spreadsheet Compare or a deliberate data-comparison method to identify differences.

Can I compare workbooks when rows are sorted differently?
Yes, but avoid comparing the same cell addresses as though they represented the same records. Match the tables using a stable, unique ID with Power Query or another suitable lookup-based workflow, then compare the fields for matching IDs.

Why can’t I find Spreadsheet Compare in Excel?
The tool is available only with certain Windows Office editions and installations. Check whether your license includes Inquire or Spreadsheet Compare; the feature may be missing from some retail or other Microsoft 365 plans. Excel for Mac and Excel for the web do not offer the same Windows comparison app.

Can a comparison detect formatting changes as well as data changes?
Spreadsheet Compare can report formatting differences when the tool and comparison settings support them. A simple equality formula checks cell values, not formatting, and View Side by Side leaves the interpretation to you. Choose a method based on whether appearance is part of what you need to verify.

Related

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.