Synkronizer is an Excel spreadsheet data comparison tool that compares different data from two worksheets and finally provides a copy of the data that the user can find, edit and modify as needed, with reliable and fast software.
1. Unparalleled accuracy and performance you can trust
For over 15 years we have worked closely with our customers and listened carefully to the challenges they face when comparing Excel worksheets. This feedback has always been integrated into each new Synkronizer release.
Synkronizer 11 now achieves accuracy in comparing Excel files that is unmatched in the market.
Automatically comparing, merging and updating Excel data requires a tool that you can trust completely. More than 10,000 customers worldwide already trust Synkronizer.
2. Compare millions of cells and an unlimited number of tables in a matter of seconds.
It is used for simple Excel tasks such as comparing and merging vendor databases, as well as complex workbooks that require maximum performance, speed and accuracy.
Now you can compare an unlimited number of Excel worksheets, all at the same time, with just a few clicks.
No matter how large the Excel file is, it will prove its power to increase your productivity and save maximum time.
3. Automatic database update.
It enables you to compare the differences between two Excel files, updating and merging any Excel database faster and more accurately than manually. In seconds you can merge vendor databases from different departments or update your client databases. Synchroniser 11 allows you to save time and improve the quality of your most valuable asset – your database.
4. Inserted columns and rows – no big deal for Synchroniser.
Inserted rows and columns are mostly a tricky challenge.
Synchroniser 11 is no big deal. Inserted columns and rows are accurately identified and automatically highlighted.
Once identified, a convenient and easy to use interface guides you through the process of merging or updating cells. All this with a simple mouse click.
5. Compare more than just numbers and text.
It goes far beyond just comparing Excel worksheets, such as standard formats, numbers and text.
With Synkronizer, you can compare values, such as text and numbers, as well as entire formulas, no matter how complex they are.
And that’s not all. Synkronizer 11 also compares cell comments.
How to use
After installing Synkronizer, the add-in can be launched in the excel add-in toolbar.
The following are the official steps for use.
01-02 Selecting the excel file to be compared
Here you can select either different files or the same file, but only if there are no more than two files.
03 Select the workbooks to be compared
Here you can compare more than one set of workbooks, you can create a two-by-two comparison between multiple workbooks.
04 Setting the comparison range
By default, the program uses the workbook mode for comparison, but you can also choose to compare in database mode. This way you can add key comparison entries and one more thing is to select the number of rows of headings so that you are less likely to make mistakes in a table with multiple headings.
05 Running the results
After running the comparison operation by clicking on the logo, you get this comparison result.
The difference between the two tables is shown by the different fill colours
The synkronizer interface shows all the detailed comparison results.
Frequently asked questions
1. What is Synkronizer?
Synkronizer is a COM add-in for comparing, synchronising and updating Excel tables.
2、What is a COM Add-in
A COM Add-in is an additional program, procedure or function that is automatically loaded when Excel (or other applications) is started. Add-ins can be used to meet the needs of different users
requirements and increase the comfort and speed factor when using such applications.
3. How Synkronizer works
Synkronizer reads data from old and new Excel worksheets and compares each cell entry bit by bit.
Synkronizer has a validation tool that automatically detects all differences. This allows you to immediately identify data that has been added, deleted or changed
4. Is Synkronizer running a virtual machine?
Yes, Synkronizer is also available for virtual machines. However you will need a different licence, which can be issued free of charge if required.
5. How many files can be compared
With the Professional Edition, only two files are compared (per cycle). With the Developer Edition, multiple files can be compared in a single process using command line commands or VBA.
6. How many tables can be compared
All tables contained in a file can be compared. There is no limit.
- synkronizer still has a lot of features
- The new version has improved the speed in terms of extracting the main data
- Now you can extract data from any row directly on the table
- Different data can be displayed on the table
- you can directly open Excel to view the differences in the table data
- support a red cell to mark the difference in the data
- the new function can delete the difference table data
- the new function to delete different columns