• Around The HomeToggle Menu

    • Entertainment
    • Productivity
    • Smart Home
  • FamilyToggle Menu

    • Parenting
    • Toys
    • Pets
    • Travel
  • ReviewsToggle Menu

    • Phones
    • Tablets
    • Laptops
    • Desktops
    • Wearables
    • Audio
    • Cameras
    • Headphones
    • Printers
    • Smart Home
    • TVs
    • Gaming and Video
  • One Cool ThingToggle Menu

    • Frugal Tech
    • Kickstarters
    • Videos
  1. Home
  2. Around The Home
  3. Productivity
  4. How to Compare Two Excel Spreadsheets

How to Compare Two Excel Spreadsheets

By: Edward Mercer
  • Share
  • Share on Facebook

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.

Video of the Day

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.

Show Comments

Related Articles

How to Switch to Manual Calculation in Excel

How to Switch to Manual Calculation in Excel

Around The Home
Productivity
By: Jenny Hansen
Advantages & Disadvantages of Microsoft Excel

Advantages & Disadvantages of Microsoft Excel

Around The Home
Productivity
By: James Lemoine
How to Graph a CSV File in Excel

How to Graph a CSV File in Excel

Around The Home
Productivity
By: Kiva Bottero
How to Send Excel Files Between a PC & a Mac

How to Send Excel Files Between a PC & a Mac

Around The Home
Productivity
By: Hollan Johnson
How to Have Excel Solver Give Only Whole Numbers

How to Have Excel Solver Give Only Whole Numbers

Around The Home
Productivity
By: Brian Richards
How to Import OFX Files Into Microsoft Excel

How to Import OFX Files Into Microsoft Excel

Around The Home
Productivity
By: Jason Spidle
  • HOW WE SCORE
  • ABOUT US
  • CONTACT US
  • TERMS
  • PRIVACY POLICY
  • COPYRIGHT POLICY
  • Advertise

An error occurred. Try again later.

Thanks for signing up!
© 2019 Leaf Group Ltd. Leaf Group Media

Get great tech advice delivered to your inbox.

Keep your family productive, connected, entertained, and safe.

Please enter a valid email.