DiffEngineX for Windows

Name: DiffEngineX
Rating: 5 (12 reviews)
Author: DiffEngineX

Download now

Used DiffEngineX for Windows? Share your experience and help other users.

Key Details of DiffEngineX

Report the differences between two Microsoft Excel spreadsheets.
Last updated on February 24, 2019
Virus scan status:
Clean (it’s extremely likely that this software program is clean)

Editors’ Review

Download.com staffFebruary 24, 2019

So important is Microsoft Excel to the world's data that the smallest difference between datasets can have consequences that ripple outward like a stone thrown in a calm pond. DiffEngineX is a powerful tool that identifies the differences between two Excel workbooks or individual worksheets, even thousands at a time. But unlike standard difference analysis, it takes into account any new or blank rows, cells, and columns. It's not something you can just fire up and run, but the payoff for a little prep is accurate identification of actual differences in huge amounts of data in minutes or seconds. We tried the fully functional 30-day trial of DiffEngineX with Excel 2010.

DiffEngineX's user interface is all business, with identical entry fields and worksheet displays for Workbook #1 and Workbook #2 and controls to select whether to compare whole workbooks or selected sheets, align rows and columns, and color differences at the cell level and highlight character-level differences (the last two are selected by default). Clicking Options brought up a detailed sheet of options covering Reports, Formulae, Cell and Numeric Value Comparisons, and other areas. An Extras button let us choose colors and hide rows in various ways, among other preferences. The Help file includes a tutorial that we'd highly recommend following.

Our quick-and-easy test consisted of comparing a finished workbook with its unfilled template. We simply browsed to each and pressed Start Comparison. The job finished quickly and included a summary report detailing the differences. The sheets themselves opened, both color-coded and highlighted for the quickest possible identification of differences. While all that sounds simple, DiffEngineX isn't totally automatic: even Excel experts will need to spend some time making sure everything's ready. But it will be time well spent when DiffEngineX does in minutes what might have taken many hours manually.

What’s new in version 3.15

Version 3.15:

Fixes Excel exceptions being thrown when latest Microsoft Office updates are installed. This is a vital update.

DiffEngineX for Windows

Download now

Used DiffEngineX for Windows? Share your experience and help other users.

Explore More

Full Specifications

GENERAL

Release: February 24, 2019

Latest update: February 24, 2019

Version: 3.15

OPERATING SYSTEMS

Platform: Windows

Operating System

Windows 8
Windows 7
Windows 10

Additional Requirements: Microsoft Excel

POPULARITY

Total Downloads: 15,453

Downloads Last Week: 1

Report Software

Program available in other languages

Descargar DiffEngineX

Last Updated

User Reviews

5/5

12 User Votes

Excel VBA code comparisons with DiffEngineX
Francis2014May 5, 2014
Pros
I ran the trial version and it found the differences I had not seen by hand. It only took a couple minutes to compare two 4MB files (67 sheets each, 9 macros)! DiffEngineX is certainly a smooth, well-designed product that does its work very thoroughly . The tutorials got me going in just a few minutes and I then found the program very easy to use. The peace of mind I got by knowing exactly where the differences were and that there weren't any more makes buying the program a no-brainer. Yes, I bought it already.
Cons
None whatsoever.
Summary
Thanks for a superb piece of software that really met my needs!
Outstanding experience so far
jurgfellaOctober 31, 2013
Pros
This program really works. In my experience it compares large spreadsheets in a short period of time, and can even do letter-by-letter comparison. (I use it primarily for legislative documents like budget acts, etc.)
Cons
None that I've noticed so far.
Summary
Creates three different spreadsheets that summarize and show off the differences between documents being compared. In my experience so far, the performance has been rock solid.
Huge time saver
ndburgessAugust 23, 2011
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...
Extremely useful program
stolireefMarch 3, 2011
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.
Every Excel user needs this. Fast and accurate.
Tilda_2009February 18, 2010
Pros
Does the job well and fast. Lots of options. If your office needs to track the changes made to Excel spreadsheets this is the tool for you. I've looked around and it seems to be the only one that compares named ranges and at the character level.
Cons
It is less good at comparing database data. The data has to be sorted first. But if you do this one extra step, it will work well and is much faster than a lot of other Excel compare utilities.
Summary
It runs through big worksheets like a knife through butter. It works and works well. Much faster than a lot of other Excel compare tools around.
Brilliant software. Every Excel user needs this!
Tilda_2009February 7, 2010
Pros
Does the job well and fast. Lots of options. If your office needs to track the changes made to Excel spreadsheets this is the tool for you. I've looked around and it seems to be the only one that compares named ranges and at the character level.
Cons
It is less good at comparing database data. The data has to be sorted first. But if you do this one extra step, it will work well and is much faster than a lot of other Excel compare utilities.
Summary
It runs through big worksheets like a knife through butter. It works and works well.
Brilliant software. Every Excel user needs this!
Tilda_2009October 8, 2009
Pros
Does the job well and fast. Lots of options. If your office needs to track the changes made to Excel spreadsheets this is the tool for you. I've looked around and it seems to be the only one that compares named ranges and at the character level.
Cons
It is less good at comparing database data. The data has to be sorted first. But if you do this one extra step, it will work well and is much faster than a lot of other Excel compare utilities.
Summary
It runs through big worksheets like a hot knife through butter. It works and works well.
Brilliant software. Every Excel user needs this!
Tilda_2009October 6, 2009
Pros
Does the job well and fast. Lots of options. If your office needs to track the changes made to Excel spreadsheets this is the tool for you. I've looked around and it seems to be the only one that compares named ranges and at the character level.
Cons
It is less good at comparing database data. The data has to be sorted first. But if you do this one extra step, it will work well and is much faster than a lot of other Excel compare utilities.
Summary
It runs through big worksheets like a knife through butter. It works and works well.
brilliant for big lists
jimmbolJuly 21, 2006
Pros
it works, and works well <p>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
Summary
Great tool if you work with Excel
robert_yaugerAugust 12, 2005
Pros
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. <p> <p>Sometimes we need to compare a dozen large workbooks and that is where its command line args feature comes in handy.
Cons
Summary

