xlCompare: Complete list of updates

xlCompare 11

Released on 21/02/2023
  • Compare Excel files by using set of Rules, that defines how the software finds matching cells
  • Link mismatching columns in the report. If data you are working with has mismatched structure, this option allows to help xlCompare to find matching columns.
  • Ignore column from comparison right in the report mode.
  • Option to ignore case when comparing string values.
  • Collapsed Ribbon control. Now you can have more space for the worksheet view.
  • Difference Explorer is hidden by default.
  • Improved comparison algorithms.
  • New Primary Key editing commands.
  • Save combination of the key values for future use and apply it to any other Excel file.
  • Compare XML files for differences, by displaying structure of the XML files in the hierarchical tree form.
  • Ignore order of tags and attributes when comparing XML files.
  • Attach a Visual Basic macro to xlCompare, that become available in the worksheet menu. This allows you to write your own code that works with comparison report and allows you to perform any action in the report.
  • Fixed problem with loading 16-bit CSV files.
  • Minor updates and fixes.
What's new in xlCompare 11.0

xlCompare (10.7)

Released on 31/07/2022
  • New Interface: now xlCompare has Office 365 look
  • New Riboon commands: we've refectored our Ribbon structure to give you commands grouped by their functions
  • xlCompare is now available in the Korean language. Thanks to our partner Korea Software Service
  • New set of Merge commands
    1. Merge Sheets
    2. Merge Files
    3. Merge Folders
    4. Combine all sheets into one
    5. Update Sheets
    6. Update Files
  • Display Legend for the differences found
  • Filter differences by their type in the Legend area
  • Ignore columns from comparison
  • Optionally hide Difference Explorer window
  • Export and Import commands for the VBA Modules
  • Highlight records in the CSV files
  • Filter by Value command can be applied to several cells, to filter rows on the worksheet by these values
  • Evaluate Formula command to debug calculations and find our where the formula value came from
  • Optional Trend Icons
  • Headers of the rows with changed cells are marked with colors
  • Fixed issue with Korean and Japanese characters in the VBA modules
  • Improved Primary Key detection algorithm
  • New Worksheets Functions
  • New Worksheet Shapes are supported
  • Improved support of the Excel Object Model
  • Fixed few issues with Pie Chart
  • Fixed fiew minor issues with cell recalculation
  • Improved 3-File Comparison command
  • Minor updates and fixes
More information about xlCompare 10.7

xlCompare (10.5)

Released on 02/03/2022
  • 3-Way comparison for Excel files
  • Merge Excel files from command line
  • Improved primary key processing
  • Improved worksheet alignment in comparison report
  • Fixed few compatibility issues with XLSX format
  • Minor updates and fixes
More information about xlCompare 10.5

xlCompare (10.4)

Released on 01/13/2022
  • We've translated xlCompare to German language
  • Remove Duplicate Primary Keys\Rows
  • Clear Duplicate Primary Keys\Rows (leave first entry and remove others)
  • Filter Duplicates
  • Highlight Duplicates with fill color
  • Split Columns with custom text delimiter
  • Join Columns with custom text delimiter
  • Convert Text Values to Numbers
  • Remove Spaces in cell texts
  • New Edit Primary Keys Dialog
  • Option to disable calculations
  • Polished Comparison Algorithms: faster processing and more accurate results
  • Reworked Primary Key detection algorithms
  • Items in the Difference Explorer are always synchronized with worksheet views
  • Print to PDF: now xlCompare prints all worksheets, instead of active sheet
  • Reworked Ribbon Control: New commands added
  • Fixed problem in HEX2DEC function in the Spreadsheet Core engine
  • Fixed a few issues with saving XLSM files
  • Minor updates and fixes
More information about xlCompare 10.4

xlCompare (10.3.0)

Released on 12/01/2021
  • Flexible Comparison for similar primary keys. We've added an opton to detect changed keys, instead of marking them as unique. Read more information in this article - Compare Excel Files with Changed Primary Keys
  • Reworked outlined report created by excel diff tool. Summary worksheet contains information about compared excel files. Report sheet contains detailed summary for excel file comparison.
  • Mark Changes in the compared excel files command now inserts corresponding value into cell if you are using Extended View mode.
  • Filter Updated Rows command displays only rows, that contain updated cells in the compared excel files.
  • Minor updates and fixes.

xlCompare (10.2.10)

Released on 11/18/2021
  • Switch color formatting in left and right panels in excel diff tool.
  • Customize panel caption. Use your own caption instead of FILE1 and FILE2
  • Corrected captions for Unique Rows and Updated Cells
  • Fixed issue with inaccurate string value comparison.
  • Minor updates and fixes.

xlCompare (10.2.8)

Released on 11/11/2021
  • Compare excel files in a batch mode.
  • New parameters for Command Line mode. Complete list of command line arguments for excel diff tool you can find in this article: Excel Compare: Command Line Parameters

xlCompare (10.2.7)

Released on 11/07/2021
  • Fixed problem with wrong recalculation of total count of differences.
  • Fixed issue with filling different rows with background color when merging worksheets.

xlCompare (10.2.6)

Released on 11/03/2021
  • Improved data representation in the Extended View mode.
  • Fixed few issues in comparing zeros and empty values.
  • Fixed problem with comparing string values.
  • Minor updates and bugfixes.

New Video: Now to use Comparison Wizard

Published on 11/02/2021
  • Group worksheets when Comparing Excel Files
  • Change worksheet comparison options
  • More information about the Comparison Wizard
WATCH ON YOUTUBE

xlCompare (10.2.4)

Released on 10/27/2021
  • Minor updates and bugfixes.

xlCompare (10.2.0)

