There is really no easy way to compare two microsoft excel sheets. You have to create complicated lookups to do some sort of comparison. Compare Sheets solves that problem.
Compare Sheets is a freeware to compare Microsoft Excel sheets. It can do comparison of two microsoft excel sheets, and show the results of comparison in another sheet. A great feature of this software is that to compare microsoft excel sheets, you do not even need microsoft excel installed on your system. This free software can directly read microsoft excel sheets, and prepare the comparison results sheet. You can even open the comparison results sheet in this free software itself, so you don’t need Microsoft Excel to see the results of comparison.
To start comparison of Microsoft excel sheets, specify path of both the sheets in Compare Sheets. After that, you need to specify a reference column for comparison. This is the column which uniquely identifies rows in each sheet, and this column will be used to compare rows. For example, if you are trying to compare employee data in 2 sheets, employee number or employee name can be used as reference column.
Once you have specified the reference columns, Compare Sheets will prepare the results sheet which will show the rows from first sheet which do not have a match with second sheet. Compare Sheets is completely free to use, and works well. Download using links at that end.