Spreadsheet Compare (Office 2013)
Published: May 7, 2013
Get an overview of Spreadsheet Compare, one of the Spreadsheet Controls desktop applications.
Applies to: Office 365 ProPlus | Excel 2013 | Access 2013 | Office Professional 2013
In addition to the server applications—Microsoft Audit and Control Management Server 2013 and Microsoft Discovery and Risk Assessment Server 2013—Office includes several desktop applications that you can use to assess Excel workbooks and Access databases. One of these desktop applications is Spreadsheet Compare, which is available with Office Professional Plus 2013 or Office 365 for enterprises.
You can use Spreadsheet Compare to compare two workbooks (or two versions of the same workbook) and see differences between the workbooks. You can also identify potential issues, such as changes in formulas or calculations, or manually entered values. Spreadsheet Compare is installed automatically when you install Office Professional Plus 2013.
Opening and using Spreadsheet Compare
.NET Framework 4.0 must be installed before you can use Spreadsheet Compare.
To open and use Spreadsheet Compare
Depending on which version of Windows you are using, take one of the following steps:
If you are using Windows 7, choose Start, choose All Programs, choose Microsoft Office 2013, choose Office 2013 Tools, and then choose
Spreadsheet Compare 2013.
If you are using Windows 8, from the Home screen, start to type Spreadsheet Compare, and then choose the tile that says Spreadsheet Compare 2013.
Spreadsheet Compare opens.
On the Home tab, click Compare Files.
Select two workbooks to compare, and then click OK.
For more information about Spreadsheet Compare, see Basic tasks in Spreadsheet Compare 2013 (Office.com).