Tortoise svn diff for excel files

Question

I was pleasantly surprised to find that Tortoise svn diff lets me find the diff between two excel files. The cell which is different is highlighted in red. It works for small excel files.

But I have excel sheets which have thousands of rows and quite a few columns. Is there a way to quickly find the cells that have changed (as opposed to scrolling through each sheet slowly and finding the highlighted cells, which is time-consuming and error-prone)?

Answer 1

To use this with Tortoise Diff you will need to export them both to CSV and diff the files, not the most ideal but helpful. If you have Office Professional Plus 2013 or Office 365 ProPlus you can use Excel Compare feature. There are other methods, which would likely be unwieldy with such large files, and third party tools, described here.