Released on 10/12/2021
  • New Commands on the Ribbon: Update and Filter records on the worksheets.
  • Improved worksheet sort routines.
  • Fixed few issues reported by our customers.

xlCompare (10.1.17)

Released on 09/29/2021
  • Improved Primary Key Detection algorithm.
  • Fixed compatibility issue with loading XLSX files.
  • Fixed crash on closing comparison report.

xlCompare (10.1.15)

Released on 09/22/2021
  • Improved Text Comparison command: open text files without delimiter.
  • Fixed few issues reported by customers.

xlCompare (10.1.14)

Released on 09/19/2021
  • Option to sort Excel Tables before comparison. It improves Comparison Report for database data.
  • Fixed problem with loading XLSX files with missed style (XF) records.
  • Minor improvements and fixes.

xlCompare (10.1.11)

Released on 09/15/2021
  • RANK.AVG and RANK.EQ functions are supported by xlCompare
  • Improvements in the VBA Engine
  • Fixed compatibility issue with saving protected ranges
  • Fixed issue with comparing string cells
  • Minor improvements and fixes.

xlCompare (10.1.5)

Released on 08/31/2021
  • Ribbon User Interface was restored
  • Navigation Buttons: Browse all diffs in your workbooks one by one
  • Paste Text with Delimiters from Clipboard
  • Improvements in the VBA Code comparison
  • Faster performance in the Filter commands
  • Improved worksheet browsing synchronization
  • Fixed issue in the Bulk Update command
  • Fixed issue with pasting data in the wrong date format
  • Fixed issue with DataValidation Rules
  • Fixed issue with Bar Chart
  • Fixed issue with saving XLS files
  • Minor improvements and fixes.

xlCompare (10.0.7)

Released on 08/22/2021
  • Faster workbook recalculation
  • Fixed issue with loading style XF records in the XLSM file
  • Fixed few issues reported by our customers
  • Minor improvements and fixes.

xlCompare (10.0.6)

Released on 08/17/2021
  • Text File Comparison Options - select how to open and compare text files.
  • Minor improvements and fixes.

xlCompare (10.0.5)

Released on 08/11/2021
  • Fixed problem with Tracing Formula Calculations with right click menu.
  • Fixed compatibility issue with saving XLSX files.
  • Fixed few minor issues in the Calculation Engine.
  • Minor improvements and fixes.

xlCompare (10.0.0)

Released on 07/28/2021
  • xlCompare got multithreading model. Now it performs time-consuming operations without locking main window.
  • Improved application performance and memory usage on the extremely large workbooks.
  • New and deleted rows are inserted into the Comparison Summary Report.
  • Fixed issue with saving data from the specific worksheet.
  • Minor improvements and fixes.

xlCompare (9.4.4)

Released on 06/28/2021
  • New Comparison Algorithm: Outlined Worksheet.
  • Improved worksheet synchronization when browsing differences.
  • Fixed issue with missed tendency arrows in the PDF report.
  • Fixed issue with opening empty excel files.
  • Fixed issue with saving XLSX files.
  • Minor improvements and fixes.

xlCompare (9.4.2)

Released on 06/18/2021
  • xlCompare was translated to German language.
  • Fixed compatibility problem with opening excel files in the XLSX format.
  • Improved Primary Key detection algorithms.
  • Improvements in the Comparison Wizard.
  • Minor improvements and fixes.

xlCompare (9.4.1)

Released on 06/09/2021
  • xlCompare was translated to Russian language.
  • We've extended list of comparison strategies for the most common types of the spreadsheets.
  • Display SUM, AVG and COUNT values on the status bar.
  • Extended list of the Paper Types.
  • Fixed problem with loading Visual Basic Project.
  • Fixed issue with wrong primary key detection.
  • Minor updates and fixes.

xlCompare (9.4.0)

Released on 05/29/2021
  • Customize colors for highlighed items in the Comparison Report.
  • Export all compared worksheets into PDF format.
  • Export tendency arrows into PDF format.
  • Specify Zoom Precent in the Options for all workbooks.
  • Fixed issue with command line mode: export comparison results to XLSX workbook.
  • Save Comparison Report as XML file.
  • Minor updates and fixes.

xlCompare (9.3.14)

Released on 05/07/2021
  • Fixed problem with copying Unicode characters to clipboard.
  • Fixed crash when exporting difference report to PDF.

xlCompare (9.3.11)

Released on 04/27/2021
  • Minor Improvements in the difference highlighting.
  • Improved crash report processing.

xlCompare (9.3.10)

Released on 04/25/2021
  • Improved Difference Report.
  • Improvements in the reflection of the comparison results.
  • Minor updates and fixes.

xlCompare (9.3.8)

Released on 04/14/2021
  • Improvements in the Comparison Algorithms.
  • Fixed issue with VLOOKUP worksheet function.
  • Fixed issues with wrong cell formatting.

xlCompare (9.3.5)

Released on 04/01/2021
  • Fixed minor issue with Shape positioning.
  • Fixed few compatibility issues with VBA code.
  • Fixed problem with wrong border colors.
  • Fixed crash in drill-down Formula Tracing

xlCompare (9.3.4)

Released on 03/28/2021
  • Improvements in the VBA Code processing.
  • Fixed crash whith option Align Worksheet.
  • Minor improvements and fixes.

xlCompare (9.3.2)

Released on 03/18/2021
  • Improvements and fixes in the VBE Engine.
  • Fixed problem with saving workbooks with Unicode strings.
  • Fixed "blue screen" problem with multiple monitors
  • Fixed minor issues in reflecting comparison results
  • Fixed problem with changing orientation in Print Preview
  • Fixed issue with Fill Color and Text Color selection
  • Fixed crash on opening workbooks with chartsheets

