Excel tool

Find Matching & Missing Rows

Compare keys in two worksheets and retain rows from the first that are present or absent in the second.

Private by designRuns in your browser
Recent tools
Ctrl / ⌘ + Enter to run

Loading workspace…

Preparing the controls for this tool. Your files have not been selected or uploaded.
QUICK START

How to use Find Matching & Missing Rows

  1. Import supported XLSX or CSV files and select exactly two worksheets. The first is the source and the second is the comparison.
  2. Enter one-based key column numbers such as 1,2. Choose matching or missing rows and the text-case setting.
  3. Run the comparison, review the rows retained from the first sheet and download XLSX.

Continue your workflow

Compare two inventory files — Find changed quantities and missing product records.

BEFORE YOU BEGIN

What to expect

Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.

Local processing

Your files and inputs are processed in your browser and are not uploaded. Download or copy results before leaving. Normal site and library requests still reach the hosting service.

Matching by a shared key

If column 1 contains order IDs, choose column 1 in both sheets. Missing mode retains source orders whose IDs do not occur in the comparison. With several selected columns, all selected values form the matching key.

Position, types and duplicates

The same column positions must exist in both sheets. Case-insensitive mode compares string representations in lowercase; sensitive mode retains value types. Matching is presence-based, not a join that adds fields. Duplicate source rows can remain, and whitespace is not automatically trimmed.

HELP & TROUBLESHOOTING

Frequently asked questions

Will the second sheet’s columns be added?

No. The result contains qualifying rows and columns from the first worksheet. It does not enrich rows with fields from the second.

Why did apparently equal IDs not match?

Check selected column positions, whitespace, text versus number storage and case settings. Clean or standardize your source data if appropriate.

Where is my input processed?

Files and inputs are processed locally in your browser and are not uploaded. The hosting service receives normal website and library requests. Download or copy results before leaving.