Find Missing Items Between Two Lists — Instantly
Paste your reference list and your actual list below. The tool immediately shows you which items are missing from each — no Excel formulas, no sign-up, no upload.
Find Missing Items Free →How to Find Missing Items Between Two Lists
Put your reference list (what you expect) in List A, and your actual list (what you have) in List B. The "Only in A" result shows everything that's missing from List B.
This replaces the common Excel approach of using VLOOKUP, COUNTIF, or MATCH formulas to find missing values between two columns. Paste and done — no formula writing required.
Real-World Examples
Missing invoice numbers: List A = all invoices that should have been paid this month. List B = invoices actually received. "Only in A" = missing invoices.
Missing survey respondents: List A = all participants who should have completed a survey. List B = who actually responded. "Only in A" = people who haven't responded yet.
Missing product SKUs: List A = full product catalogue. List B = products in your current inventory system. "Only in A" = items not yet added to inventory.
Missing email addresses: List A = all registered users. List B = users in your email marketing platform. "Only in A" = users not yet added to your mailing list.
Missing hostnames: List A = servers that should be running. List B = servers detected in a recent scan. "Only in A" = servers that didn't respond to the scan.
Tips for Finding Missing Items
Case sensitivity: By default the comparison is case-insensitive, so "Apple" and "apple" are treated as the same item. Turn on case-sensitive mode if your data requires exact case matching.
Duplicates: Enable deduplication to remove repeated entries within each list before comparing — this avoids false positives from repeated values.
Typos and near-matches: Enable fuzzy matching to catch items that are almost identical. This is useful when data from different sources has slight spelling variations.
Export results: Once you've found the missing items, export the "Only in A" section as a CSV file for further action.
Frequently Asked Questions
How do I find missing items between two lists?
Put your reference list (what you expect) in List A and your actual list in List B. The "Only in A" section shows everything missing from List B.
How do I find missing values without Excel formulas?
Paste your two columns into this tool instead. No VLOOKUP, COUNTIF, or MATCH formulas needed — results are instant.
Can I find missing emails or IDs?
Yes. Paste your expected list into List A and your actual list into List B. Missing emails or IDs appear in the "Only in A" result.
What about typos in my lists?
Enable fuzzy matching in the options panel. Near-matches (like "jon" for "john") are then treated as found rather than missing.
Is this free and private?
Yes — free, no sign-up, and 100% browser-based. No data is sent to any server.