Sheet Comparator (Current Version 2.4)
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.
File is zipped to avoid automatic rename to xlsx. The xlsm extension is needed to enable macros.
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 organizations.
Version 2.4 (05 January 2023)
Solving problem with sheet protections on Mac OSX
Version 2.3 (26 July 2022)
Version 2.2 (09 August 2020)
Paypal Link update.
Version 2.1 (13 June 2020)
Changing Layout of the Difference Sheet
Minor bug fixes
Version 2.0 (23 May 2020)
Multilingual Support (English, Français, Português, Español, русский, and Chinese)
Version 1.10a (20 May 2020)
Fixed bug on the sheet anotation when no headers are being used.
Version 1.10 (04 May 2020)
Fixed bug on the sheet anotation where the new and deleted items were annotated on the wrong cells.
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.
It compares tables, sheets and entire workbooks and reports the differences side by side. It can optionally annotate the modified cells with comments and highlight cells that were changed.
It also can be used to merge the two sheets.
There is a short Video tutorial in the link below.
So, next time you need to compare two excel sheets, I hope this will serve you well.
I'd love to hear your comments.
Take good care and happy comparing :-)