This task can be performed using Sheetmatcher
The easiest tool to compare Excel files.
Best product for this task

Sheetmatcher
accounting
One crucial yet often underestimated task is comparing two Excel files. It can take a lot of time depending on your skills and the complexity of the files. With Sheetmatcher you don't need to know any Excel formula: just drag and drop 2 files and you are done. You will instantly know about any differences or missing records. If columns or records are sorted differently is not a problem!

What to expect from an ideal product
- Drag and drop two Excel files into Sheetmatcher to start comparing them
- Automatically detects matching columns even when sorted differently
- No Excel formulas needed, just import your files and see results
- Quickly spots differences and missing records between spreadsheets
- Works regardless of row order or column arrangement in both files