Sheet Comparator (Current Version 1.9a)
Excel Sheet Comparator is cross platform (Windows, Mac OSX) tool that allows comparison of two excel files. This already sets it apart from many other tools that work only on windows. besides, it doesn't need installation and allows to quickly merge two different files.
Donations serve to support costs with website hosting and with financing the development of other tools. The excess will be sent to non profit and community organisations.
Version 1.9a (02 December 2018)
Fixes on the annotations with sheet headers are selected
Allowing the comparison of All sheets with a primary key.
Version 1.9 (13 October 2018)
Comparing Formulas will also compare texts.
Version 1.8a (24 January 2018)
Fixing problem when opening for the first time.
Version 1.8 (15 December 2017)
Formula Compare and Sync Browsing by default
Version 1.7b (19 November 2017)
Minor correction in the Sync Navigation
Version 1.7a (08 October 2017)
Double click in Diff sheet zooms to the source Cell
Version 1.6 (24 August 2017)
Improved Difference Browser (Log)
Sync Navigation and Update Sheets
Version 1.5d (05 June 2017)
Selecting open files is made easier.
Version 1.5c (25 May 2017)
Reporting Excel and OS running versions
Supporting both Filenames with spaces and without spaces. The former version had problems with it.
Comparing multiple Sheets, Bug Fixes and new Interface
Fixed all the corruptions made from the Mac to Windows transfer.
Comparison of Formulas
Navigating differences using Report View
Detection of Table Size
Also works on Mac
You are like me and using Excel for everything, you've probably came across the problem of: How to compare two excel sheets ?
In the absence of a good available solution, I decided to make one.
Please find it in attachment. It's still the first version and it's still missing some features, but already does the job.
The current limitations is that it doesn't detect inserted or deleted rows or columns. This I'll add in a next version.
So, next time you need to compare two excel sheets, I hope this will serve you well.
The tool compares two tables, annotating the different cells with either :
- Annotating a given column
- creating a Report sheet
I'd love to hear your comments if you have some.
Take good care and happy comparing :-)