v3

Clean up one spreadsheet or compare two, right in your browser

1

Upload

XLSX / CSV supported

2

Match columns

Pick the key and columns

3

Compare

Differences highlighted

4

Export

Excel or CSV report

Tip: To tidy up one spreadsheet or compare two of its columns, just upload File A and continue. To compare two spreadsheets, upload both File A and File B. No files at hand? Try the example below.

Main spreadsheet / File A (required)

Click to choose a file (.xlsx, .xls, .csv)

Choose file

Compare with / File B (optional)

Only needed to compare two files. Skip it to tidy one file.

Choose file

Why use Excel Studio & Diff Pro?

Spreadsheets hold the stuff that matters at work: sales numbers, customer lists, stock counts, project trackers. But when you get "version 2" of a file and need to know what changed, Excel doesn't make it easy. You end up scrolling two windows side by side and hoping you didn't miss a row. This tool does that checking for you in a few clicks. It can also tidy up a single messy file: stray spaces, duplicate rows and inconsistent capital letters.

1. Your data never leaves your computer

Everything runs in your browser with JavaScript. Your files are never uploaded to any server, so it's safe to use with customer lists, salaries or financial data.

2. Matches rows by key, not by position

Pick a key column such as Employee ID, email or SKU. Even if the rows are sorted differently in each file, the tool lines them up by that key and shows exactly which values changed and which rows exist in only one file.

What it can do:

Pairs columns for you
Columns are paired by name, even when the order, capital letters or spacing differ. Renamed columns can be paired by hand.
Compare your way
Ignore extra spaces or capital letters, and round numbers to 2 decimals or whole numbers so tiny differences don't count.
Warns you about traps
Duplicate keys, empty keys and columns that exist in only one file are listed above the results, so nothing is dropped silently.
One file: tidy it or compare two columns
Trim spaces, remove duplicate rows and fix text case. Or pick two columns and see which values are missing from the other, with duplicates removed first or counted.
Smart filters
Switch between "all", "differences only" and "missing rows", and search by keyword.
Export a report
Download Excel or CSV, either everything or just the problem rows, with a column that names what changed.

How to compare two Excel files

  1. Upload the original file as File A and the new version as File B (.xlsx, .xls or .csv). Or click "Try with example files".
  2. Check the key column in each file (for example, Employee ID). The tool picks one for you when it can.
  3. Check the column pairs. If a column was renamed in File B, choose its new name on the right.
  4. Pick the compare options, then click "Compare". Changed values are highlighted in yellow, and a note shows how many changes each column has.
  5. Filter to "Differences only", then export the report to share with your team.

How this tool was tested

Before this version (v3) went live, I ran 51 automated checks on the publish version of this page, in a Chromium-based browser at phone width. Last full test run: 18 October 2026.

What the checks cover: comparing two files by key (the test data has 12 rows: 6 identical, 3 changed and 3 missing, and the tool has to report exactly that), matching columns by name, the tidy-up options, comparing two columns in one file, and the language switch.

Problems found and fixed: a second review pass on 18 October found 15 problems, and all 15 were fixed before v3 went live. Files are read cell by cell, dates follow the Excel serial number so time zones cannot shift them, and CSV files are read as text so leading zeros stay.

What to keep in mind: only the first sheet is read, and the checks use small example files. Look at a few highlighted rows yourself before you send a report to someone. Found a problem? Tell me on the Contact page.

FAQ

Is it really free?

Yes. No sign-up, no limits, no watermark.

Are my files uploaded anywhere?

No. The files are read by your own browser. Closing the tab clears everything.

Do the two files need the same column order or names?

No. Rows are matched by the key column, and columns are paired by name, ignoring capital letters and spaces. If a column was renamed, pair it by hand in step 2.

Can I compare two columns in the same file?

Yes. Upload only File A, choose "Compare two columns" and pick the two columns. "As two lists" shows which values are missing from the other column, whatever the row order. "Row by row" checks each row. You can remove duplicates first, or keep them so a value that appears more often in one column counts as a difference.

What if the same key appears more than once?

The tool pairs rows with the same key in the order they appear and lists those keys above the results, so you can check them by hand.

Why is 5200 the same as 5200.00, but 007 not the same as 7?

Plain numbers are compared as numbers. Codes with a leading zero, such as 007, are treated as text, because the zero usually matters. CSV files are read as text, so leading zeros are kept.

Which sheet is used if my file has several?

The first sheet. Move the sheet you want to the front, or save it as its own file.

Is there a size limit?

No fixed limit. 20,000 rows take a few seconds on a normal laptop. The results table shows the first 500 rows; the download always has every row.