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
Version Control for Excel Workbooks
Version control for Excel Workbooks is not a trivial work. If you doing it manually - you have significant loss in the productivity. There are many comparison tools on the market, but not all of them are suitable for version control.
When we've started working on the xlCompare 2020, one of the primary tasks was - this utility should be used for version control for the Excel files.
What xlCompare can offer for Excel developer, who needs version control utility?
xlCompare has command line mode, which allows to integrate it with all modern version control repositories. Version Control Repositories offers you a way to store different versions of your file and manage list of changes. Typically they have own Difference Viewer utility. This works good for a text files. But, all Excel workbooks are binary files. Text comparators are not applicable in this case. You need to configure your Repository, or utility you are using to display differences for Excel workbooks (XLS, XLA, XLSM, XLSX, XLAM) using xlCompare utility.
When your version control system is configured to invoke xlCompare, you can use all power of our tool to resolve conflicts between different versions of your workbooks. Quick and accurate comparison results and easy to use merge commands performs complex operations in the seconds.
xlCompare has all you need for version control. If it doesn't meet your requirements - let us know and we'll improve it by your request.