The tool is called "Spreadsheet compare" only available with Office Professional Plus 2013, Office Professional 2016, or Office 365 Pro Plus. Although the tool is intended for complex Excel spreadsheets, it comes very handy for text. Find, for instance, deleted rows, added rows, changed values, etc.
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
You're welcome, Paul!
The Sourceforge app is something else, whereas the Microsoft Office app is installed by default in a folder called "Microsoft Office Tools". It would be a matter of personal taste to choose either one. The Microsoft Office tool displays the results in a dashboard with all the information neatly arranged in one place.
Hi Paul (pfilkin) and Ozzie O (OswaldoOspina C)
Just to share another solution, I use the app WinMerge with the xdocdiff Plugin
Not only Excel, but various file formats can be compared.
Jesse and Ezven,
The interesting thing about this tool (Spreadsheet Compare) is that it was not created primarily with the purpose of processing text. Excel, as we know, is a great tool for crunching numbers big time (statistics, finance, you name it) and processing text is sort of a byproduct. However, I know for a fact, that for text processing (i.e. string manipulation) Excel is very powerful with all the text formulas at your disposal plus the power of VBA.
Follow-up. In the Office 2016 version of Excel you can get to this feature like this: File / Options/ Add-ins / Manage COM Add-ins / Check "Inquire" box. Then, back on the Ribbon, select Inquire and then "Compare Files".
Translate
