List Intersection
Compare two line-separated lists and return the items shared by both lists.
How to use the List Intersection
What does the List Intersection do?
Compare two line-separated lists and return the items shared by both lists; It applies this page-specific rule: an intersection contains items found in both lists.
Which inputs does this tool use?
To compare two line-separated lists and return the items shared by both lists, enter First list, Second list, Items in both lists; keep every value in the same example; select Find shared items when the values are ready; Start with a familiar case covered by this rule - The default settings make everyday comparisons forgiving: surrounding spaces and capitalization do not create false mismatches, blank lines are ignored, and each shared item is returned once - so the expected result can confirm the settings.
How should the tool result be read?
For a result intended to compare two line-separated lists and return the items shared by both lists, the default settings make everyday comparisons forgiving: surrounding spaces and capitalization do not create false mismatches, blank lines are ignored, and each shared item is returned once; read items in both lists together with the original first list rather than as an isolated answer, and confirm that its units or structure match the intended use.
What order are shared items returned in?
When the goal is to compare two line-separated lists and return the items shared by both lists, they follow their first appearance in the first list.
Can duplicate matches be retained?
When using the page to compare two line-separated lists and return the items shared by both lists, yes.
Limits and accuracy
When using this tool to compare two line-separated lists and return the items shared by both lists, results stay in the first list's order and preserve that list's original spelling; check the result in its intended destination before relying on it for important work; keep first list until the output has been checked in its intended destination.
How list intersection works
An intersection contains items found in both lists. This page compares complete lines, not individual words or comma-separated cells.
The default settings make everyday comparisons forgiving: surrounding spaces and capitalization do not create false mismatches, blank lines are ignored, and each shared item is returned once. You can turn those settings off for exact comparisons.
Results stay in the first list's order and preserve that list's original spelling.
Frequently asked questions
What order are shared items returned in?
They follow their first appearance in the first list.
Can duplicate matches be retained?
Yes. Clear Return each result once to preserve repeated matching lines from the first list.
Does this compare CSV columns?
No. Use the CSV tools when quoted commas and column boundaries must be parsed.