| Developer | Office Assistance LLC |
| Website | www.office-excel.com |
| First Release | 2006 |
| Latest Version | 1.1.9 |
| Single License | USD 59.00 |
Strongest Points…
- Simple and fast process to get to the comparison results.
- Excel Add-In supports a seamless work process.
- Shows differences in a convenient and easy to understand way.
- Good for quick and basic comparison tasks.
Weakest Points…
- No filter and option settings to improve match accuracy.
- Differences cannot be automatically updated.
- It is, in our opinion, just too basic to serve as professional tool.
- Can only handle single worksheets of a workbook and not entire workbooks at once.
Working
with this Solution…
The below rating is based on our evaluation sheet that gives points for more than 40 different questions. From look and feel, convenience to functionalities… We think we have it all pretty much covered and summarized.
Getting started…
Evaluates how easy it is to get started with the solution and to do the basic setting to compare workbooks, spreadsheets and databases.
Summary: Clean and simple process but very basic in terms of settings, options and filters.
| Rating | 2.3 / 5 |
User Experience…
Measures the user experience and the convenience to work with the solution as well as how easy help can be accessed and how helpful the help topics are.
Summary: Good user experience, given that there is no need for detailed settings. Clean, clear and simple process.
| Rating | 2.8 / 5 |
Speed and Capacity…
Measures how fast the solution works with small, medium and large files as well as the capacity to identify multiple tasks, such as inserted columns, databases, etc.
Summary: For smaller worksheets, the speed of the solution is quite good. However, for larger worksheets it might take quite a bit of time.
| Rating | 3 / 5 |
Features, Options and Customization…
Evaluates filter options, customization features, identified difference types and the capability to handle databases.
Summary: Very little features, options and customization possible. Only the very basics can be done.
| Rating | 1.8 / 5 |
Result Display…
Measures how well the results are displayed as well as how easy it is to understand them and to navigate through these results.
Summary: Good side by side display of results. Does not say what the actual difference is and simply shows that there is a difference in cell.
| Rating | 2.4 / 5 |
Use and apply Results…
Measures how the results can be updated/edited and if the solution supports automatic updating of individual differences and entire groups of differences.
Summary: Comparison results cannot directly be applied. No updating of individual differences or difference types.
| Rating | 1 / 5 |
Solution Features
and Options…
This breakdown of capabilities shows you at a glance, where each of the solutions delivers and hopefully helps to see, which solutions will meet your needs best.
| What general Features does the Solution have? | |
| Compares Spreadsheets | |
| Supports and compares Databases | |
| Allows a 1-to-1 Comparison | |
| Command Line Options | |
| VBA | |
| Compares very large Files | |
| Multiple Filter Options | |
| Option setting per worksheet |
| What makes working convenient? | |
| Directly embedded as Add-In in Excel | |
| Parallel scrolling within two worksheets | |
| Highlight and un-highlight Differences | |
| Multiple Filter Options | |
| Use of multiple Comparison Options | |
| Save repeating Tasks as Projects | |
| Creation of Comparison Templates | |
| Show and hide Difference Types | |
| Command Line Options | |
| VBA | |
| Creation of Difference Reports | |
| Creation of hyperlinked Difference Reports | |
| Seamless Workflow with one Interface | |
| Selection of Ranges to be compared | |
| Setting of Value Tolerance for Comparison | |
| Compares multiple Spreadsheets in once | |
| Comprehensive User Manual | |
| Settings/Options for each Worksheet | |
| Automatic updating of differences |
| What can be customized? | |
| Color Coding for Difference Types | |
| Interface Layout | |
| Comparison Templates | |
| Filters and Options | |
| Repeating Projects | |
| Comparison Tolerance |
| Which Differences can be found? | |
| Entered Values | |
| Calculated Values | |
| Formulas | |
| Added and deleted Rows | |
| Added and deleted Columns | |
| Added and deleted Spreadsheets | |
| Spreadsheet Names | |
| Redundant Records | |
| Excel Names | |
| Cell Color Backgrounds | |
| Data Connections | |
| VBA Codes | |
| Number Formats | |
| Cell Alignments | |
| Font Names | |
| Font Styles | |
| Font Sizes | |
| Font Colors | |
| Font Underlines | |
| Font Strikes | |
| Font Super- and Subscripts | |
| Cell Borders | |
| Cell Interiors | |
| Cell Protections | |
| Cell Comments | |
| Font In-String Differences |
| Which Differences can be automatically updated? | |
| Updating of single Differences | |
| Updating of entire Difference Groups | |
| Entered Values | |
| Calculated Values | |
| Formulas | |
| Added and deleted Rows | |
| Added and deleted Columns | |
| Redundant Records | |
| Excel Names | |
| Cell Color Backgrounds | |
| Number Formats | |
| Cell Alignments | |
| Font Names | |
| Font Styles | |
| Font Sizes | |
| Font Colors | |
| Font Underlines | |
| Font Strikes | |
| Font Super- and Subscripts | |
| Cell Borders | |
| Cell Interiors | |
| Cell Comments | |
| Font In-String Differences |
The solution at a glance…
| A | Excel Add-In that allows to compare single worksheets of a workbook and allows to select ranges of a worksheet to be compared. |
| B | The solution is easy to use and to get quick results for smaller files. Large worksheets take a bit of time to be compared. |
| C | Side by side display of differences with parallel scrolling for a convenient result viewing. |
| D | The solution is good for basic needs and shows, that there are differences in certain cells. |
| E | No difference report or summary is provided. |
| Our Overall |
| Rating |  |
Solution
Ranking…
| 1. | Synkronizer |
| 2. | xlCompare |
| 3. | Microsoft |
| 4. | Sourceforge |
| 5. | DiffEngineX |
| 6. | Compare Spreadsheets |
| 7. | Formula Soft |
| 8. | 4TOPS |
Look & Feel – Screenshots
Initial interface to select the workbooks to be compared.
Selection of worksheet to be compared. The solution allows only the comparison of single worksheets within one run.
Interface to specify aligning options. It would come in handy, if an example per row is shown.
Further definition of match options. It is either formulas or values.
A basic customization of color coding is possible.
Result interface once the comparison task is completed. Parallel scrolling is possible. The solution does not enable automatic updating and ends a task by showing cells with differences.
