Skip to content

Compare two Excel files

Upload the old and the new version: changed cells turn yellow with the old value in a comment, added ones green, removed ones red.

FreeNo sign-upFiles deleted after 30 min
Choose files
or drop them here · .xlsx .xlsm .csv

Options

Header name or column letter. Without it, rows are compared by position.

How to compare two Excel files for differences

  1. Drop the two files: the old version first, the new one second (XLSX, XLSM or CSV).
  2. Optionally type the key column (for example ID) so rows are matched even if they moved.
  3. Click Compare and download the highlighted workbook with its list of differences.

A price list that changed “somewhere”, a budget sent back by a colleague, two exports of the same database a week apart: finding what changed between two spreadsheets by eye is slow and error-prone. This tool compares them cell by cell and gives you a workbook you can read in a minute.

The result has a first sheet, “Differences”, listing every change with its sheet, cell, old value and new value. The other sheets are copies of the new file where changed cells are yellow (the old value is in a cell comment), added cells are green and removed cells are red and struck through. Sheets that exist in only one file are reported as added or removed.

By default rows are compared by position, which suits files with the same structure. If rows were sorted or inserted, type the header of a key column (ID, SKU, email) or its letter: rows are then matched by that key, and added or removed rows are reported as such. Formulas are compared as written, so a formula that changed shows up even when its result did not. Up to 600,000 cells per sheet; files are deleted after 30 minutes.

Frequently asked questions

Which file goes first?

The old version first, the new one second. The result shows the new file with the differences marked, and the old values in comments.

My rows are sorted differently in the two files. Will everything show as changed?

Use the key column option: type the header of an ID column and rows are matched by that value instead of their position.

Are formulas compared?

Yes, as text. A formula that changed is reported even if it gives the same result; cached results are not compared.

Can I compare CSV files?

Yes, CSV with CSV or CSV with XLSX. Numbers in CSV are read as numbers so 1,234.50 and 1234.5 count as equal.

Is there a size limit?

600,000 cells per sheet and 300 MB per file. Both files are deleted from the server after 30 minutes.