Is there a good way to track changes in Excel sheets in GIT repo?

Question

I have tried the solutions provided in How to perform better document version control on Excel files and SQL schema files, but I was unable to find a good solution for unzip the files to see the changes which can be tracked by Git. I have been using Git for a while and wanted to know if there is a good and fairly simple way to tracks the changes being made. Excel is being used in JAVA framework.

Answer 1

You can use Git hooks with a little help of something like Python to automatically export your VBA code and track it with Git. For a detailed walk-through, see this blog post.

Nowadays you can also use the open-source Git extension Git XL that allows you to see the diffs on the command line. It also integrates with Atlassian's free SourceTree tool, see this blog post for a detailed walk through on how to set everything up.