Choose the comparison workflow for your task
Compare Two Excel Sheets for Differences within the same workbook or between workbooks. This guide focuses on individual worksheets (tabs). Choose a native Excel method for a small range, or prepare two matching-sheet XLSX copies for WorkbookDiff. This is a tab-level task, not a guide to comparing entire workbook versions.
In desktop Excel for Windows, open both workbooks and use View > View Side by Side. For tabs in the same workbook, use View > New Window, then arrange the windows and select a different tab in each. Synchronous Scrolling helps inspect aligned rows; it does not automatically identify differences. On Mac, use separate windows and Arrange All rather than assuming the Windows Side by Side controls are available. Menu names vary by Excel version.
For tabs named Old and New in the same workbook, define a workbook-scoped name OldData referring to =Old!$A$1:$D$100. Select New!A1:D100 with A1 as the active cell, then create a conditional-formatting rule using:
=A1<>INDEX(OldData,ROW(A1),COLUMN(A1))Choose a fill color. The named range avoids a direct cross-sheet reference in the rule. This exact example assumes both ranges start at A1; adjust offsets for other starting cells. It compares values, not formula text, and needs matching row order. Check error cells separately.
=IF(Old!A1=New!A1,"Same","Different")Enter this in A1 of a third sheet and fill across/down over the occupied range. It compares cell values, so two different formulas with the same result can say Same; text comparisons are case-insensitive, and blanks, zeros and errors can need extra handling. For different workbooks, build external references by selecting cells in the open files. These methods do not align reordered records.
There is no arbitrary left-tab/right-tab picker. The main tool takes two files and matches worksheet names. Prepare working copies when the source is two tabs:
Need all tabs, not just a selected pair? Read compare two Excel files for differences. For expressions, see compare Excel formulas; for moved records, consider the separate value-only reconcile-by-ID beta.
| Cell | Before | After |
|---|---|---|
| Budget!B2 | 100 on Old | 125 on New |
| Budget!B3 | 200 on Old | 200 on New |
The IF helper flags B2 as Different. Prepared Budget copies produce cell-value-changed at B2 in WorkbookDiff.
WorkbookDiff compares two unencrypted .xlsx workbooks, up to 20 MB each, by matching worksheet names and cell coordinates. It compares supported stored values, formula expressions, sheet presence/visibility, hidden rows/columns and used range. It does not recalculate formulas, compare formatting, charts, pivots or VBA, or align inserted/reordered rows.
Workbook content is processed locally in your browser; this is not a promise of zero network traffic. Comparing and exporting the full CSV are free, with no signup. The optional $19 one-time audit handoff report provides review notes and HTML / print export, not an independent audit.
Yes. Use separate Excel windows, conditional formatting or an IF helper formula. WorkbookDiff requires two XLSX files, so copy each tab to its own workbook and give the copied sheets matching names first.
Yes. Excel can display the files side by side. For WorkbookDiff, prepare two XLSX copies with matching sheet names and aligned coordinates; there is no arbitrary tab-pair selector.
The value rule shown here compares results, not formula expressions. Use FORMULATEXT for text comparisons or WorkbookDiff for stored formula-change categories across two saved XLSX files.
The examples compare matching positions. Sort working copies by the same stable key first, or use a key-based value reconciliation workflow. WorkbookDiff version comparison does not realign rows.
The native methods require a suitable Excel installation. WorkbookDiff comparison and full CSV export are free without signup; the optional $19 one-time handoff report is separate.
Not necessarily. Copying or renaming a tab can alter references or create external links. Check the prepared copies in Excel; compare original aligned workbook versions when preserving dependencies matters.
Choose the guide for your comparison task: Compare Excel files without uploading · Compare Excel formulas and detect formula replaced by value changes · Export an Excel difference report CSV · Compare two Excel files · Excel diff for XLSX workbooks · Compare Excel files on Mac. · Compare two Excel sheets · Beyond Compare alternative for Excel · Microsoft Spreadsheet Compare alternative
Choose by workflow, supported inputs, exports and licensing.