Compare Two Excel Files
Compare two Excel files by a key column and see added, removed and changed rows and cells. Free, runs in your browser, no upload.
How to use the Compare Two Excel Files
Compare two datasets and see what was added, removed or changed.
- Load dataset A and B
- Pick or type the key column
- Review and download the differences
Tips
- A key column (like id) matches the same record in both files. Click Use first column as key, pick columns, or type their names.
- If you choose no key, the first two columns of the files are used as the key.
- Numbers match by value, so 36 and 36.0 are treated as equal.
- Use “Ignore case” or “Ignore spaces” to skip trivial differences.
Example
Input: before.xlsx + after.xlsx, key = id
Output: Added 3 · Removed 2 · Changed 5
Frequently asked questions
How do I compare two Excel files?
Load both .xlsx files, choose a key column such as id and review the differences.
Which sheet is compared?
The first sheet of each file is read.
Can the files be different formats?
Yes. A can be a CSV and B an Excel file. Columns are matched by name. JSON and Parquet files are not supported here, so convert them to CSV first.
Guides