Two open spreadsheets, ten thousand rows, subtle variations in the data, a 9am deadline, and one gigantic headache.
If you have ever spent time comparing multiple spreadsheets of any level of complexity, you know that it quickly goes from gross tedium to a full-blown nightmare.
Workbook Compare makes quick work of this important but ultimately, unrewarding task. Offering full workbook or individual spreadsheet comparison options, variance allowance settings, and an easy to read breakdown of the differences in a spreadsheet format, Workbook Compare is integral part of any Excel users' bag of tricks.
Workbook Compare can compare worksheets with or without a table structure, compare worksheets or tables within the same workbook, compare worksheets that are sorted differently, and save comparison projects that can be applied to different workbooks in just a few clicks.
Wake up!
All that spreadsheet comparison was just a bad dream!
Review Written by Andrew Dick
Features
The Fine Print
Testimonials
- Compare worksheets even if they have different names.
- Create projects to make repeated comparisons a breeze.
- Highlight differences to make them easy to spot.
- Set unique keys to columns to treat worksheets like database tables.
- Use "Table Compare" for simple table comparisons.
- Assign a variance allowance to ignore tiny differences.
- Limit the number of differences per column.
- Optionally compare data above the header row.
- Optionally enforce case sensitivity when comparing text values.
- You can download and install a free trial of this software before purchasing
- Download available for: Windows NT, 2000, XP, Vista, Server
- Buy with BitsDuJour's promotional coupon code and get all this at a discounted price!
- Your discount coupon code will be applied to your purchase when you click the 'Buy Now' button.
- BitsDuJour downloads use a discount coupon code that comes direct from the software vendor, so you'll always get the latest version of the software app sold under the same terms as a regular sale, just at a great promotional price.
- Prices do not necessarily include taxes, which will vary by country.
- Review what others have to say...
- “I have been using HigherData's Workbook Compare and am very impressed with the depth of useful features and well thought out user interface. It is clear that the designers of this Excel Add-In knew what they were doing when they conceived of and built this powerful and useful tool. The most notable feature is the Difference Report which, after analyzing two worksheets, displays an impressive collection of information allowing me to not only pinpoint all of the discrepancies between the two worksheets, but to understand exactly why the discrepancies exist in the first place. The results can be filtered to focus on specific columns or other attributes common to groups or clusters of discrepancy information. If the report is too precise, a variance allowance can be adjusted to take into account normal noise that can appear in imported data. Workbook compare will even evaluate cell formulas and locate any that are not the same as the rest of the formulas in a column. One of the qualities I like most about Workbook Compare is that it does all of this without touching the original worksheets! But, if you want to highlight the original cells that are found to be different, Workbook Compare will oblige with the colors of your choice. Very nice! For power users, Workbook Compare provides the ability to save projects where a project is the collection of rules and settings I create to compare a specific pair of worksheets. While Workbook Compare does an amazing job of determining the best rules given two worksheets to compare, it allows me to edit those rules and settings using a clean and intuitive user interface. It's these tweaks that are saved as a project so that I can quickly recall them when I need to compare the same or similar worksheets in the future. Workbook Compare is, without doubt, the best worksheet comparison utility with which I have ever worked. This one is a keeper and well worth the price!”- Kevin Jones, Microsoft Excel MVP, Excel Consultant
- “We just finished a rollout of our new hedge fund reporting system and I don't know what we would have done without Workbook Compare. It saved us hours of work by helping us pinpoint where the differences were between the old and new Excel reports so we could verify that the numbers were still correct. We consider Workbook Compare to be a vital part of our QA process.”- Erik O., Oehm Automation
- “In my job, I am constantly upgrading large spreadsheet-based reports that my financial clients use to make billion-dollar decisions. The most important thing is to not break what already works! I use Workbook Compare constantly to check that there are no unexpected changes between the old and new versions. I use it on workbooks with more than 20 worksheets, each with thousands of rows, and it performs like a champ!”- A. Nielsen, San Francisco, CA
- “Workbook Compare saves me tremendous amounts of time reconciling large sets of financial data. The ability to control match sensitivity makes it incredibly easy for me to find large differences while ignoring the insignificant ones. I love the double-click feature that brings me right to the records in both sets of my source data. What used to take hours now takes minutes. Thank you!”- Aaron D. Nelson, finance consultant
- “Saved hours of tedium and my sanity...an excellent tool.”- Jan Mroz, Senior Project Manager, London
