• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

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?!
Thanks!
0
sah18
Asked:
sah18
  • 3
  • 3
  • 2
1 Solution
 
rspahitzCommented:
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.
0
 
McOzCommented:
Check out this program, 4TOPS. It compares excel sheets and outputs HTML. Free download from CNET:

http://download.cnet.com/4TOPS-Compare-Spreadsheets/3000-2077_4-10410585.html

Cheers
0
 
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.
0
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 
rspahitzCommented:
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.
0
 
sah18Author Commented:
That is another text solution, rspahitz -- it produces nothing readable for non-text file (excel files, for example) differences.
0
 
rspahitzCommented:
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.
0
 
McOzCommented:
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:

http://www.thefoolonthehill.net/drupal/Spreadsheet%20Compare/

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

Hope it helps!
0
 
sah18Author Commented:
This looks perfect!  Thanks very much for your help.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now