Important: Spreadsheet Compare is only available with Office Professional Plus 2013, Office Professional Plus 2016, Office Professional Plus 2019, or Microsoft 365 Apps for enterprise.

Use Spreadsheet Compare to compare two workbooks to see the differences between them, line by line. You can see how values, formulas, and formatting differ – line by line, and cell by cell.

Spreadsheet Compare can detect and highlight just the type of differences you specify.

Read the following articles for more information and step-by-step procedures.

Compare two versions of a workbook

See detailed changes between workbooks

Manage passwords used to open files for analysis and comparison

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!