Compare Excel Files

Florencesoft DiffEngineX is a software tool that finds the differences between the constants and formulae contained in either two whole Excel workbooks or selected worksheets.

DiffEngineX has many powerful options available on its Color and Options dialogs.

It generates a cell-by-cell difference report in a new workbook and color highlights different cells in automatically made 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. It has many powerful features such as the ability to hide matching rows, group like changes to adjacent cells and highlight differences at the character level.

Click here to find out more.

• Compare constants & formulae between workbooks or selected worksheets.
• Alignment of columns and/or row with similar content between sheets.
• Powerful option to highlight precisely the parts of formulae and text constants that differ on the report e.g. =A1+Costs+6 and =A1+NewCosts+4.
• Color highlighting of differences, at the whole cell level, made to copies of your workbooks (separate colors for additions, deletions & modifications).
• Optional removal of existing worksheet color before highlighting added.
• Can optionally hide matching rows enabling convenient discovery of widely separated differences.
• Choice of comparing formulae or their calculated values.
• Report can group like changes if they are made to adjacent cells (report lists 1 change to a range of cells).
• Can be run using command-line arguments or from its user interface.
• Difference report created in a new workbook.