Spreadsheet Comparison

Compare two Excel files using the Microsoft Spreadsheet Comparison application.

On the Start screen, click Spreadsheet Compare.

Click Home > Compare Files.

Click the blue folder icon next to the Compare box to browse to the location of the earlier version of your workbook.

Click the green folder icon next to the To box to browse to the location of the workbook that you want to compare to the earlier version, and then click OK.

In the left pane, choose the options you want to see in the results of the workbook comparison by checking or unchecking the options, such as FormulasMacros, or Cell Format. Or, just Select All.

Click OK to run the comparison.

Differences are highlighted with a cell fill color or text font color, depending on the type of difference. For example, cells with “entered values” (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list. The lower-left pane is a legend that shows what the colors mean.

Note: If the files are .CSV files then open in Excel and save them as Excel Workbook (*.xlsx) files so they can be opened by the tool.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s