Remove Duplicate Lines Online
Instantly deduplicate text lists and spreadsheets. Fast, and runs locally in your browser; your text is not uploaded.
Open ToolCompare two text lists or spreadsheet columns side-by-side to find unique items, duplicates, and differences instantly.

Stop manual copy-pasting between CSVs and dashboards. Let your RunMacro bot record, reconcile, and sync list workflows natively on your desktop.
Paste your first dataset into List A and your second dataset into List B (one item per line).
Toggle Case-sensitive or Trim spaces according to your formatting preferences.
Switch between Common items (A ∩ B), Only in A, Only in B, and Differences, then copy or download TXT.
Comparing text columns side-by-side to extract intersections, relative complements, and symmetric differences.
List A (Current Active Users):
alice@example.com
bob@example.com
carol@example.com
david@example.com
List B (New Campaign Leads):
bob@example.com
david@example.com
emily@example.com
frank@example.com• Common (A ∩ B) [2]: bob@example.com, david@example.com
• Only in A (A B) [2]: alice@example.com, carol@example.com
• Only in B (B A) [2]: emily@example.com, frank@example.com
• Differences (A △ B) [4]: alice@example.com, carol@example.com, emily@example.com, frank@example.comUnderstanding the 4 output tabs, casing options, and space normalization.
Handling massive datasets beyond 50,000 lines.
While JavaScript Set data structures compute comparisons in milliseconds, rendering 50,000 lines into HTML textareas can cause browser rendering lag.
Effortlessly extract intersection (A ∩ B), difference (A \ B, B \ A), and symmetric difference in one click.
Support strict case-sensitive matching or lenient comparison ignoring accidental spaces.
Your private customer records, emails, or internal IDs are processed in your browser and are not uploaded.
Download clean comparison outputs ready to paste directly back into Excel or Google Sheets.
Clear answers about using this tool and automating workflows with RunMacro.
No. The comparison runs 100% locally in your browser memory using JavaScript. Your input text is never uploaded, logged, or sent to external servers.
Common Items represents the set intersection (A ∩ B), showing lines that appear in both lists. Only in A shows items unique to List A (A \ B). Only in B shows items unique to List B (B \ A). Differences represents the symmetric difference (A △ B), containing all items that appear in either list but not in both.
When "Case-sensitive" is checked, "Apple" and "apple" are treated as distinct items; when unchecked, casing is ignored. When "Trim spaces" is enabled, leading and trailing whitespace is stripped before comparison so " item " matches "item". Initial line order is preserved in outputs.
Modern browser engines can compare lists of 50,000+ lines in under a second. For million-row datasets or scheduled database cross-referencing, desktop automation with RunMacro or dedicated batch scripts is recommended to prevent browser memory throttling.
RunMacro provides visual Excel automation actions that can open two workbooks, compare columns row-by-row, highlight discrepancies, and export reconciled files automatically without writing complex VLOOKUP or Python scripts.
Explore other helpful browser-based utilities in the same category.