Compare two Excel sheets by the keys you choose

Match records across two worksheets and keep both matched and unmatched rows visible for review.

Windows 10/11 · Works with .xlsx files · Source files stay unchanged

BEFORE

Source A IDs	Source B IDs
A01	A01
A02	A03

AFTER

ID	Result
A01	In both
A02	Only in A
A03	Only in B

Illustrative sample data, not a software screenshot. Compare by your chosen keys, not row position. Review unmatched rows before drawing business conclusions.

BEFORE

What takes time today

VLOOKUP formulas assembled for every file

Duplicate keys can hide ambiguous matches

Missing rows require a second manual check

AFTER

What you get instead

Matched records in one result

Rows found only on the left or right retained

Multiple matching columns supported

HOW IT WORKS

Choose. Configure. Save.

Add one workbook with two worksheets, or add two separate .xlsx files.

Choose exactly two data sources and pair their matching columns.

Generate a new comparison workbook with matched and unmatched records.

Test it with your own workbook.

Free Windows preview · .xlsx files · Review your new workbook in Excel or WPS.