Tutorial: Comparing Two Excel Files For Different Cell Values
This method is useful for comparing two excel or spreadsheets such as .csv files for different values.
If you are familiar with using Excel formulas you shouldn’t have any problems using this method to compare cell data in two spreadsheets.
We use this technique for tasks such as identifying products in an ecommerce store like Magento that need updating to a new value.