Some disappointments are familiar to every Excel user. You or your colleagues may enter incorrect values or even delete critical data by mistake. MS Excel Track Changes feature comes with limitations: history of changes is periodically deleted, it does not do backups and works only for shared workbooks. How can you protect data without piles of backup copies or complicated macros?
XLTools Version Control add-in solves these problems and keeps your data safe:
- Commit versions in a click and track changes to a workbook
- Compare versions and highlight changes
- Store versions safely in a Git repository on your own PC
- Review change log and recover any previous version at any time
- Collaborate in a group and track who changed what and when
You can also enable versioning of VBA projects in Excel.
Add "Version Control" to Excel 2019, 2016, 2013, 2010, 2007
Works in: Microsoft Excel 2019 – 2007, desktop Office 365 (both 32 bit and 64 bit).
Learn your way around:
- How to track changes in Excel with Version Control
- How to commit a version of Excel workbook to Change Log
- How to preview and diff recent changes before committing a version
- How to save Excel spreadsheet versions to Git repository
- How to open Change Log and see who made changes and when
- How to compare two versions of an Excel worksheet
- How to restore and roll back to a previous version of Excel workbook
- How to use Version Control for a shared Excel workbook
- How to enable Version Control for Excel VBA macros
How to track changes in Excel with Version Control
XLTools Version Control add-in for Excel workbooks is a revision control, or a source control tool. It helps track changes to Excel files and gives a clear picture of who, how and when modified the document.
-
Open a workbook > Click the 'Enable' button on XLTools ribbon.
Or: Open XLTools Settings > Version Control tab > Enable. - Next, you can commit versions of the workbook and track changes between versions.
How to commit a version of Excel workbook to Change Log
-
Make sure that Version Control is enabled:
Click the 'Enable' button on XLTools tab, or open 'Settings' > Version Control tab > Enable. - Click the 'Commit Changes' button > A dialogue box will open.
-
Add a descriptive comment to tell the versions apart, e.g. "Primary file" > OK.
Tip: before making changes, commit the original file to the Change Log. This will allow you to compare future versions with it, as well as restore the primary file if necessary. -
As you keep editing the workbook, keep committing versions to the Change Log as often as you find necessary:
Make changes > When ready, click 'Commit Changes' > Add a descriptive comment > OK.
Note: a version is only committed through the 'Commit Changes' button. If you simply save the file, the version is not committed to Change Log.
How to preview and diff recent changes before committing a version
- Make changes > Click 'Commit Changes'.
- To preview and diff changes, double-click on the modified worksheet.
- A new Temp workbook will open. The current and the newer versions are placed on separate tabs. The newer version has changes highlighted in red color.
- Review the result > Click OK to commit this new version, or Cancel to go back to editing the workbook.
How to save Excel spreadsheet versions to Git repository
All versions of a workbook, that were committed to the Change Log, are stored to the git-repository on your computer. Being a widely adopted system for revision control, Git accurately records all changes and does not take much of your disk space.
Immediately after you enable Version Control, a new Git repository folder 'WorkbookName_Revisions' automatically appears at the same destination folder as your workbook. This is the git-repository that safely stores all versions of the workbook.
Important: do NOT delete, rename or move this folder. Otherwise all versions history will be lost.
How to open Change Log and see who made changes and when
- Click the ‘Change Log’ button on XLTools tab > A window with all committed versions will open.
- Review the list of versions: it displays comments, author and the exact time of committing the version.
How to compare two versions of an Excel worksheet
- Click the ‘Change Log’ button > A window with all committed versions will open.
- Expand/ collapse the list to find the versions of the worksheet you want to compare.
- Select two Excel sheets holding 'Ctrl' key > Click the 'Show changes' button.
- XLTools generates a new Temp workbook. The sheet with the 'Newer' version has the changes highlighted in red.
How to restore and roll back to a previous version of Excel workbook
You can open any previously committed version of a workbook and save it as a separate file. This is a helpful Excel backup tool – at any time you can recall or roll back to an older version.
- Click the ‘Change Log’ button > Select the workbook version you want to restore.
-
Click the 'Save' button > Name and save as a separate Excel file.
Or: Click the 'Open' button to open the version first > File > Save as > Name and save the file.
How to use Version Control for a shared Excel workbook
XLTools Version Control add-in helps arrange group work and collaborate on shared spreadsheets effectively.
- Make sure that all your team members have XLTools add-in installed on their PCs.
-
Place the workbook in a shared folder in your network > Share the workbook with the team members.
Note: to commit versions, team members should have reading and writing permissions. This prevents anyone outside the group from editing the workbook under versioning. - Each member can commit and compare versions and view the Change Log.
How to enable Version Control for Excel VBA macros
VBA developers and Excel power users can also track and compare changes in VBA scripts.
Any questions or suggestions? Please leave your comment below.
Does XLTools track Userform code, modules, and formulas?
Hi Chuck, XLTools Version Control tracks changes to values in cells, i.e. the result of the formula, but not the formula itself. If by Userform code and modules you mean VBA code – then yes. Please see here.
if the formula is subscribing to a data stream (think Bloomberg formula), then even if the workbook structure hasn’t changed at all, xltools will think all the data cells have been changed – which would be a lot of noise and not so helpful
You are right, Dennis. At the moment Version Control registers changes to values. We plan to expand the comparison functionality to track changes to formulas as well. Thanks for confirming that this could be something useful!
If I am sharing an excel file with a team, does all team members need to have this add-in for us to see who was the last one to edit, and what was edited? Or since I am project lead, only I need to have the add-in?
Hello Thang! Yes, indeed, to see the change log and work with Excel files under Version Control, each team member should have an XLTools license.
Is it available for MAC?
Hello Amsal, no, XLTools is only available on Windows platform.
Under “How to use Version Control for a shared Excel spreadsheet” is says “Place the workbook in a shared folder in your network > Allow access to the group members.”
Is it possible to use a git repo like GitHub or Bit-bucket?
Hello JH, XLTools does not have this functionality yet. We’ve had a few similar requests, so we will consider supporting it in the next releases. Thank you!
Does this Add-In require that I save the file as a macro-enabled spreadsheet? (i.e. xlsm)
Hello Win,
If you have an xlsx workbook, and then enable Version Control – the file does not change its extension. The add-in does not require you to save it as xlsm. But you can also enable Version Control for xlsm files, and start tracking changes to your custom macro.
It appears that the add-in will not provide the sort of history across multiple versions that Excel’s native track changes provides, with notes on cells like ‘Changed on [date] from [value]’ since, if the add-in can only compare two versions at a time [date] would always be the date of the earlier version being compared. Is that correct?
Hello David, XLTools Version Control provides a different functionality compared to native Excel track changes. You can view the history of all saved versions (when and who made the changes, comments to these versions). You can compare two versions of a sheet at a time – Version Control will pull these two versions, mark them ‘Newer’ and ‘Older’, and it will highlight the cells in the Newer version that are different compared to the Older. You are most welcome to download XLTools and activate the free trial – it will take a few minutes and you can see if XLTools can be helpful with your tasks.
Second question. Let’s imagine this scenario: I create an excel sheet with my laptop where XLtool is installed. I then send this file to a person using a Mac who does not have XLtool on his computer.
As soon as this person sends the file back to me, can I still trace every single modification he/she made to the file?
Filippo, potentially this is possible. You can save the file you receive from your colleague and then save the latest version of the changes. Then you can compare the two versions – yours and the one from your colleague. Version Control will highlight the cells with changes.
Hello. Can be this used with Office 2016 for Mac?
Hello Filippo, XLTools is only compatible with Windows. We do not have current plans to develop a version for Mac.
If I use XLTools for versioning of a workbook on one computer that is saved to a USB drive, is the workbook still accessible on another computer that does not have XLTools? I am assuming that I can still modify the latest version on the other computer, but there would be no versioning history. Is that correct?
Hello John,
You are right. Version Control is only available if you have XLTools installed on your computer and after you activate your XLTools PRO license. You can still access your Excel workbook (with all the latest saved changes) from a computer without XLTools and work with the spreadsheet as usual, but you won’t be able to save or compare versions.
Is there a network/group floating license version of this tool?
Or is there any group purchase discount? (e.g. buying 20 individual license will get some discount)
Is there a distributed version control function? (e.g. central site version difference/revision check against the working copies outside of the central site)
Thanks,
Erin
Hi Erin,
For now, XLTools should be installed individually on each computer. We plan to create a corporate license version in the future.
One license copy is per user per computer. We do have volume discounts, I will send you the details by email.
Version Control is meant for team work – just share the workbook in Excel settings, and XLTools Version Control will help you can save, comment and compare versions with the original document of with each other.
Hey
I was wondering if this add-in is able to track changes in the VBA script?
Thanks for your help
Hi Oliver,
Right now we are expanding the functionality of the Version Control feature – so that it tracks macros’ history and highlights changes in VBA versions (similar logic as with spreadsheets). Oliver, we received an email request from you for a free trial – but I could not reach you (invalid email). Please provide a different email address and we will be happy to help!
Hi, I’m also interested in an add-in to track VBA code changes, please keep me informed, thanks.
Guido
Hi Guido, we are working on it at the moment. We will let you know when it’s released. Thanks for staying in touch!
got it, thanks
Quisiera saber si hay una version del instalador de XLTools compatible con Excel 2013 en español ya que la version en ingles no la puedo istalar en mi sistema pues no es compatible.
Hello, yes we support Excel 2013, but unfortunately we do not have Spanish version of XLTools yet.
Excel 2013 64bit too?
Yes, x64 is also supported.
Hi, I’m interested in using this for version control. Does it allow distributed revision control?
Our use case is 2-3 developers working on a spreadsheet made up of several pages. Often the spreadsheet is opened from it’s location on a shared network drive, minor changes made and sometimes the version number is not incremented.
This makes it very hard to track changes and also who made them. Ideally we would pull the spreadsheet to a working directory, do a diff and commit changes then push them to a master repository. Would it be suitable for this kind of workflow?
Would like to see an answer to this question. Distributed is what’s really needed in a case I am considering as well. Have many people working on one spreadsheet and need to have commits with users’ name and comments. Features like working copies, a central check-in site, and conflict management/resolution would be the best.
A work-around might be to have users log into the same remote machine, work on the single-copy worksheet there (one at a time), and then commit changes. Would that be a license violation?
How many licences would you need to buy – e.g. could I just buy one as the owner of the workbook or would we need a licence for everyone who accesses the sheet in order to track all changes?
Dear Chris,
You will need to install XLTools Add-In for everyone who accesses the worksheet, i.e. you will need to get as many licenses as many computers you and your colleagues have.
We are currently thinking about volume license discount, so please contact me if you want to buy few licenses. We can agree about special price for you depending on amount of users you have.