xlCompare (9.2.8)

Released on 02/17/2021
  • File menu item with file opening and saving commands.
  • Fixed problem with saving XLSX files
  • Fixed problem with duplicated number after Copy to Clipboard
  • Fixed a few issues in the VBA code comparison
  • Ability to compare 2 modules within same workbook
  • File issue with Find Next
  • File issue with copying data from the comparison report window

xlCompare (9.2.6)

Released on 02/11/2021
  • Save Compared Worksheet in the Extended View into PDF file.
  • XLOOKUP function is supported
  • Fixed file corruption issue with XLS files
  • Minor improvements and fixes

xlCompare (9.2.3)

Released on 01/17/2021
  • Fixed few formatting issues in the Extended View mode.

xlCompare (9.2.2)

Released on 01/14/2021
  • Reworked VB Project interface.
  • Improvements in the VB Code comparison.
  • Fixed new problems with VB Module comparison.
  • Minor improvements and fixes.

xlCompare (9.1.5)

Released on 12/24/2020
  • Fixed crash when comparinng 2 workbooks.
  • Improved row linking and worksheet alignment.
  • Minor improvements and fixes.

xlCompare (9.1.3)

Released on 12/18/2020
  • Faster comparison algorithm.
  • Fixed issue empty difference information.
  • Minor improvements and fixes.

xlCompare (9.0.10)

Released on 12/03/2020
  • Fixed problem with opening read-only files.
  • New worksheet functions.
  • Minor improvements and fixes.

xlCompare (9.0.7)

Released on 11/30/2020
  • 3-Way Comparison and Merge.
  • Automated bulk merge commands.
  • Reworked new interface.
  • Extended Command Line commands.
  • Fixed and improvements in the calculation and Visual Basic engines.
  • Number of minor improvements and fixes.

xlCompare (8.4.0)

Released on 05/04/2020
  • Fixed few issues with opening workbooks in the XLSX format.
  • Fixed few issues in the VBA Engine.
  • Number of minor improvements and fixes.

xlCompare (8.3.0)

Released on 03/24/2020
  • Select compared worksheets\modules.
  • Select Comparison Algorithm.
  • Faster and memory efficient comparison.
  • Additional options in the Mark Changes command
  • Fixed number of issues with XLS file format.
  • New functions and methods in the VBA Engine.
  • Number of minor improvements and fixes.

xlCompare (8.2.7)

Released on 02/20/2020
  • Fixed comparibility issue with XLSM file format.
  • Several improvements in the VBA Engine.

xlCompare (8.2.6)

Released on 02/12/2020
  • Reworked Activation and Trial Warning forms.
  • Minor updates and fixes.

xlCompare (8.2.5)

Released on 02/06/2020
  • Faster comparison of the String Values in Cells.
  • Faster comparison of Visual Basic Macros.
  • Switch Worksheets button.
  • Show or hide Merge Commands.
  • Changes in the string modifications formatting.
  • Fixed crash on opening comparison report from Recent Items.
  • Minor updates and fixes.

xlCompare (8.2.0)

Released on 01/15/2020
  • Modifications and Improvements in the Comparison Engine
  • Minor updates and fixes.

xlCompare (8.1.0)

Released on 01/08/2020
  • New design of the Recent Files page
  • New method to highlight differences in the string cells
  • Improvements in comparing Visual Basic macros
  • Minor updates and fixes.

xlCompare (8.0.0)

Released on 12/18/2019
  • New reworked layout: Pin Difference Explorer to the every side of the window
  • New Comparison Summary Report, based on the comparison results
  • Save Comparison Summary into XLSX, HTML, TXT and CSV formats
  • Faster and optimized file saving routines
  • Mark Changes command applies color formatting to the string values in cells.
  • Copy text into clipboard in the Rich Text format
  • Minor updates and fixes.

xlCompare (7.4.1)

Released on 11/18/2019
  • xlCompare displays all Tables in the workbook
  • Trace Calculations command is added to Names View
  • New improved algorithm to compare string values
  • Fixed problem with Mark differences with color command
  • Fixed compatibility issue with saving file in the XLSM format
  • Minor updates and fixes.

xlCompare (7.4.0)

Released on 11/12/2019
  • New application layout. Difference Explorer is not floating anymore, it is embedded into the Main Window.
  • Faster and more accurate cell style comparison
  • Improvements in the Calculation and Visual Basic Engines
  • Minor updates and fixes.

xlCompare (7.3.1)

Released on 09/15/2019
  • Function selector for VBA macros. Select function by name in the Combobox window above the code.
  • New user interface style
  • Several improvements in the Calculation Engine
  • Minor updates and fixes.

xlCompare (7.3.0)

Released on 09/15/2019
  • Option Ignore Protection to select and analyze locked cells on the protected sheets.
  • New worksheet and VBA functions
  • Improved tooltips in the Visual Basic Code Windows
  • Improved Go To Cell dialog
  • Fixed some minor problems with Find command
  • Fixed several issues in the VBA Engine
  • Minor updates and fixes.

xlCompare (7.2.4)

Released on 08/15/2019
  • Fixed few compatibility problems in the XLSM file format.
  • Minor updates and fixes.

xlCompare (7.2.2)

Released on 07/25/2019
  • New more accurate string comparison algorithm.
  • XLSM files are opened faster.
  • Improved color formatting in the Visual Basic Code Window.
  • Fixed problem with opening XLS files.
  • Improvements in the Comparison Engine.
  • Improvements in the Visual Basic Engine.
  • Minor updates and fixes.

xlCompare (7.2.1)

Released on 07/07/2019
  • Fixed problem in the Comparison Engine.
  • Fixed crash in the Visual Basic Engine.
  • Minor updates and fixes.

