Synkrnozer Logo - Top Excel Compare Solution
DeveloperXL Consulting GmbH
Websitewww.synkronizer.com
First Release2000
Latest Version11.2
Single LicenseUSD 109
Strongest Points…
  • Identifies nearly any difference including inserted columns and rows
  • Automatic updating of all differences on a case by case bases or for entire types of differences
  • Comprehensive setting and filter options to improve accuracy
  • Handles large spreadsheets and databases
  • Easy to understand display of comparison results and updating options
Weakest Points…
  • Does not compare VBA-Codes

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: Very convenient to get started and to work with. Very good in handling workbooks and databases with detailed setting options.

Rating4.7 / 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: Allows to view and updated differences within a single, easy to understand interface. Hyperlinks and explanation text make it a very good user experience.

Rating4.7 / 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: Delivers instant results regardless file size, setting options and number of spreadsheets.

Rating4.8 / 5

Features, Options and Customization…
Evaluates filter options, customization features, identified difference types and the capability to handle databases.

Summary: Large range of setting and filter options. Identifies nearly all differences correctly.

Rating4.9 / 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: Clear overview of all differences and difference types including inserted columns and rows.

Rating5 / 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: Automatic updating of single differences or entire difference types with a single click.

Rating4.9 / 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…

AA very powerful, professional solution that brings the comparison of Excel worksheets and databases to a whole new level and which is currently one of the most sophisticated solutions in the market.
BThanks to its wide range of setting and filter options, matching accuracy is at a very high level, regardless if multiple worksheets, databases or very large files are compared.
CBesides identifying differences correctly, the core strength of Synkronizer is its automatic, interactive updating feature, which makes this Excel compare solution best in class.
DWith 11 released versions to date, it clearly shows the commitment of the company to its solution and the will to go the extra mile to constantly improve it.
EFor repeating tasks, Synkronizer has the feature to save projects and templates.
Our Overall4.8 / 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

Basic interface to get the comparison task started. A great feature, in our opinion, is that Synkronizer can be started at any point regardless which files are currently displayed.

Synkronizer - Top Excel Compare Tool

The basic settings allow to save comparison tasks as projects or even to create templates. Color coding for difference types can be fully customized.

Excel Compare Tool - Synkronizer

In our opinion, Synkronizer has a great workflow to work with databases. Each spreadsheet can be individually specified whether it should be compared as a spreadsheet or as a database. In case of comparing it as a database, multiple keys and their priority can be individually defined.

Compare Excel Files Online - Synkronizer

Symbols for each spreadsheet give a clear overview, how they are compared.

Synkronizer - Compare Excel Spreadsheets

Multiple filter and option settings enable, to really customize each comparison task. These features are unique to Synkronizer and make file comparison very easy, convenient and accurate.

Synkronizer - Compare & Merge Excel Files Online

Once the file comparison is completed, the entire workflow can be continued out of a single interface. From highlighting and un-highlighting differences to automatic updating of individual differences or entire difference types. A seamless work process is fully supported by parallel scrolling and hyperlinks.

Synkronizer - Compare Excel Files and Highlight Differences

A linked summary of all identified differences for each spreadsheet gives an easy to understand overview of the results.

Synkronizer - Compare, Update & Merge Excel Files

For each difference type the available update options are provided. This feature is unique to Synkronizer and makes it, in our opinion, the only solution that covers the entire scope of file comparison. From identifying differences, visualization and updating.

Synkronizer - Excel Comparison Tool

Difference reports are shown in excel, are hyperlinked and can be further customized or processed.

Synkronizer - Compare Excel Files for Differences