Compare Two Excel Files Members

Compare two Excel files or sheets cell by cell and see changed cells, added rows and removed rows in color.

This tool is available to registered members

Create a free account or sign in to use this tool. Registration is free and takes less than a minute.

Your data is processed in your browser and is not uploaded to our servers.

About the Compare Two Excel Files

Compare Two Excel Files reveals the differences between two versions of a spreadsheet. Compare cell by cell by position, or match rows on a key column (such as an employee ID) to find added, removed and changed rows even when their order changed. Results appear in a color-coded table with a summary, and you can download the difference report as an Excel file.

How to use the Compare Two Excel Files

  1. Drop the first (old) file, then the second (new) file.
  2. Choose the two sheets, the comparison method and a key column if you want one.
  3. Click "Compare" and review the differences or download the report.

Frequently asked questions

When should I use a key column?

When the row order changed or rows were inserted in the middle. A key column matches rows by its value instead of their position.

Are formulas or results compared?

The values shown in the cells are compared, that is, the results of formulas.

Are my files uploaded?

No. The comparison runs in your browser.