Find List Intersection (Compare Lists)
Instantly compare two lists of text to find matches and differences. Extract items that appear in both lists, or find missing items that exist in one list but not the other.
Related text manipulation tools
About List Intersections
What is a List Intersection?
In mathematics and data science, an “intersection” refers to the specific set of items that appear in two separate groups simultaneously. Our tool applies this logic to text. By pasting two datasets into the panes above, the engine acts as an instant cross-referencing tool, bypassing the need for complex spreadsheet formulas like VLOOKUP or INDEX/MATCH.
Extraction Methods Explained
- Common Items: Identifies overlaps. Extracts only the lines that exist in both List A and List B. Perfect for finding overlapping email addresses, duplicate SKUs, or shared attendees.
- Missing from B (Only in List A): Extracts lines that are present in your first list but completely missing from your second list. Highly useful for identifying missing data entries or auditing inventories.
- Missing from A (Only in List B): The exact reverse of the above. Shows you what List B has that List A lacks.
- Completely Unique: The “Symmetric Difference.” This extracts all items that do NOT overlap. If an item appears in both lists, it is deleted, leaving you with only the unique outliers.
Common questions
Invisible spaces are the number one cause of failed cross-referencing. If List A has “Apple” and List B has “Apple ” (with a trailing space), a computer sees them as completely different words. Trimming whitespace forces the engine to ignore invisible formatting and focus purely on the text, preventing false mismatches.
Yes. To provide clean and accurate intersections, the engine automatically deduplicates both lists during processing. The final output will contain one unique entry per matched string.