Spreadsheet Compare Tool Microsoft 365

Question

I want to compare two spreadsheets, where can I find Spreadsheet Compare Tool?

Answer 1

Hello @Alessandro Dorgnach,

Thank you for reaching out Microsoft Q&A Forum!

Firstly, please note that the Spreadsheet Compare tool is included with certain editions of Microsoft 365 Apps for enterprise and Office Professional Plus (2013, 2016, 2019). It is not available in Excel for the web or consumer versions.

To Find Spreadsheet Compare:

• On Windows, open the Start menu and type Spreadsheet Compare.
• If you do not see it, please confirm that you have the correct edition installed (Microsoft 365 Apps for enterprise or Office Professional Plus).

More detail for you, Spreadsheet Compare does:

• Compares two Excel workbooks side by side.
• Highlights differences in:
  • Values
  • Formulas
  • Cell formatting
  • Macros
• Displays results in a grid and allows exporting the report to Excel.

For more details, please refer to the official Microsoft documentation:

Overview of Spreadsheet Compare

Compare two versions of a workbook by using Spreadsheet Compare

Best Regards.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 

Answer 2

The Spreadsheet Compare Tool is not explicitly mentioned in the provided context. However, you can typically find it as part of the Microsoft Office suite, especially in the tools available for Excel. If you are using Microsoft 365, you may also access it through the Office apps or by searching for it in your Windows start menu.

If you need to compare data across two Excel files, you might also consider using Office Scripts with Power Automate, which allows you to analyze data and find discrepancies between workbooks.

---

References:

• Cross-reference Excel files with Power Automate