Saved

Press the star next to a tool's name to save it.

All my tools

Excel Compare Two Sheets

Excel compare two sheets online: choose two Excel or CSV files, and this tool lists each cell that differs, with its old and new value and a report you can download.

The first file is treated as the original. Sheets are matched by name, or compared directly if each file has one sheet.

Your files are read on this device and are never uploaded.

Different cells

–

Comparing…

Add two files and press Compare files.

When you need Excel compare two sheets to find what changed, checking by eye is slow and it's easy to miss something. Choose two workbooks or CSV files, and this tool will list every cell that differs, along with the value from each file. It's useful for finding what changed between two versions of a budget, a price list, a stock count or a report. You can download the results as a CSV file. Your spreadsheets are read in your browser, so they aren't sent to our server.

How to use Excel compare two sheets

  1. Choose two files. The first is treated as the original.
  2. Check the order, and swap them with the arrows if you need to.
  3. Set the options for capital letters and spaces.
  4. Press Compare files.
  5. Read the list of differences, or download it as a report.

What does it compare?

The tool compares the displayed value of each cell in the same position in both files. If cell C7 says 120 in the first file and 125 in the second, it's reported as a difference at C7. If one file has more rows or columns than the other, the extra cells appear as differences with one side blank. For workbooks with several sheets, sheets with matching names are compared with each other. Sheets that only appear in one file are named in the summary. If each file has just one sheet, the two are compared whatever they're called.

Excel compare example

Suppose that a price list is sent back to you with a few edits. Cell B4 has changed from 19.99 to 21.50, and D12 has changed from “In stock” to “Sold out.” The tool reports two different cells, showing the sheet name, the cell reference and both values. You can then check those two cells in the original file, rather than reading through hundreds of rows.

Other ways to compare in Excel

Microsoft offers a program called Spreadsheet Compare, which can report on the differences between two workbooks, including problems such as hand-typed totals and broken formulas. It's included only with certain versions of Office. Within Excel, you can also place two windows side by side with View Side by Side, or write a formula such as =Sheet1!A1<>Sheet2!A1 and fill it across a range. This online tool is a quick alternative when you only need to know which values changed, or if you aren't working on a computer with Excel.

Why a row added at the top causes many differences

Cells are compared by position. If somebody inserts a new row near the top of a sheet, every row below it moves down by one, and each moved cell may be reported as a difference. If you see an unexpectedly long list, check whether a row or a column was inserted or removed. Sorting both files in the same way, or deleting the extra row in a copy, usually brings the results back to a sensible size.

The options explained

Ignore capital letters treats “Paid” and “PAID” as the same value. Ignore spaces at the ends of cells avoids reporting differences that come from stray spaces, which are common in data pasted from other systems. Numbers and dates are compared as they appear on the sheet, so a value that's formatted differently may be reported even if the underlying number is the same.

Formulas and calculated values

This tool compares the values shown in cells, and not the formulas behind them. If two cells use different formulas but display the same number, they count as equal here. If you need to audit the formulas themselves, a dedicated tool such as Microsoft's Spreadsheet Compare is a better choice.

Working with CSV files

A CSV file is a plain text file with one table, so it behaves like a workbook with a single sheet. You can compare a CSV file with another CSV file, or with an Excel workbook that has one sheet. Long ID numbers and ZIP codes stay exactly as they are written in a CSV, which avoids the problem of numbers being altered during the comparison.

Are my files private?

Yes. The comparison happens on your own device. The contents of your spreadsheets aren't uploaded, which makes the tool suitable for payroll, financial and customer data. Password-protected workbooks can't be read, so remove the protection first if you own the file.

Getting a clean result

Keep the same column layout in both files where you can, and remove any blank rows or columns that were added by accident. If you only care about one part of a workbook, delete the other sheets from a copy before you start. Save your report with a clear name, so that you can show colleagues exactly which cells were changed and when you checked them.

Common mistakes

  • Comparing files that were sorted differently. Sort both first.
  • Putting the files in the wrong order. The first file is the original.
  • Expecting formulas to be compared. Only the displayed values are checked.

Combine workbooks with merge Excel files, change formats with the Excel converter, and understand a calculation with the Excel formula explainer.

What next

Use this often? Add Excel Compar to your Home screen.

Frequently asked questions

How does Excel compare two sheets work?

It reads both files in your browser and compares each cell in the same position.

Can I compare CSV files?

Yes. It accepts CSV, XLSX, XLS and ODS files.

Are my files uploaded?

No. They are read on your device.

Does it compare formulas?

No. It compares the values shown in the cells.

Why are there so many differences?

An inserted row or column shifts every cell after it. Check for one first.

What went wrong?

We only receive the reason you pick, never what you typed into the tool.

Thanks for your feedback.

More Office & Productivity Tools