Looking for free utility/add-on/software tool to compare 2 excel files for differences

I'm looking for free utility/add-on/software tool to compare 2 excel files for differences.
Ideally this would work with any version of Excel, but I absolutely need it to work with Excel 2007 files.

Oh... and did I mention... it must be free?!
Who is Participating?
McOzConnect With a Mentor Commented:
Sorry, did not catch that my other link was just a free trial!
Another option which IS free, but does not have quite the same functionality as 4TOPS (it just highlights differences instead of spitting out a report), is here:


This is a VBA add-in for excel, works for excell 2000 and later.

Hope it helps!
We could probably write one here for you, but since a generic compare tool would take a long time to write/test, it would help if you scale down the task.

For example, if you're looking for two workbooks to be identical in every way, you can use any windows tool to compare them.  Beyond that, what are you expecting to find in your differences?

If all the book names are the same, is that enough?  if all the cell values are the same, is that a match? what if all the formulas are the same but the sheet names are different?  how about if some cells have colors or borders or attached notes but the values and formulas are the same?

So to generate a report of all differences could be a massive task, especially for free.
If you're just looking to see if the sheets have different values (ignoring formulas), one simple way is to export the data as a CSV and then compare them in any of the many free compare tools available.
Check out this program, 4TOPS. It compares excel sheets and outputs HTML. Free download from CNET:


Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

sah18Author Commented:
McOz - Still hoping to find a free option for this (4TOPS has a free trial, but is $69).

rspahitz - and yes, I really do need what I asked for -- something to compare excel files, not merely cell values.  I already have Notepad++ which has a very nice text compare addin, but that won't help me in this case.
open a DOS window (enter cmd in the start menu's Run/search box)
Then enter FC followed by the path to the two files:

fc "C:\My documents\File1.xls" "C:\My Documents\File2.xls"

If they are they same, you will see no differences.
sah18Author Commented:
That is another text solution, rspahitz -- it produces nothing readable for non-text file (excel files, for example) differences.
that's why I asked you what differences you are expecting.  If you only want to know if there are differences, FC handles it.  Otherwise you need to define what differences you want.  Among the chocies are:

Application-level differences (Excel settings)
Workbook-level differences (name of file, number of sheets, comments added to workbook)
Worksheet-level differences (name on tab, location of last cell, location of cursor, sequence within the book, protection, password)
Column.Row-level differences (width, height)
Cell-level differences (value, formula, notes, conditional format, colors, borders, "number" format, word wrap, indents, locked, etc etc.)

If everything is the same except for the location of the cursor on a single page, do you want it reported as a difference?

All of those are defined as differences by Excel.  This is an overwhelming task to ask of a free tool.  That's why I said you need to refine your request down to what differences you are seeking.
sah18Author Commented:
This looks perfect!  Thanks very much for your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.