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.
Downloads
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.
Supported Organizations:
Version HistoryVersion 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 Bug Fixes 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 Version 1.5b Bug Fixes Version 1.5a Supporting both Filenames with spaces and without spaces. The former version had problems with it. Version 1.5 Comparing multiple Sheets, Bug Fixes and new Interface version 1.4 Fixed all the corruptions made from the Mac to Windows transfer. version 1.3 Comparison of Formulas Navigating differences using Report View Stability Fixes version 1.2 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. https://www.youtube.com/watch?v=H3L20YMv_XI 
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 :-) | ||||