How to compare Excel files

Question

How Can I compare large excel files?

Suppose I have two exports of a database table (acceptance and production) with columns identifiable as key columns.

Now I want to compare two files and check:

• If some entries are missing in either file (compare if full key exists in both files)
• Check if the content of each line is the same (if the key matches then check if the other cells are also the same

I think about writing a small Java tool or macro if nothing like it exists.

Answer 1

You could use Microsoft's Spreadsheet Compare:

You can use Spreadsheet Compare to compare two workbooks (or two versions of the same workbook) and see differences between the workbooks. You can also identify potential issues, such as changes in formulas or calculations, or manually entered values.