ToolXkit Icon

Compare Excel Files Online

Find every changed cell, added row and deleted row between two spreadsheets, even when the rows have been re-sorted. Works with XLSX, XLS, ODS and CSV, and your data never leaves your device.

  • Free
  • No signup
  • Nothing uploaded
  • No watermark

Original

Drop a file here

Excel or CSV file · read on your device, never uploaded

Changed version

Drop a file here

Excel or CSV file · read on your device, never uploaded

Both files are read on your device. Neither is uploaded.

How to Compare Two Excel Sheets Cell by Cell

Compare Excel Files Online: before and after XLS A BEFORE COMPARE EXCELFILES XLS A AFTER

Two copies of the same price list, stock sheet or marks register are on your desk. One has been edited, and nobody wrote down what changed. Flicking between tabs to check hundreds of rows by eye is how errors get past you.

This tool lines the rows up and then checks cell against cell. Pick a key column, such as an employee ID or invoice number, and rows are matched on that value wherever they sit, so a sorted copy still compares cleanly. The result counts changed cells, added rows, removed rows and identical rows, and marks each changed cell with its old and new value.

The workbooks are opened on your own computer. Salary sheets, customer lists and accounts are not copied to a server just to be compared.

No software to install Free Works on any device

Spot Spreadsheet Changes in Six Steps

Follow along in the comparer above.

  1. 1. Open Compare Excel Files

    You will find the comparer above this guide, and it needs nothing but an up-to-date browser. A computer screen gives the result table the most room.

  2. 2. Add the original workbook

    Under Original, choose the older file. XLSX, XLS, ODS and CSV are all accepted. When a workbook holds more than one tab, a Sheet menu lets you choose which to use.

  3. 3. Add the changed workbook

    Under Changed version, choose the newer file and pick its sheet in the same way. The two files do not need to be the same format; an XLSX can be compared with a CSV.

  4. 4. Decide how rows are matched

    In "Match rows by", keep Position in the sheet when rows stay in order, or pick a column holding a unique value for each row. The column list comes from the header row of the original.

    Good key columns:

    • Employee or student ID
    • Invoice or order number
    • Product code or SKU
    • Email address

  5. 5. Set what to ignore

    Capital letters and extra spaces are ignored from the start, and only changed rows are shown. Untick any of these in the settings column if you need a stricter check.

    Ignore capitalsHide whitespace changesHide unchanged lines

  6. 6. Press Compare sheets

    Totals appear for cells changed, rows added, rows removed and rows identical, with a table below. To keep a copy, press Export report for an Excel file listing every difference.

No .xlsx file to hand? Download a sample Excel file (21.6 KB) and try it.

Try it now

What is an Excel Comparison?

An Excel comparison checks two versions of a sheet and reports what differs. A simple line-by-line check fails here, because inserting one row near the top shifts everything below it and makes the whole sheet look changed. This tool aligns rows first, either by a key value or by finding the rows that still match, and only then compares cells.

Values are compared as you see them in the sheet. That means a changed price, name or date is caught, while cell colours, fonts, borders and comments are not part of the check.

Excel Workbook

.XLSX

Two versions of a table, compared row by row and cell by cell.

Sheets people compare

  • Price lists and rate cards
  • Stock and inventory counts
  • Employee and payroll lists
  • Marks and attendance registers
  • Bank statement exports
  • Monthly sales reports
  • Customer and mailing lists

Why Compare Spreadsheets Automatically?

A single wrong figure in a price list or payroll sheet can cost real money, and it hides easily among thousands of cells. An automatic comparison checks every one of them in seconds and shows only the handful that moved.

“Thousands of cells in, the three that changed out.”
  • Every changed value found
  • Deleted rows flagged
  • Seconds instead of hours
  • A report you can send on
  • New rows listed separately
  • Works on re-sorted data
  • Fewer costly mistakes
  • Business data kept local

Common Jobs for Excel Compare

Situations where comparing two sheets saves the most time.

  • Supplier price updates See which item prices went up or down between last month’s rate card and this one.
  • Stock reconciliation Match a system export against a physical count by product code and list the gaps.
  • Payroll checks Compare this month’s salary sheet with last month’s by employee ID before it is paid.
  • Marks corrections Confirm which student marks were changed after re-evaluation, by roll number.
  • Bank reconciliation Compare a ledger export with a bank statement export to find missing or altered entries.
  • Contact list clean-up Find who was added to or removed from a customer or member list.
  • Data export checks Verify a new report or script produces the same output as the old one.
  • Shared file edits Work out what a colleague changed in a workbook you both edit.

Compare Excel Features

Made for tables, not text, so it reports what really moved.

Matching

Key column matching

Match rows by an ID column so sorting, filtering or reordering does not produce false differences.

Alignment

Smart position matching

Without a key, inserted and deleted rows are detected so the rows below them still line up.

Detail

Cell-level highlights