xlCompare (7.2.0)

Released on 06/30/2019
  • Number of fixes and improvements in the Comparison Engine.
  • Improvements in the Visual Basic Engine.
  • Minor updates and fixes.

xlCompare (7.1.7)

Released on 06/04/2019
  • New features in the Command Line Mode. xlCompare is ready to work with GIT DIFF.
  • Bulk Merge commands were improved.
  • Fixed few issues in comparing formulas.
  • Improvements in the Visual Basic Engine.
  • Fixed problems with Custom Formatting.
  • Minor updates and fixes.

xlCompare (7.1.6)

Released on 05/17/2019
  • Faster loading of XLSM\XLSX files.
  • Improved formatting in the Visual Basic Code.
  • Corrections in the Primary Key detection algorithm.
  • New worksheet functions.
  • Fixed few compatibility problems when loading XLSX workbook.
  • Fixed issue with search in the VBA code.
  • Fixed issue with enum statement in the VBA macros.
  • Minor updates and fixes.

xlCompare (7.1.4)

Released on 05/09/2019
  • Trim Strings command is added to the Right Click Menu.
  • Convert Strings To Numbers command is added to the Right Click Menu.
  • New Financial Functions added to the Calculation Engine.
  • Fixed crash in the Calculation Engine.
  • Minor updates and fixes.

xlCompare (7.1.3)

Released on 05/03/2019
  • Color formatting for Visual Basic Code.
  • Improvements in the comparison engine.
  • Fixed problem with ignoring whitespace in the Primary Keys.
  • Fixed issue with linking unique rows and columns.
  • Fixed issue with comparing Visual Basic functions.
  • Fixed crash when comparing formulas.
  • Minor updates and fixes.

xlCompare (7.1.0)

Released on 04/25/2019
  • Several fixes in comparing Database Style data.
  • Find command now works for Visual Basic Macros also.
  • Fixed issue with filtering records by Primary Key.
  • Fixed number of compatibility issues in the Visual Basic engine.

xlCompare (7.0.4)

Released on 04/16/2019
  • Fixed issue with sorting numbers stored as text cells.
  • Fixed crash when editing Primary Keys.
  • Fixed issue with comparing formulas on the worksheets with inserted\deleted rows and columns.
  • Fixed a few issues with Bar and Scatter charts.
  • Fixed problem with calculating Names, defined as formula.

xlCompare (7.0.2)

Released on 04/11/2019
  • User Interface was adopted for 4K display.
  • Fixed issue with comparing numbers stored as text cells.
  • Fixed issue with using Ignore White Space option for Primary Keys.
  • Area Chart is supported.

xlCompare (7.0.0)

Released on 03/22/2019
  • New, more flexible User Interface.
  • Improvements in the support of XLSM File Format.
  • Visual identification of the changed cell styles (borders, fill, font, number formatting).
  • Polished reporting to text and XLSX formats.
  • Minor improvements and fixes.

xlCompare (6.3.22)

Released on 01/31/2019
  • Fixed formatting problems under non-US locale.
  • Faster file loading and calculations.
  • Fixed crash when loading workbook with Group Shapes.

xlCompare (6.3.21)

Released on 01/31/2019
  • Fixed few compatibility issues with XLSM file format.
  • Minor improvements in the User Interface.

xlCompare (6.3.20)

Released on 01/16/2019
  • New comparison algorithm for outlined rows.
  • Minor updates and fixes.

xlCompare (6.3.19)

Released on 01/05/2019
  • Fixed issue with comparing numbers stored in the text fields.
  • Link Columns - option used to correct comparison results.
  • Difference between date values are shown correctly in the Extended View.
  • Minor updates and fixes.

xlCompare (6.3.18)

Released on 12/25/2018
  • Accuracy option, used to compare number fields
  • Ignored Characters option for string value comparison
  • Improved Extended View, to show actual difference between very similar numeric values.
  • Minor updates and fixes.

xlCompare (6.3.17)

Released on 12/12/2018
  • New comparison algorithm for data with different primary keys
  • Fixed frees on loading xlCompare
  • Fixed crash when opening VB Projects with ActiveX controls.
  • Minor updates.

xlCompare (6.3.15)

Released on 11/23/2018
  • Link Sheets option. Define how xlCompare should process worksheets if you compare different workbooks.
  • Link Columns option. Link columns by Name or by Index if you process Database data.
  • New VBA functions.
  • Fixed few minor problems.

xlCompare (6.3.14)

Released on 11/12/2018
  • Combine several columns into one.
  • Polished comparison algorithms.
  • Fixed crash in editing worksheet cells.

xlCompare (6.3.10)

Released on 11/05/2018
  • Faster workbook loading.
  • Fixed issue with reflection of the comparison results on scrollbar.
  • xlCompare creates startup log file.

xlCompare (6.3.9)

Released on 10/24/2018
  • Evaluation version doesn't require to register an account on our website.

xlCompare (6.3.7)

Released on 10/18/2018
  • Filter by Criteria command filters data on the opened worksheets by wildcard criteria.
  • Trace Error command shows where the error value in formula came from.
  • Improvements in the Evaluate Formula and Display Errors windows. xlCompare gives you powerful tools to audit formulas in your workbook.
  • Fixed problem with saving comparison report as worksheet
  • Fixed minor issue in the MATCH function.
  • New Visual Basic objects and functions.
  • Improvements in the command line mode. Running VBS files from command line, gives you more flexibility in comparing with usual command line mode.

xlCompare (6.3.4)

Released on 10/09/2018
  • Fixed problem with comparing Visual Basic Projects.
  • Minor changes in the Primary Key detection algorithm.

xlCompare (6.3.3)

