Find Matching & Missing Rows
Compare selected keys and find rows present or absent in another sheet.
Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.
Working with many files? Open batch processing for supported operations. Batch uses its own basic options.
How to use Find Matching & Missing Rows
- Choose a supported file from your device. For spreadsheets, load the data and choose the worksheet.
- Set the options for this task: Column numbers — Separate column numbers with commas; Keep rows from first sheet; Text matching.
- Run the tool, review the result, and use the copy or download option provided.
Continue your workflow
Compare two inventory files — Find changed quantities and missing product records.
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.
Frequently asked questions
What does Find Matching & Missing Rows do?
Compare selected keys and find rows present or absent in another sheet. Choose XLSX or CSV, then load your worksheets. The first row is a header. Downloads contain values; original formulas and formatting are not preserved.
Are my files or input sent to a server?
Your files are processed locally in your browser and are not uploaded. Text inputs and passwords also stay in the tool on your device. The hosting service still receives normal requests needed to serve the website.
Can I recover a result after closing the page?
Download or copy your result before closing or reloading. Optional local history stores tool names and activity counts, not your inputs, passwords, filenames, or results.