IntroductionContact UsCopyrightOn-line Help LibraryWhich file formats are supportedComparison StrategyxlCompare CommandsFile | OpenFile | Recent ComparisonsCompare | BooksCompare | SheetsCompare | ModulesCompare | OptionsView | LayoutView | Ignore FormattingTools | RecalculatexlCompare ActivationHow to activate xlCompare on the another PC?How to restore xlCompare on my PC?License detailsHow to remove trial limits?General Questions Extended View modeDisplay differences in Extended ViewFilter differencesMerge data from two worksheetsUpdate records on the worksheetDuplicate RemoverGet duplicates between 2 listsExtract Unique RecordsCommand Line modeSave changes in the workbookSave comparison report on diskWorking with TXT and CSV filesFilter data you want to compareIgnore error valuesTrace Formula CalculationsMinimize Difference BrowserSynchronize rows and columnsMark differences (changed cells) with colorDatabase ComparisonCompare worksheets As DatabaseManage Primary KeysHide Equal ModulesFilter cells on the worksheetJoin 2 lists in ExcelFind duplicates in ExcelRemove duplicates in ExcelRemove empty rows on the worksheetBulk Merge operationsBulk Undo operationHighlight only results you needVersion ControlUse xlCompare with SVN to resolve conflictsCompare Visual Basic ProjectsCompare controls on the VB FormsMerge controls on the formsMerge contents of the VBA ModulesI've found a problemSending bugreports to Spreadsheet Tools

What do we mean under Database Data:

  • Worksheet has structured data with Primary Key column(s)
  • There is optional Primary Key row(s)
  • Row may have formulas, but they should not refer to other rows. Only to cells in this row.
This type of data is a database table and it should be compared with other algorithms, than usual worksheets.
Database comparison option gives you much more accurate comparison results.
Database Comparison
Option which enables Database Comparison mode is on the Compare Ribbon Tab. If it has green color, like on the image above - this option is active.
For this type of worksheets you can apply set of commands from the Database Tab:
  • Filter by Key
  • Filter by Value
  • Filter Duplicate Keys
  • Filter Duplicate Rows
  • Remove Duplicate Keys
  • Remove Duplicate Rows
  • Hide rows by key
  • Remove Empty Rows
  • Remove Hidden Rows
  • Invert Selection
  • Manage Primary Keys