Released on 09/27/2018
  • Fast calculations. Significant increase of the calculation speed in some worksheet functions.
  • Fixed few issues in loading XLSM files.
  • Display Errors feature added to the Tools tab on the Ribbon

xlCompare (6.3.0)

Released on 09/19/2018
  • xlCompare loads files in the XLSM\XLSX format faster and more efficient (memory usage was significantly decreased).
  • New Statictical and Date worksheet functions
  • Fixed few issues with inaccurate comparison
  • Improved VBA support

xlCompare (6.2.3)

Released on 07/23/2018
  • Fixed problem with Ignore Whitespace option
  • xlCompare supports new VBA object methods and properties

xlCompare (6.2.2)

Released on 07/05/2018
  • Faster loading of the XLSM files
  • Improved calculations of the Lookup functions
  • Class modules in the Visual Basic project
  • New Statistical and Math worksheet functions

xlCompare (6.2.1)

Released on 06/11/2018
  • Database commands, relative to duplicated rows and keys, are moved to Duplicates ribbon tab.
  • New commands:
    • Highlight Duplicate Keys
    • Highlight Duplicate Rows
  • Fixed compatibility problems with saving XLSX files.
  • Fixes and improvements in the Visual Basic Engine.

xlCompare (6.2.0)

Released on 05/24/2018
  • Reworked comparison strategies. Separate processing for Database data.
  • Indication of the hidden data on the sheet with Filter icon.
  • Minor bugfixes.

xlCompare (6.1.2)

Released on 05/18/2018
  • Print command added to xlCompare.
  • Improvements in the comparison report saved as worksheet.
  • Print Comparison Report command.
  • Fixed compatibility problem with loading XLS files.
  • Minor bugfixes.

xlCompare (6.0.4)

Released on 05/09/2018
  • Fixed bug with Ignore Whitespace Filtering option.

xlCompare (6.0.2)

Released on 05/03/2018
  • Fixed crash on Filtering Duplicate Rows.
  • Minor bugfixes.

xlCompare (6.0.1)

Released on 04/24/2018
  • Database Tab: setup of time saving commands to filter and sort data in your workbook
  • Commands to delete and filter duplicated rows and Primary Keys.
  • Run Visual Basic Macros to automate xlCompare.
  • Save comparison report on the worksheet.
  • Improvements in the command-line mode.
  • New worksheet and VBA functions.
  • Save filtered data from selected worksheet.
  • Minor bugfixes.

xlCompare (5.3.24)

Released on 04/11/2018
  • Several improvements in the Extract Changed Records feature.
  • New features in the command-line mode.

xlCompare (5.3.23)

Released on 03/27/2018
  • Fixed crash when opening workbook with a Group Shape

xlCompare (5.3.22)

Released on 03/22/2018
  • Zoom your worksheets, like you are doing this in Excel. Use Ctrl+Mouse Wheel or Zoom spin control on the View tab.
  • Fixed a few problems with external references
  • New commands on the Tools Tab:
    • Filter By Key - select key value in your table and filter rows by this value
    • Hide Rows\Columns - hide selected rows or columns. With options on the Filter tab you can exclude them from comparison
    • Remove Empty Rows - remove all empty entries on your worksheet
    • Remove Hidden Rows - remove data you've hidden
    • Sort Rows - sort data on the worksheet with Primary Key
  • Fixed crash on excluding Show Hidden Sheets option
  • Minor improvements and bugfixes

xlCompare (5.3.19)

Released on 03/12/2018
  • Much faster processing of XLSX\XLSM\XLAM workbooks
  • Reworked tooltip which displays difference between compared cells
  • Improved Compare Values and Formulas on the character level option. Now results of the comparison are reflected in the worksheet and in the tooltip.

xlCompare (5.3.17)

Released on 03/09/2018
  • Website has been moved to HTTPS protocol
  • Fixed drawing bug in the Difference Explorer

xlCompare (5.3.15)

Released on 02/28/2018
  • Fixed problem with saving XLSM files
  • Display difference between string values and formulas on the character level
  • Faster processing and navigation
  • DEC2HEX function is supported

xlCompare (5.3.11)

Released on 02/19/2018
  • Minor improvements in the User Interface
  • Synchronize selection between worksheet and Difference Report
  • Option to disable Conditional Formatting
  • Internal improvements and bugfixes

xlCompare (5.3.10)

Released on 02/06/2018
  • Fixed compatibility problem with Conditional Formatting
  • Fixed compatibility problem with Merged Cells
  • Fixed slowdown on filtering changed cells

xlCompare (5.3.4)

Released on 12/03/2017
  • Fixed crash on switching between worksheets

xlCompare (5.3.3)

Released on 11/11/2017
  • Ignore Empty Strings option has been renamed into Ignore Whitespace. Now it affects to the primary keys also. With this option turned ON, xlCompare trims primary keys before comparison.
  • Fixed problem with Copy menu command on the worksheet
  • Fixed bug with showing RTF text in cells
  • Fixed issue with creating backup files

xlCompare (5.3.2)

Released on 11/02/2017
  • Ignore Empty Strings option: skip strings which contains only spaces
  • Reset Primary Keys command: restore Primary Keys to default state
  • Fixed problem with opening XLS files with Tables
  • Fixed problem with comparing unsorted database data
  • Fixed few minor interface issues

xlCompare (5.3.1)

Released on 10/20/2017
  • Improved Array Formula calculations
  • IFNA excel worksheet function is added
  • Fixed few compatibility problems
  • Fixed problem with merging formulas on the worksheets
  • New option to mark changes with color automatically in merge operation
  • Fixed bug with reflecting string constants in the formula editor

xlCompare (5.3.0)

