Solved

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

Posted on 2011-03-11
8
250 Views
Last Modified: 2012-05-11
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
Comment
Question by:sah18
  • 3
  • 3
  • 2
8 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 35110300
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
 
LVL 9

Expert Comment

by:McOz
ID: 35110911
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
 
LVL 9

Author Comment

by:sah18
ID: 35113284
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
 
LVL 22

Expert Comment

by:rspahitz
ID: 35113372
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 9

Author Comment

by:sah18
ID: 35113698
That is another text solution, rspahitz -- it produces nothing readable for non-text file (excel files, for example) differences.
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 35113755
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
 
LVL 9

Accepted Solution

by:
McOz earned 500 total points
ID: 35115830
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
 
LVL 9

Author Closing Comment

by:sah18
ID: 35117183
This looks perfect!  Thanks very much for your help.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

My experience with Windows 10 over a one year period and suggestions for smooth operation
Outlook Free & Paid Tools
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now