Skip to main content
Preparing workspace

Compare Excel Files

Compare two Excel or CSV files in your browser: changed cells highlighted, added and removed rows matched by a key column, diff saved as XLSX or CSV.

Still loading. If the tool doesn’t appear, reload this page.

Planned features and workflows

Upcoming additions related to this tool. Open a plan to see its scope. These features are coming soon.

About this tool

Compare Excel Files

Compare two Excel or CSV files cell by cell in your browser: changed cells highlighted, added and removed rows matched by a key column, and the diff exported as XLSX or CSV.

Comparing two Excel files means finding every cell whose value differs and every row that exists in only one file. This tool pairs rows by a key column such as an ID (or by position), pairs columns by header name, shows each changed cell as old → new, counts the changes and exports them — without uploading either file.

How to use Compare Excel Files

  1. 1

    Drop the original on File 1 and the newer version on File 2 (Excel .xlsx, .xls, .xlsb, .ods or CSV); pick a Sheet if a workbook has several.

  2. 2

    Under How to match rows, keep the detected Key column or choose one, or choose None to compare row 5 with row 5; set Ignore extra spaces, Ignore upper/lower case and Compare numbers by value.

  3. 3

    Read the counts of changed cells, changed, added, removed and unchanged rows, and use the Changed, Added and Removed filters on the differences table.

  4. 4

    Press Download report (.xlsx) for Summary, Differences and Changed cells sheets, or Differences (.csv).

Why use Compare Excel Files

  • Rows matched by key

    A row that moved, or that has rows inserted above it, is still compared with the same record, so one insertion does not flag every row below it.

  • Excel against CSV

    Mix formats: Excel cells are read as their stored values (dates as ISO 8601, numbers to 15 significant digits) and CSV cells as written, so a CSV holding the same raw values matches the .xlsx.

  • Private by design

    Both files are read and compared inside your browser tab and never uploaded.

Common use cases

  • Check what changed between this month's and last month's price list or stock report.
  • Reconcile an exported customer list against a CRM export by email or customer ID.
  • Review a colleague's edits to a shared spreadsheet before you accept them.

Frequently asked questions

How do I compare two Excel files for differences?

Load both files here and choose a key column such as an ID. Every changed cell is highlighted as old → new, rows found in only one file are listed as added or removed, and you can download the result as an .xlsx report or a CSV.

How do I compare two Excel sheets when the rows are in a different order?

Pick a key column with a unique value per row, such as an order number, SKU or email. Rows are then paired by that key wherever they sit, so sorting or inserted rows do not show up as changes.

Can I compare an Excel file with a CSV file?

Yes. Each side can be .xlsx, .xls, .xlsb, .ods or .csv. Excel cells are read as stored values, with dates as ISO 8601 (2025-12-31); CSV cells are compared as written, so a CSV that stores 31/12/2025 or 1,234.50 shows those cells as changed. With Compare numbers by value on, 5.50 and 5.5 count as equal.

Does it highlight the differences in the downloaded Excel file?

Not with colours. The report marks each row's status (Changed, Added or Removed) in its own column, writes changed cells as old → new, and lists every changed cell on a separate sheet, which survives sorting and filtering better than fill colours.

Does it compare formulas or values?

Values: each formula cell is compared by the result saved in the file. A formula with no saved result, which is common in files written by openpyxl or pandas, is compared by its formula text instead, so different formulas never count as a match, and the page says how many cells that affects.

What if the columns are in a different order?

With First row is a header ticked, columns are matched by their header name, so a column moved from C to F is still compared. Columns present in only one file are named in the summary and not counted as changed cells.

How large can the files be?

Up to 100,000 rows (header included) and 2,000,000 cells per file, and 50 MB per file. Larger files get a message instead of a partial result; split them with Split Excel or Split CSV and compare the parts.

Embed this tool on your site

Add the Compare Excel Files widget to your blog or website — free, responsive, no signup. Just keep the “Widget by AltFTool” credit link visible.

<iframe src="https://www.altftool.com/embed/widget/compare-excel-files"
  title="Compare Excel Files — free AltFTool widget"
  width="100%" height="640" style="border:0;border-radius:12px;overflow:hidden"
  loading="lazy" referrerpolicy="no-referrer-when-downgrade" allow="clipboard-write"></iframe>
<p style="font-size:12px;margin:4px 0 0">Widget by <a href="https://www.altftool.com/tools/all/compare-excel-files?utm_source=embed&utm_medium=widget" rel="nofollow">AltFTool — free online tools</a></p>

Browse all embeddable widgets →