Each changed cell is marked, and the report shows its old and new value together.

Sheets

Any sheet in a workbook

Pick one sheet from each file, and even compare a sheet against a differently named one.

Formats

Mix file types

Compare workbooks and plain data files in any combination.

Accepted:

  • .xlsx
  • .xls
  • .ods
  • .csv
Report

Export to Excel

Export report saves comparison-report.xlsx with one row per difference, ready to filter or share.

Why Use ToolXkit to Compare Excel Files?

Figures stay in-house

Salaries, prices and customer details are read locally. No copy reaches a remote machine.

Compare Excel for Busy Teams

Accountants

Reconcile ledgers, statements and client figures quickly.

HR and payroll

Catch salary and headcount changes before they are processed.

Store and warehouse staff

Compare stock counts against system records by item code.

Teachers

Check marks and attendance changes by roll number.

Analysts and developers

Verify that data exports match after a change.

Small business owners

See what changed in price lists from suppliers.

When to Compare Excel Sheets

A comparison pays off when you are:

  • Checking a new supplier price list
  • Approving a payroll sheet
  • Reconciling stock with a count
  • Matching a ledger with a bank export
  • Verifying revised marks
  • Reviewing a colleague’s edits
  • Testing a changed report
  • Cleaning up a contact list

Tips for Reliable Sheet Comparison

  1. Use a key column whenever the rows might have been sorted or filtered differently. Position matching assumes the same order.

  2. Keep column headings in row 1 of both sheets. It is used as the header and is not counted as data.

  3. Pick a key whose values are unique. If two rows share an ID, only one of them can be matched.

  4. For very large sheets, choose a key column. It is much lighter on memory than matching by position.

  5. Untick Ignore capitals when case matters, such as for product codes or reference numbers.

  6. Check the Sheet menu on both sides. A workbook opens on its first sheet, which may not be the one you meant.

  7. Export the report before you fix anything, so you keep a record of the original differences.

Frequently Asked Questions

Answers to common questions about this tool.

How do I compare two Excel files for differences?

Put last month’s workbook in the Original box and the edited copy in the Changed version box, pick the sheets, choose how rows are matched, and press Compare sheets. You get counts of changed cells, added rows and removed rows, plus a table highlighting each change.

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

Set "Match rows by" to a column that holds a unique value for each row, such as an ID or invoice number. Rows are then paired on that value wherever they appear, so sorting makes no difference.

Can I compare two Excel files without Microsoft Excel?

Yes. The files are read in your browser, so you do not need Excel or Office installed. XLSX, XLS, ODS and CSV files all work, on Windows, Mac, Linux or a Chromebook.

Does it compare formulas or just values?

It compares the values shown in the cells. If a formula changed but gives the same answer, it will not be flagged. A different result from a formula is reported like any other changed value.

Are cell colours and formatting compared?

No. Fill colours, fonts, borders, comments and column widths are not part of the check. Only the contents of cells are compared, which is what matters for most price lists and registers.

Can I compare two sheets in the same workbook?

Yes. Choose the same workbook on both sides, then pick one sheet in the Original Sheet menu and the other sheet in the Changed version menu.

Can I compare an Excel file with a CSV?

Yes. Each side accepts XLSX, XLS, ODS or CSV, and they do not have to match. This is handy when one version came from a system export and the other was edited in Excel.

Is my spreadsheet data uploaded anywhere?

No, it is not. Both workbooks are read and matched up inside this tab. ToolXkit never receives a single cell, so payroll, pricing and customer data stay private.

How do I save the list of differences?

Press Export report in the settings column. It downloads comparison-report.xlsx, with one row per difference showing whether it was changed, added or removed, the key value, and old and new values side by side.

Why is every row showing as changed?

The rows are probably in a different order and are being matched by position. Choose a key column in "Match rows by". Also check that you picked the right sheet on each side.

How many rows can it compare?

We do not set a row limit; your device’s memory does. Matching by a key column handles large sheets well. Matching by position on two very long sheets needs much more memory, so use a key for those.

Does it ignore extra spaces and capital letters?

Yes, from the start. "Ravi Kumar " and "ravi kumar" count as the same. Untick Ignore capitals or Hide whitespace changes if you need an exact match.

Is Compare Excel Files free, and do I need an account?

Yes. It costs nothing, and there is nothing to sign up for. Open the page, add your two files or paste two blocks of text, and the differences appear. There is no trial period and no limit on how often you compare.

Can I compare two different formats, like a PDF and a Word file?

Each compare tool is built for one kind of file, such as PDF, Excel, JSON or plain text. To compare across formats, convert one of them first, or copy the text of both into Compare Text.

Further reading

  • Spreadsheet A general introduction to spreadsheet programs and grids of cells.
  • Office Open XML The format behind .xlsx workbooks.
  • RFC 4180: CSV The common definition of comma-separated values files.

More Compare Tools

Other free tools for the same kind of job.

Browse all tools