How to Compare Two Excel Spreadsheets

Even for the most organized book and record keepers, the sheer volume of information you store in Excel can soon become overwhelming. Microsoft Excel has two tools for comparing spreadsheet data, which can come in very handy if you're trying to find a cell typo or comparing documents to prepare for an audit. Both available only in Office Professional Plus 2013 and Office 365 Professional Plus, Spreadsheet Compare and Spreadsheet Inquire let you analyze workbooks or generate difference reports between two spreadsheets. The two can be huge time-savers over manual data comparisons.

Serious casual man writing on sheets paying bills
Spreadsheet Compare and Spreadsheet Inquire help you stay on top of your data.
credit: Wavebreakmedia Ltd/Wavebreak Media/Getty Images

Spreadsheet Compare

Step

Click on "Spreadsheet Compare" in the Start Screen of Windows 8. Type "Spreadsheet Compare" into the search field and select the file if you have trouble locating it on the screen.

Step

Click on the "Home" tab at the top and select Compare Files.

Step

Click on the blue folder icon next to the Compare field in the dialog box that appears. Browse through your saved Excel files and select the first spreadsheet you want to compare.

Step

Click on the green folder icon next to the To field on the next line. Browse through your Excel files to select the second spreadsheet you want to compare.

Step

Click on the "Ok" button.

Step

Choose the criteria you want to use in the comparison from the menu on the left. You can select criteria like "Cell Values," "Formulas" and "Cell Format," or just check the "Select All" box.

Step

Click on "Ok" to generate the difference report. Spreadsheet Compare creates a complete list of all differences between the two files based on the criteria you identified.

Spreadsheet Inquire

Step

Turn on the Inquire add-in if your haven't done so already. Click on the "File" tab in Excel and select "Options" and then "Add-Ins." Select COM Add-Ins from the Manage drop-down menu, click "Go" and make sure the box next to Inquire Add-Ins is selected.

Step

Click on the "Inquire" tab at the top of Excel to explore spreadsheet analysis and comparison options.

Step

Click on the "Compare Files" command to launch Spreadsheet Compare directly from Excel.

Step

Click on "Workbook Relationships" to generate a graphical report of references between your workbooks, such as formulae that reference a value contained in another spreadsheet. Use the Worksheet Relationships and Cell Relationships icons to do the same thing between worksheets in a workbook or cells in a worksheet.

Step

Click on the "Workbook Analysis" icon to generate a complete and interactive report on the open spreadsheet, including information about values, formatting, structure and formulae.