DiffEngineX is a utility that finds the differences between the formulae, constants, defined names and cell comments contained in either two whole Excel workbooks or selected worksheets. It generates a cell-by-cell difference report in a new workbook and color highlights different cells in automatically-created copies of your workbooks.
As Excel spreadsheets get modified over time new rows and columns can be inserted between existing ones. DiffEngineX can align both similar rows and columns in the sheets being compared.
How's this for a cool new feature? DiffEngineX now compares the Visual Basic for Applications (VBA) macros and code embedded in Excel workbooks!
DiffEngineX includes many powerful features, like the ability to hide matching rows, group like changes to adjacent cells, and highlight differences at the character level. It can be used from its user interface or via command-line arguments.
Features
The Fine Print
Testimonials
- DiffEngineX now compares the Visual Basic for Applications (VBA) macros and code embedded in Excel workbooks!
- Compare formula, constants, defined names and cell comments between workbooks or selected sheets.
- Align rows and/or columns with similar content between sheets (minimizes spurious differences).
- Compare numeric values to a user-specified number of decimal places. Useful for ignoring small fractional differences.
- View a detailed difference report that gets automatically created in a new workbook.
- Color-highlight differences at the whole cell level (separate colors for additions, deletions & modifications).
- Hide matching rows enabling convenient discovery of widely separated differences.
- Hide different rows, enabling only the identical ones to be revealed.
- Compare formulae or their calculated values.
- Can be run using command-line arguments in addition to its user interface.
- Fast: Two 4Mb Excel workbooks can be compared in 30 seconds. Two 20Mb workbooks can be row aligned and compared in under 4 minutes.
- Precisely highlight the parts of formulae and text constants that differ on the report e.g. =A1+Costs+6 and =A1+NewCosts+4.
- Compare Excel defined names and cell comments along with formulae & constants.
- You can download and install a free trial of this software before purchasing
- Download available for: Windows 7, 8 and 10 (32 and 64 bit), Microsoft Excel or Office (2003 or later) is a prerequisite
- Buy with BitsDuJour's promotional coupon code and get all this at a discounted price!
- After you purchase DiffEngineX it may be used indefinitely.
- DiffEngineX is licensed per user, so if more people are going to use DiffEngineX you will need to purchase additional copies.
- Each license allows installation on a single computer and a laptop.
- Transfer of a license to another owned computer is allowed.
- Online license activation is required. what's this?
- Review the Full License details for downloading and installing this software.
- Prices do not necessarily include taxes, which will vary by country.
- Review what others have to say...
- “OMG .... You are a GOD! This took me 1 minute and it's done exactly what I wanted. By the way, there were over 1000 discrepencies... $70 is CHEAP for the amount of time this saved.”- Roann
- “I've tried out a few Excel compare utilities and DiffEngineX is by far the fastest one. It has a lot of nice features available on its Options box. It generates reports in Excel workbooks which can be compared right next to the originals. This is much more useful than a report that can only be opened in a non-Excel application. At work we have lots of big, complex spreadsheets and DiffEngineX can compare them without any trouble.”- tilda_seattle
- “I work with Excel daily and this tool makes my life much easier. It has lots of nice touches such as removing existing workbook color before adding its color. Sometimes we need to compare a dozen large workbooks and that is where its command line args feature comes in handy.”- robert_y
- “Pros: it works, and works well.
Using the align row feature, you can compare big lists that might have some small differences like a row added or deleted here or there, as well as cell differences.
Cons: i downloaded 8 other excel comparison software programs before i tried this one! d'oh.”- jimmbol
- “Pros: Very powerful program. Huge time saver. Overall, I'd say it is absolutely worth the money... I will be buying it after the trial period.Cons: None really... it takes a bit of playing around to get a good feel for how it works... but it's worth it... so it's not really a con.Summary: I needed to compare two spreadsheets (about 1500 rows and 20 columns each). I downloaded several excel compare programs and got nowhere... decided to do it manually.It took me an hour to find what I was looking for using vlookups and if/then statements. I knew there had to be a better way.It looked like this program had some decent reviews so I tried it out. It took me about an hour to figure out how to get it to kick out what I was looking for... but now I could do it in 5 minutes. This program absolutely ROCKS. I will buy it after the trial period. If you need to compare big spreadsheets - this is an excellent choice. Highly recommended!!! This is a very powerful program. I've downloaded hundreds of programs in the last decade and this is the first time I've felt compelled to write a review. One last thing... something that is not immediately obvious - you can insert data filters on the results spreadsheet by highlighting the blank row between the data and the headers... you can also hyperlink all the results so if something looks interesting, you can just click on it...”- ndburgess
- “Pros: Program allows you to rapidly compare large volumes of data in two spreadsheets. We have found dozens of uses for the program.Cons: Learning curve is a bit steep if you are not reasonably comfortable with Excel. Color coding is difficult to understand.Summary: One of the most useful programs I have ever used. Does one thing and does it very well. I have used this program on a daily basis to compare enormous spreadsheets containing hundreds of thousands of lines and nothing makes it easier to identify duplicates and/or unique lines. You will find uses you never dreamed of.”- stolireef
- “Even better than sliced bread. This tool went through spreadsheets that we revisions apart and gave me everything I needed to know in seconds.Would have taken me at least three hours to do what the tool did and I probably would have missed some.I've sent a message about this tool to all of the colleagues in my company with high recommendations.”- mike_mcgarry
- “Google search for Excel diff - yours looked like the best product...key was the free (painless!) 30 day trial that allowed me to try the software out.Good approach!”- Mike