Developer’s Description

By DiffEngineX

Report the differences between two Microsoft Excel spreadsheets.

DiffEngineX is a utility that reports on the differences between the formulae, constants, defined names, cell comments and Visual Basic (VBA) macros contained in either two whole Excel workbooks or selected worksheets.

As Excel workbooks get modified over time new rows and columns can be inserted in between existing rows and columns. This can confuse a straightforward difference analysis where identical cells are only recognized as such if they have the same row and column numbers in both of the sheets being compared. DiffEngineX can align both similar rows and columns between the worksheets being compared by the insertion of blank rows and columns. As such this problem is avoided. Conventional reports listing each cell difference are difficult to understand given the lack of context. This is why there is an option to automatically create copies of the workbooks being compared and then modify them such that the differences are highlighted in color. The options available allow users a choice between comparing formulae directly or by their calculated values. For example if two cells containing =2*6 and =3*4 are compared directly they will reported as different. If they are compared by their calculated values they will be reported as identical.

It is common in workbooks modeling certain financial scenarios to have blocks of tens to hundreds of equivalent formulae that only differ from their neighbors in terms of their inputs. The absolute coordinates of these inputs change from one cell to the next, but the relative coordinates do not. If a later version of such a workbook is compared to an earlier one, hundreds of changes can potentially be reported. This makes a difference report tedious to inspect. DiffEngineX has a powerful feature to group equivalent changes made to contiguous cells into just one reported change made to a range of cells. It can be used from its user interface or the command prompt.

DiffEngineX for Windows

Key Details of DiffEngineX

Editors’ Review

What’s new in version 3.15

DiffEngineX for Windows

Explore More

Secret Notes

SSuite QT Calc Express

Power XL

Excel TextBox Find/Replace Tool

Excel Sheet Comparer

Fill Blank Cells for Microsoft Excel

Vbmotif Excel Add-In

Employee Work Schedule

PPTX Repair Kit

PowerPoint Repair Kit

PowerPoint Password

Quattro Pro Password

Full Specifications

Program available in other languages

Last Updated

R.E.P.O.

Microsoft Excel 2016

Malwarebytes Anti-Malware

Rockstar Games Launcher

WWE 2K25

HP DeskJet Ink Advantage 2135 All-in-One Printer drivers

Telegram Desktop

Mendeley Desktop

Poppy Playtime

inZOI

ENA: Dream BBQ

The First Berserker: Khazan

User Reviews

Excel VBA code comparisons with DiffEngineX

Outstanding experience so far

Huge time saver

Extremely useful program

Every Excel user needs this. Fast and accurate.

Brilliant software. Every Excel user needs this!

Brilliant software. Every Excel user needs this!

Brilliant software. Every Excel user needs this!

brilliant for big lists

Great tool if you work with Excel

Developer’s Description

zproxy.org