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.

How do I compare records when the row order is different?

Choose corresponding keys instead of comparing row numbers. For small datasets, use lookup formulas and check duplicate keys first. DExcel keeps matched and unmatched records available for review.

Simple example

Left keys A01/A02 and right keys A01/A03 produce a shared A01 and unmatched A02/A03.

Scope: Key-based reconciliation is not a cell-by-cell comparison of formatting, formulas or every workbook object.

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.