Compare Spreadsheets for Excel - Best Solution
DeveloperOffice Assistance LLC
Websitewww.office-excel.com
First Release2006
Latest Version1.1.9
Single LicenseUSD 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.

Rating2.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.

Rating2.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.

Rating3 / 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.

Rating1.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.

Rating2.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.

Rating1 / 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…

AExcel Add-In that allows to compare single worksheets of a workbook and allows to select ranges of a worksheet to be compared.
BThe solution is easy to use and to get quick results for smaller files. Large worksheets take a bit of time to be compared.
CSide by side display of differences with parallel scrolling for a convenient result viewing.
DThe solution is good for basic needs and shows, that there are differences in certain cells.
ENo difference report or summary is provided.
Our Overall2.1 / 5
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.

Compare Spreadsheets for Excel Tool

Selection of worksheet to be compared. The solution allows only the comparison of single worksheets within one run.

Compare & Merge Excel Files - Compare Spreadsheets for Excel

Interface to specify aligning options. It would come in handy, if an example per row is shown.

Excel File Compare Tool - Compare Spreadsheets for Excel

Further definition of match options. It is either formulas or values.

Excel Comparison Tool - Compare Spreadsheets for Excel

A basic customization of color coding is possible.

Excel Compare Tool - Compare Spreadsheets for Excel

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.

Compare Spreadsheets for Excel - Compare Excel Files