Diff XLSX Excel Files in the SVN(GIT) using xlCompare

How to use xlCompare as an external diff viewer for your GIT(SVN) environment

XLS, XLSX, XLSM Diff Viewer
xlCompare is an Excel Diff Tool designed for all possible types of spreadsheet comparison. GIT and SVN systems are one of them. xlCompare is a tool you can trust to find all evern minor changes you've and your excel files.
Merge Tool
Comparison is not the only benefit you get from Excel Compare. We give you a tool to Update(merge) changed made in your worksheets and VBA code. In the automatic and manual (step by step) modes you merge changes made in the different versions of your workbooks.
Conflict Editor
Very common case - you've updated your working copy and got the conflict. The Excel file you are working with was changed by a colleague! What to do? Look for modifications manually?
Let xlCompare to help you! With this diff tool you can Highlight and Resolve Conflicts, when committing files into repository.
Every SVN(GIT) application comes with embedded diff viewer tools, used to compare files in the known formats. But usually these applications compare files in the text format only. They are perfect for source code written using any programming language, text file or something like this. But Excel Files (XLS, XLSX, XLSM, XLSB) are just a binary files for these tools. These files can't be compared with most of the standard diff viewers. We've created xlCompare to fill this gap and give you more than excel comparator - we give you powerful tool which wll save your time and make your work much more comfortable.

How to integrate xlCompare into SVN(GIT)

Use command line options to integrate xlCompare as a Diff-Merge Tools into your Version Control Application.

Command line mode is a "bridge" between xlCompare and SVN(GIT) tools. Normally Source Code Control Systems allow to setup diff tools for different types of files in it's options. You can use xlCompare to diff and merge following types files:
  • XLS Microsoft Excel 97-2003 Workbook
  • XLSX Excel Workbook
  • XLSM Macro Enabled Excel Workbook
  • XLA, XLAM Excel Add-ins
  • XLTX Excel Templates
  • XLTM Excel Macro Enabled Templates
xlCompare doesn't require any additonal steps to integrate into GIT(SVN) environment. You should not create and setup BAT files. Just open options and configure external diff viewer.
1 Open Settings(Options) for your GIT(SVN) application and find a page to configure external diff viewer
2 Specify xlCompare.exe as a diff and merge tool for the excel file formats (XLS, XLSM, XLSX, XLA, XLAM, XLTS, XLTM)
In these 2 simple steps you integrate xlCompare into your source code control system.
Need our help in integration?

The most recently used command line options to compare two excel files

xlCompare supports Command Line options offered by all, the popular GIT and SVN applications

xlCompare.exe [file-mine] [file-base]

xlCompare.exe /mine:[file-mine] /base:[file-base]

xlCompare.exe /1:[file-mine] /2:[file-base]

Open 2 files - MINE and BASE in xlCompare, compare and display difference report

xlCompare.exe [file-mine] [file-base] [file-their]

xlCompare.exe /mine:[file-mine] /base:[file-base] /their:[file-their]

xlCompare.exe /1:[file-mine] /2:[file-base] /3:[file-their]

Open 3 files - MINE and BASE and THEIR in xlCompare and perform 3-way comparison

Additional Command Line Options:

Use these commands if the options specified above doesn't cover all your needs

If you need to perform more complex actions in your source control system, please, use the options below. With them you can test the changes made before committing your workbook. This should keep you safe from errors in data and formulas, which could produce a big lossed for your company. Make your commits risk-free!

/merge

Open workbooks and perform automatic merge. In case of conflicts merge operation fails and you get conflict list on the screen.

/console

Work in the console mode without interface.

/testConflicts

Test passed workbooks for possible conflicts in the merge operation.

/titleMine:[title string]

/title1:[title string]

Use this title instead of path to the MINE workbook. You can use this option in order to specify alternate path. When file was downloaded from repository into temporary folder, this option allows to display "readable" file name.

/titleMine:[title string]

/title1:[title string]

Use this title instead of path to the MINE workbook. You can use this option in order to specify alternate path. When file was downloaded from repository into temporary folder, this option allows to display "readable" file name.

/titleBase:[title string]

/title2:[title string]

Use this title instead of path to the BASE workbook. You can use this option in order to specify alternate path. When file was downloaded from repository into temporary folder, this option allows to display "readable" file name.

/titleTheir:[title string]

/title3:[title string]

Use this title instead of path to the THEIR workbook. You can use this option in order to specify alternate path. When file was downloaded from repository into temporary folder, this option allows to display "readable" file name.