Released on 10/16/2017
  • Pin Difference Explorer to the Ribbon
  • Recent Comparisons list is placed on the Recent tab on the Ribbon
  • Count of differences is reflected on the Ribbon Tabs (View and Results)
  • Fixed problem with opening XLSX workbooks
  • Fixed problem with saving Visual Basic project

xlCompare (5.2.8)

Released on 10/11/2017
  • Fixed problem with opening XLSM workbooks

xlCompare (5.2.6)

Released on 10/06/2017
  • Fixed problem with overflowing data buffer in exporting long formulas into HTML format
  • Contains Errors conditional formatting rule
  • Not Contains Errors conditional formatting rule
  • Fixed problem with FORECAST function
  • Fixed few User Interface issues

xlCompare (5.2.5)

Released on 09/19/2017
This update contains a lot of improvements and fixes.

xlCompare (5.2.4)

Released on 12/15/2016
  • Fixed crash on opening book with chart with multilevel categories.
  • Fixed problems with updating tables after changing filtered values.
  • Fixed few minor issues.

xlCompare (5.2.3)

Released on 12/02/2016
  • xlCompare has been signed with Code Signing Certificate.
  • Significantly reworked clipboard functions.
  • Differences are reflected with color on the scrollbars
  • Mark Ribbon Buttons and Sheet\Module Tabs with count of differences (Filter Differences)
  • Hide Equal Worksheets\Modules
  • Ignore cells with ERROR values
  • Fixed bugs with Pie Charts.

xlCompare (5.2.1)

Released on 10/25/2016
  • Fixed drawing bug with connector shapes.

xlCompare (5.2.0)

Released on 10/06/2016
  • Set and manage Primary Keys on the worksheet
  • Fixed problem with slow filtering commands.
  • Fixed a few minor issues.

xlCompare (5.1.10)

Released on 07/22/2016
  • Save report as Table.
  • Extended Command Line mode - you can pass worksheet names to xlCompare.

xlCompare (5.1.9)

Released on 07/06/2016
  • Bulk Merge command is applied to all differences, not only to selected branch. You can still apply it to selection only, if you use this command for Right Click Menu in the Difference Explorer.
  • Fixed problem with saving merged cells in the XLS format.

xlCompare (5.1.8)

Released on 06/23/2016
  • Extract Unique Records command leaves changed cells on the sheet.
  • Display Hidden Sheets option. Allows to view\hide hidden worksheets.
  • Display Column Numbers option. You can switch between Numbers and Names in the columns heading.
  • Display Names. You can see all defined names in your book.
  • Few minor fixes in the Calculation Engine.
  • Fixed bug in the reference parser.

xlCompare (5.1.7)

Released on 06/18/2016
  • Fixed compatibility problem with XLS file format
  • New Command: Extract Unique Records

xlCompare (5.1.6)

Released on 06/05/2016
  • Fixed problem with comparing database records
  • Fixed issue with Number Formatting

xlCompare (5.1.4)

Released on 05/30/2016
  • New feature - Trace Calculation Results
  • Redesigned Filter Cells feature in the Difference Explorer.
  • EOMONTH, CEILING.MATH, FLOOR.MATH worksheet functions are supported
  • Fixed problem with comparing merged cells
  • Few minor fixes.

xlCompare (5.1.3)

Released on 05/24/2016
  • New option - Filter compared cells
  • Compare cells by formatting options
  • Fixed issue with comparing workbooks with external links.
  • Fixed command line bug - command line mode has been cancelled by Trial Screen.

xlCompare (5.1.1)

Released on 05/17/2016
  • Trial warning screen. It describes limitations of the Trial Version when you are using it.

xlCompare (5.1)

Released on 05/10/2016
  • xlCompare displays Visual Basic Forms in their native representation. You can edit and merge VB Forms easily with full control on the process.
  • Open workbook by dragging file into xlCompare window
  • We've fixed number of issues with opens files in the XLS file format

xlCompare (5.0.6)

Released on 03/23/2016
  • New Interface: Now xlCompare uses Ribbon like Office applications
  • Difference Explorer: Ribbon interface
  • Difference Explorer displays differences between worksheets and VB Modules on separate tabs
  • Display Sheets, VB Modules, VB Classes and VF Forms on the separate views

xlCompare (5.0.5)

Released on 02/09/2016
  • Reworked Formula Bar: we've added colored arguments, fast and easy argument selection ...
  • Fixed crash when opening XLS files with external links.
  • xlCompare saves layout of it's windows.

xlCompare (5.0.1)

Released on 01/14/2016
  • Optimized for speed and memory usage Calculation Engine.
  • Minor bug fixes.

xlCompare (4.2.0)

Released on 10/12/2015
  • Significantly decreased memory usage.
  • Much faster file processing.
  • Minor bug fixes.

xlCompare (4.1.14)

Released on 08/26/2015
  • Fixed crash when opening XLS files.
  • Fixed crash in the worksheet IF function.

xlCompare (4.1.12)

Released on 08/24/2015
  • Now in case of crash xlCompare creates Crash Report file, you can send to us for investigation.

xlCompare (4.1.11)

Released on 08/20/2015
  • xlCompare supports MultiPage control on the User Forms.

xlCompare (4.1.10)

Released on 08/11/2015
  • All new spreadsheet features and fixes available in the xlCompiler were added to xlCompare.

xlCompare (4.1.9)

Released on 04/22/2015
  • Fixed problems with loading large XLS\XLSM workbooks.
  • Fixed crash occured on the first start.

xlCompare (4.1.6)

Released on 02/24/2015
  • xlCompare supports mvba file format (Bentley MicroStation).
  • Much faster loading for XLSM\XLSX files
  • Fixed crash when loading files with Group Shapes

