March 23, 2018
Git-xltrail: An open-source Git command-line extension for Excel files
January 26, 2018
Git can be tweaked to make it play nicely with Excel workbook files (that is, to be able to show diffs). Pre-commit hoooks can be set-up to automatically export the workbook’s VBA code as stand-alone .bas files on each commit. And Microsoft’s Spreadsheet Compare can be used as a custom differ for Excel workbook file changes.
Quick Guide: Git Large File Storage (LFS) for Excel
January 05, 2018
As a distributed version control system, Git always copies down the entire repository history to the client when you do a git clone or git fetch. For repositories containing large files and/or long commit histories, this clone process can take a long time, as every file version that ever existed has to be downloaded.
3 steps to make Spreadsheet Compare work with git diff
December 15, 2017
For Git, Excel workbooks are just binary files. This means they cannot be diffed via git diff. In this blog post, we hook up Microsoft Office’s Spreadsheet Compare to git diff to create meaningful workbook comparisons.
Getting started with Git and Excel: Set up gitignore
December 01, 2017
By default, Git sees every file in your working directory. This has the ugly side effect that sooner or later you end up with a temporary Excel file under version control.
How to use Git hooks to version-control your Excel VBA code
November 20, 2017
Exporting your VBA modules into stand-alone .bas files is a simple and effective way to make Git aware of code inside your Excel workbooks. The goal is to end up with a separate .bas file for each of your VBA modules so that you can benefit from the Git functionalities.
Git workflow for Excel
November 11, 2017
This guide presents a simple recipe for how to use Git for Excel workbooks to support small Excel teams in their existing workflow and simplify collaboration.
xlwings is now on xltrail!
Our most popular open-source project is clearly xlwings, an Excel add-in that allows you to
write user defined functions and macros in Python instead of VBA.