Compile XLS to stand alone EXE, Trace Dependencies in Excel Formulas and Best Excel File Compare Tool
11/10/2021 - Merge two Excel Files into one
Use excel diff tool (xlCompare) to combine two excel files into one, by merging different row and updating corresponding cells.
This video shows one of the cases, where you can use out xlcomparator to consolidate excel files.
11/07/2021 - xlCompare 10.2.7 (Regular Update)
11/02/2021 - New video in our Youtube Channel
How to use Comparison Wizard in the Excel File Compare Tool. Manage groups of the compared worksheets and setup comparison options.
Comparison Wizard is an important part of the xlCompare. Please, watch this video if you are going to compare and merge excel files.
10/12/2021 - xlCompare 10.2.0 (Major Update)
09/29/2021 - xlCompare 10.1.17 (Minor Update)
Sort Tables. This is important option which makes your data properly aligned in the comparison report. Usually you sort your sheets by key column to get cells ordered. xlCompare automatically does this work for you.
Primary Keys. Most of the spreadsheet have database structure. Such Excel Tables contain primary keys used to identify equal records. In xlCompare you can define Primary Key Columns and Rows with a right click menu commands. But when you load your excel find into xl compare - it makes initial selection of the key columns and offer it to you. This algorithm was improved in this update.
Compare CSV files. This is one of the primary features in xl compare. Please, visit this page for additional information: Compare CSV files with xl compare
09/12/2021 - xlCompare 10.1.10 (Regular Update)
Protected Range is a commonly used Excel Worksheet feature. It allows to protect separate areas on the worksheet from editing. Or to assign different permissions to the ranges of cells on the worksheet. To use this option in Excel you should use the Review | Allow Edit Ranges command on the Ribbon.
RANQ.AVG and RANQ.EQ worksheet functions are used to calculate Rank of the specific value in the array of numbers.
08/24/2021 - xlCompare 10.1.0 (Major Update)
Ribbon interface is very convenient to Excel users, so we've decided to restore it and use instead of the previous one. We hope, that this will make xlCompare more easy in use for you.
08/23/2021 - xlCompiler 3.11.0 is ready to download
08/22/2021 - xlCompare 10.0.7 is ready to download
08/04/2021 - Features list was updated on the xlCompare website
We've analyzed various product features published in the spreadsheet comparator reviews. Look which ones are present in the xlCompare.
07/28/2021 - xlCompare 10 is ready to download
Major update for xlCompare is ready! List of modifications:
07/07/2021 - New article on the xlCompare website
How to use Comparison Wizard in the xlCompare.