DiffEngineX Screenshots - Compare Excel Workbooks

DiffEngineX Screenshots

DiffEngineX finds the differences between Excel spreadsheets quickly. The screenshots below show its user-interface, the difference report and the color highlighted copies of the workbooks being compared. DiffEngineX can highlight cell differences at the character level. Row alignment allows worksheets to be compared even if they have had new rows inserted and existing rows deleted.

Click on each image for the full-scale version.

Compare individual Excel sheets or whole workbooks xls xlsx.Difference report generated in new Excel workbook.See Excel formulae differences highlighted at the character level.

Choose the colors used to highlight Excel cell differences. Hide matching rows or different rows. Powerful comparison options. Ignore small numeric differences. Compare either formulas or calculated values. Compare Excel defined names and comments. Align rows between 2 Excel workbooks.

Column alignment between two different Excel spreadsheets.Visual Basic for Applications VBA Code Macro Comparison.

English French German Italian Portuguese Russian Spanish

tip Viewing Excel Difference Reports Compare side by side

Click here for a tip on how to make viewing the results much easier.

tip #2Use Excel filter to just see new or deleted rows

In order to just see the new (green) or deleted (red) rows in both color highlighted worksheets, you can make use of Excel's built-in Filter capability. Just create a filter and then select a column to filter on Cell Color.

tip #3Use Excel's data tab to pre-sort rows before row alignment

If comparing rows of data, you may need Excel's Data tab to pre-sort. Then re-save before invoking DiffEngineX.

tip #4

If your region, language, location, date, time or number format settings have been altered or do not match the language version of Excel, you may need to turn on the DiffEngineX Internationalization option to stop errors.

tip #5Difference report hyperlinked to compared Excel spreadsheets

If you turn on Add Hyperlinks to aid navigation, the links work best if the workbooks being compared are initially closed (only applies to Excel 2003). For more details click here.