How to Open Excel Spreadsheet Compare in Microsoft 365 Enterprise
Question details
The user needs to locate and launch the Spreadsheet Compare utility to compare different Excel workbooks or worksheets.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- The user wants to compare two versions of an Excel file to find differences using the built-in Microsoft 365 Enterprise utility.
- Observed behavior
- The user is looking for the entry point or shortcut to open the Spreadsheet Compare application on their computer.
Ensure you are using a Windows PC with a supported Microsoft 365 Apps for enterprise installation (such as an Office 365 E3 or E5 license), as this specific tool is not available in Home or Personal editions.
Launch Spreadsheet Compare via the Windows Start Menu
The most direct way to open the Spreadsheet Compare tool is by using the built-in Windows search function.
Spreadsheet Compare is installed automatically as a standalone application alongside your Microsoft 365 Enterprise apps, rather than being an add-in directly accessible from inside the Excel ribbon.
Click the Start button in the bottom-left corner of your screen, or press the Windows key on your keyboard.
Type 'Spreadsheet Compare' into the Windows search bar.
Click on the 'Spreadsheet Compare' app from the search results to open the utility. From there, you can select the two workbooks you wish to compare.
Looking for an Easier Way to Manage Spreadsheets? Try WPS Office
If your current Microsoft 365 plan doesn't include the Spreadsheet Compare tool, or if you're looking for a more accessible and cost-effective office suite, WPS Office is a free, lightweight, and highly compatible alternative. It provides a comprehensive set of spreadsheet tools and a seamless user experience.
- 1. Download and Install WPS Office: Visit the official WPS Office website and download the free installation package for your device.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open the two Excel files you want to compare.
- 3. View Files Side by Side: Navigate to the View tab and click 'View Side by Side' to easily compare your data visually.
Frequently Asked Questions
Why can't I find Spreadsheet Compare on my computer?
Spreadsheet Compare is exclusively included with specific Microsoft 365 Enterprise plans (such as Office 365 E3 or E5) and Office Professional Plus. It is not included in Microsoft 365 Personal, Family, or standard Business plans.
Can I download Microsoft Spreadsheet Compare separately?
No, Microsoft does not offer Spreadsheet Compare as a standalone download. It must be installed as part of a compatible Microsoft 365 Enterprise or Office Professional Plus package.
How do I compare two Excel files if I don't have this tool?
You can manually compare two files by opening both workbooks in Excel, navigating to the View tab, and selecting 'View Side by Side'. You can also enable 'Synchronous Scrolling' to scroll through both files simultaneously.
What types of files can Spreadsheet Compare analyze?
Spreadsheet Compare can analyze current .xlsx and .xlsm (macro-enabled) workbooks, as well as older Excel formats like .xls. It can also identify changes in VBA code, formulas, and formatting.