xlCompare 2014 (4.1.5)

Released on 01/27/2015
  • Fixed floating problem with entering Activation Codes into xlCompare. (Some codes were rejected.)

xlCompare 2014 (4.1.4)

Released on 01/20/2015
  • Fixed problem with loading workbooks in the XLS format

xlCompare 2014 (4.1.3)

Released on 01/07/2015
  • Fixed problem with saving comparison report in the HTML format

xlCompare 2014 (4.1.2)

Released on 01/05/2015
  • Improved Extended View mode in the comparison report
  • New Comparison Report items in the Difference Explorer
  • Fixed a minor issue with software activation

xlCompare 2014 (4.1.1)

Released on 12/23/2014
  • New time saving commands: Merge Worksheets, Duplicate remover
  • Clear Background command

xlCompare 2014 (4.1.0)

Released on 12/19/2014
  • Major update.
What's new in this update?

xlCompare 2014 (4.0.17)

Released on 12/16/2014
  • Fixed issue with Grouping feature. Now it is applied to all worksheets in the list.

xlCompare 2014 (4.0.16)

Released on 12/14/2014
  • Reworked Filter feature. You can see only changed or new rows in the database lists. This is useful when you are working with database tables imported into Excel worksheets.

xlCompare 2014 (4.0.15)

Released on 12/11/2014
  • Now xlCompare has Check for updates feature. You will be notified about the update as soon as it is published on our website.

xlCompare 2014 (4.0.14)

Released on 12/10/2014
  • Merge commands for "database" lists: union, intersection, difference.
  • Fixed number of minor issues.
Using these commands you can easily do such tasks as join 2 lists in Excel, or similar.
Help topic Database Comparison describes these features in details.

xlCompare 2014 (4.0.11)

Released on 12/05/2014
  • Export comparison report into HTML format.
Help topic Save comparison report in the external file explains how this feature works.

xlCompare 2014 (4.0.10)

Released on 12/03/2014
  • In this update we've added ability to mark all different cells with color.
You can find more information on this feature in the article Mark differences with color.

xlCompare 2014 (4.0.9)

Released on 11/28/2014
  • Major update.
What's new in this update?

xlCompare 2014 (4.0.8)

Released on 10/13/2014
  • Minor update. We've moved some useful commands from Difference Browser toolbar to the main xlCompare window.

xlCompare 2014 (4.0.7)

Released on 10/10/2014
  • Minor update. We've polished comparison algorithms for price lists and accounting statements.

xlCompare 2014 (4.0.6)

Released on 10/05/2014
  • Minor update. This update allows to pin Difference Explorer window to the Main Window and some improvements in comparing Visual Basic Modules.

xlCompare 2014 (4.0.5)

Released on 10/03/2014
  • Minor update. This time we've changed formatting in the VBA Comparison results to a more suitable. It should better reflect changed parts of the text

xlCompare 2014 (4.0.4)

Released on 10/01/2014
  • Minor update.

xlCompare 2014 (4.0.2)

Released on 09/26/2014
  • Compare VBA Modules in the workbooks. Click this link for more information on how to use Compare Visual Basic modules feature.
Also, you may want to review these topics from the F.A.Q. section:
  • Compare 2 Visual Basic Modules
  • Merge multiple lines in the VBA modules.

xlCompare 2014 (4.0.1)

Released on 09/09/2014
  • Minor update.

xlCompare 2014 (4.0)

Released on 09/05/2014
  • New generation of the xlCompare software has been published.

xlCompare 3.3.9

Released on 06/17/2014
  • Changed behavior for workbooks with single sheet. Now worksheets should have same name to be compared.
  • Fixed wrong primary key detection.

xlCompare 3.3.8

Released on 05/06/2014
  • Fixed bug with comparing "database" data.

xlCompare 3.3.6

Released on 03/08/2013
  • Improved comparison of the CSV\TXT files.

xlCompare 3.3.5

Released on 12/17/2012
  • Fixed problem with comparing VBA Projects.
  • Fixed wrong primary key detection.

xlCompare 3.3.4

Released on 08/27/2012
  • Fixed problem with spreadsheets which contain more than 65000 rows.

xlCompare 3.3.3

Released on 08/20/2012
  • Minor improvements in the database comparison algorithm.

xlCompare 3.3.2

Released on 06/27/2012
  • Mark Differences, Combine Worksheets, Intersect Worksheets, Get Worksheet Difference commands were added to the toolbar.

xlCompare 3.3.1

Released on 06/21/2012
  • Combine workbooks, create intersection and difference in single click.
  • xlCompare commands can be used in the VBA macros.
  • Removed warning shown when option Trust Access to VBA Project is disabled.

xlCompare 3.3

Released on 06/12/2012
  • xlCompare is available in Spanish and Russian languages.
  • xlCompare creates reports in the XLS, HTML and TEXT formats.
  • Several bugfixes.

xlCompare 3.1

Released on 05/11/2012
  • Completely reworked interface - all differences are shown in same Difference Explorer window.
  • Reworked Named Item comparison.
  • Reworked VBA Project comparison.

xlCompare 3.0

Released on 03/27/2012
  • More accurate comparison results.
  • Command to restart the comparison.

xlCompare 2.6.9

Released on 03/14/2012
  • This update contains improved comparison engine.

xlCompare 2.6.8

Released on 02/20/2012
  • Added commands to create intersection of the compared worksheets.

xlCompare 2.6.6

Released on 09/06/2011
  • Comparison results for Names may be filtered and exported.
  • Fixed problem with copying rows between worksheets.

xlCompare 2.6.5

Released on 08/12/2011
  • You can select formatting options for each type of the difference. Read more ...

xlCompare 2.6.4

