Compare (and merge?) excel files with Beyond Compare

Another note to myself.

My main app - Beyond Compare, a file diff-merge utility from Scooter Software(and a really good one at that) has some spiffy rules that let you 'do the diff' on versions of an excel document.
You can compare (and it seems now you have merge as well) excel as well as word files. I haven't really compared word docs yet but xls diffs work ... well!

All you gotta do is download the rules (as a zip).
  • Unzip it to your Beyond Compare install Directory.. MSExcel folder for the xls diff rule.
  • Run Beyond Compare.
  • Main Menu > Tools > Import Rules. Select the rule file under the MSExcel folder.
  • Select the two xls files in Windows Explorer, right click and choose Compare! voila!
There are a lot of other goodies available here

4 comments:

  1. Hi,

    Your input is very useful.
    But I could not find Rules to compare word files.
    Can you pls. share me these to my e-mail: vivek13sept@gmail.com

    Regards,
    Vivek

    ReplyDelete
  2. Hi Vivek,
    The rule is still available on the link on the last word of the post.
    Open it up in a browser and search for 'MS Word' you should find the rule
    scootersoftware.com/download.php?c=kb_morerules

    ReplyDelete
  3. Jack is my friend and he asked me about excel problems. I offered him to use a tool, which was found on a soft blog. It helped me some times and probably would one of the best resolutions for such problem as well as mine - microsoft excel restore old copy.

    ReplyDelete
  4. Change-Pro for Excel enables business users to compare two Excel documents for changes.
    With Change-Pro for Excel' s patent-pending technology, you can view changes made to Excel values and Excel formulas,along with comparing row and column changes in spreadsheets.

    compare excel files

    ReplyDelete