By Björn Stiel, CTO at Zoomer Analytics (Mar 23, 2018)
Making Git work with Excel workbook files requires quite a bit of plumbing. Git-xltrail is our new, free open-source Git command-line extension that makes Git undestand Excel workbook files out of the box.
By Björn Stiel, CTO at Zoomer Analytics (Jan 26, 2018)
Git repositories can become big and bloated over time when versioning Excel workbooks. Big repositories mean slow cloning and fetching. Git Large File Storage (LFS) is an open-source Git extension that replaces large binary files with text pointers making it easier to keep your repository at a manageable size. This is a hands-on guide to get you up and running with Git LFS.
By Björn Stiel, CTO at Zoomer Analytics (Jan 5, 2018)
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.
By Björn Stiel, CTO at Zoomer Analytics (Dec 15, 2017)
Getting started with Git and Excel is the first part of a series of blog post to help you using git for Excel version control. In this post we discuss how to set up gitignore to exclude temporary Excel from being committed.
By Björn Stiel, CTO at Zoomer Analytics (Dec 1, 2017)
Exporting your VBA modules into stand-alone .bas files is a simple and effective way to version control your Excel VBA code using git. This guide explains how to use Git hooks to automatically export your workbook’s VBA code when committing your change to Git.
By Björn Stiel, CTO at Zoomer Analytics (Nov 20, 2017)
Git is the best choice and a de facto standard for most software teams today. 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.