Compare Excel Files and Extract Differences

Upload files

FILE A

Drop file A here

.xlsx / .xls / .csv / .tsv supported — or click to browse

Sheet:

Preview

FILE B

Drop file B here

.xlsx / .xls / .csv / .tsv supported — or click to browse

Sheet:

Preview

Select matching columns

Pick the header row, the key column (used to match rows — column names in A and B may differ), the display columns shown in results, and optionally the compare columns whose values will be checked to detect changes.

A File A

Key column

B File B

Key column

Ignore leading/trailing spaces Case-sensitive match Compare numbers as strings Skip rows with empty key

Choose an output pattern

Compare and save

Output format xlsx csv

Files are saved to your browser's Downloads folder.
Save each one individually or use "Save all selected" below.

R Reproduce this in R

Uses readxl, readr, and dplyr. Adjust setwd() or the file paths to match your working directory.

Reset everything and start a new comparison