Using the Microsoft Spreadsheet Compare Tool to Find Differences in Spreadsheets

If you have a couple of Excel spreadsheets that you need to compare to find the differences in regard to things like cell values, formulas, formatting and so on, you can use the Microsoft Spreadsheet Compare app to find them. This app comes included with Microsoft Office and is usually found under your Microsoft Office Tools group.

Once you open the app, all you need to do is click on Compare files and open the two spreadsheets you wish to compare. Then you can check the boxes next to the category types you wish to compare, and you can even export your results to a spreadsheet to review later.

Spreadsheet Compare is only available with Office Professional Plus 2013, Office Professional Plus 2016, Office Professional Plus 2019, or Microsoft 365 Apps for enterprise so if you can't find it, this might be why.

Check out our book (Computers Made Easy) that is designed to take your computer skills to the next level!

#excel
#exceltutorial

[bl]

Hey thanks! This sped up my work massively!

[matthewsimons]

This is incredible! I can't believe I'm just now finding out about this.

[hyonja]

Love your videos! Thank you for sharing.

[anjelicagrace]

This is exactly what I needed, thank you!

[ChrisAlbertH]

I was hoping for being able to transfer values between two different documents. For example, after I've compared the two files, is it possible to transfer the values I want from one file to the other?

[jx]

The spreadsheet compare tool compares the wrong value. For example, it will compare A1 in the first sheet to B2 in the second sheet. Do you know why and how to fix it? Thanks.

[samruddhipatil]

Have you conducted performance tests on this tool? I want to know what size/amount of data can it compare, and how much time will it take to do so? Can anyone help, please? I need this information for a project...

[dhanashreejadhav]

Can anyone share the link for downloading this software, or the correct steps to install it.