Spreadsheet Compare (Office 2013)


Applies to: Access 2013, Excel 2013, Office 365 ProPlus, Office Professional Plus 2013

Topic Last Modified: 2015-01-16

Get an overview of Spreadsheet Compare, one of the Spreadsheet Controls desktop applications.

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.

.NET Framework 4.0 must be installed before you can use Spreadsheet Compare.
To open and use Spreadsheet Compare
  1. 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.

  2. On the Home tab, click Compare Files.

  3. Select two workbooks to compare, and then click OK.

For more information about Spreadsheet Compare, see Overview of Spreadsheet Compare.