Released on 08/05/2011
  • Fixed problem with ThisWorkbook VBA module, excluded from comparison.
  • Faster Comparison Report.
  • Several bugfixes.

xlCompare 2.6.2

Released on 07/21/2011
  • New reworked interface. Added Difference Browser window.
  • Several bugfixes.

xlCompare 2.6.1

Released on 05/13/2011
  • xlCompare supports Excel 64-bit.
  • Several impovements in the interface.

xlCompare 2.6.0

Released on 04/19/2011
  • Improved comparison algorithm for unsorted data.

xlCompare 2.5.8

Released on 04/06/2011
  • Improved in-place cell editing in the grid.
  • Fixed several issues happened when comparing datasets with "mixed" data.
  • Fixed several bugs with drawing multiline cells in the comparison report.

xlCompare 2.5.5

Released on 03/29/2011
  • Number of fixes and improvements in the "database" data comparison.
  • Display "database" data in the sorted order

xlCompare 2.5.1

Released on 03/05/2011
  • Fixed problem: "Access to VBA Project blocked" warning when comparing VBA projects.

xlCompare 2.5.0

Released on 02/08/2011
  • New, more friendly interface.
  • Faster comparison and more accurate comparison results.
  • Edit cell values directly in the xlCompare Comparison Report window.

xlCompare 2.4.7

Released on 02/02/2011
  • Fixed problem with disabled buttons on the xlCompare toolbar.
  • Fixed several compatibility problems with another Add-ins.
  • Fixed problem with database-style comparison.

xlCompare 2.4.6

Released on 11/24/2010
  • Fixed problem with incorrect closing of Excel Application after comparison.

xlCompare 2.4.5

Released on 11/17/2010
  • Improved database-style comparison.
  • Improved comparison of the VBA Code.

xlCompare 2.4.4

Released on 08/12/2010
  • Fixed problem with marking changed cells in the workbook.

xlCompare 2.4.3

Released on 07/14/2010
  • Evaluation period was extended to 15 days.

xlCompare 2.4.2

Released on 07/09/2010
  • Several improvements and bug-fixes

xlCompare 2.4.1

Released on 07/02/2010
  • Quick access to commands in the VBA Comparison Report dialog.
  • Several improvements and bug-fixes

xlCompare 2.4.0

Released on 06/30/2010
  • xlCompare can be called from the All Programs menu.
  • You can use xlCompare commands from the command line or batch file.
  • Several improvements and bug-fixes

xlCompare 2.3.6

Released on 06/17/2010
  • Export VBA Comparison Report into HTML format.
  • Several improvements in the merging VBA Code features.

xlCompare 2.3.3

Released on 06/13/2010
  • Compare Visual Basic Projects.

xlCompare 2.3.2

Released on 06/02/2010
  • Quick Merge Toolbar - resolve differences by single click
  • Simplified interface

xlCompare 2.3.1

Released on 04/07/2010
  • User can select appropriate Comparison Options. More ...
  • Much faster comparison algorithm

xlCompare 2.3.0

Released on 04/01/2010
  • xlCompare compares and merges Names in the Excel workbooks. More ...

xlCompare 2.2.11

Released on 03/26/2010
  • New range selection controls - like Ref Edit Control in Excel.
  • Faster database comparison.

xlCompare 2.2.9

Released on 03/22/2010
  • Several improvements in the database comparison.
  • New commands added - Home, About.
  • Recent Items menu added to the xlCompare toolbar in the Excel 2003.

xlCompare 2.2.7

Released on 03/10/2010
  • xlCompare is available in German language.
  • xlCompare comparison functions can be called from VBA code.

xlCompare 2.2.4

Released on 12/29/2009
  • Improved Comparison Report Dialog.
  • Fixed several issues in the comparison engine.

xlCompare 2.2.2

Released on 11/18/2009
  • New toolbar command for Comparison Report Dialog.
  • Updated Help Library.

xlCompare 2.2.1

Released on 11/16/2009
  • Find Cell feature has been added. You can quickly find value on the Comparison Report.
  • Fixed several bugs in the comparison engine.

xlCompare 2.2

Released on 11/10/2009
  • Database data is sorted before comparison.
  • Improvements in the interface.

xlCompare 2.1.1

Released on 11/04/2009
  • Several internal improvements.

xlCompare 2.1

Released on 10/04/2009
  • Move data from compared worksheets to 3-rd sheet.
  • Drag-n-drop cells\rows\columns between compared sheets and 3-rd worksheet.
  • Use clipboard to merge differences.
  • xlCompare compares formulas and values to find the differences.
  • Formula bar added to each worksheet view.
  • Improved comparison engine.
  • Improved Comparison Report Dialog.

xlCompare 2.0

Released on 09/09/2009
  • New features for merging workbooks.
  • Compare spreadsheets which have database structure.
  • Improved comparison engine.
  • Reworked interface for Comparison Report Dialog.
  • Most recent comparisons are shown in menu - you can repeat it without opening workbooks.

xlCompare 1.2.1

Released on 08/05/2009
  • Improved comparison engine. New comparison algorithm displays results in more suitable form.

xlCompare 1.1.2

Released on 07/24/2009
  • Improvements in the comparison engine.
  • "Check for update" feature.
  • Fixed problem with blank reports shown for comparison.
  • Fixed several minor issues reported by our customers.

xlCompare 1.1.1

Released on 06/19/2009
  • Fixed problem with registration.

xlCompare 1.1

Released on 06/10/2009
  • Much faster and precise comparison engine.
  • Tile Worksheet Views. You can align worksheet views horizontally or vertically to display data in more suitable way.

xlCompare 1.0

Released on 05/27/2009
  • First version of this utility has been published.