The following assumes that the information in your Excel files is (at least partly) organized as tables. Selecting Rows or Columns (vertical=rows, horizontal=columns) indicates your file is indeed organized as tables. This is used to decide if rows (or columns) have shifted because of an added extra line. As a result the table properties group becomes visible. Supplying the correct values in this group will enable the comparison process to give better information. Instead of simply returning any cell with a different value, it can now also tell that some lines were added (or removed).
If we press now [Compare] we get much more useful reports (as compared to Comparing Excel files using ranges). The Analysis Report reduced the information to 4 lines. The Visualization Report shows the original data in the table and what the changes are. Added rows have a blue mark. Removed rows a red mark. Changed values show the previous value in yellow.
Rows 1 - 77 ( - Row added - Row removed)
|1||Product ID||Product Name||Quantity Per Unit||Unit Price||Units In Stock|
|2||1||Chai||10 boxes x 20 bags||18||39|
|3||2||Chang||24 - 12 oz bottles||20 19||17|
|4||3||Aniseed Syrup||12 - 550 ml bottles||10||13|
|5||4||Chef Anton's Cajun Seasoning||48 - 6 oz jars||22||53|
|6||5||Chef Anton's Gumbo Mix||36 boxes||21.35||0|
|7||6||Grandma's Boysenberry Spread||12 - 8 oz jars||25||120|
|8||7||Uncle Bob's Organic Dried Pears||12 - 1 lb pkgs.||30||15|
|8||8||Northwoods Cranberry Sauce||12 - 12 oz jars||40||6|
|9||9||Mishi Kobe Niku||18 - 500 g pkgs.||97||29|
|10||10||Ikura||12 - 200 ml jars||31||31|
|11||11||Queso Cabrales||1 kg pkg.||21||22|
Note: differences between rows / columns in the order in which they are placed are ignored (considered inessential).
|Tutorials on comparing spreadsheets|