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 Formulas, Macros, 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.