Explore all Text & Data Tools

Compare Two Lists Online

Compare two text lists or spreadsheet columns side-by-side to find unique items, duplicates, and differences instantly.

7 items
7 items
Real-time auto compare
Showing: 3 items
RunMacro Bot
⚡ Bulk Data Reconciliation

Automate Bulk List Comparison & System Sync

Stop manual copy-pasting between CSVs and dashboards. Let your RunMacro bot record, reconcile, and sync list workflows natively on your desktop.

How to Compare Two Lists Online

1

Paste Your Lists into Input Boxes

Paste your first dataset into List A and your second dataset into List B (one item per line).

2

Configure Comparison Filters

Toggle Case-sensitive or Trim spaces according to your formatting preferences.

3

View 4 Result Tabs and Export

Switch between Common items (A ∩ B), Only in A, Only in B, and Differences, then copy or download TXT.

Realistic List Comparison & Set Reconciliation Scenarios

Comparing text columns side-by-side to extract intersections, relative complements, and symmetric differences.

Reconciling Newsletter Subscriber Lists (A vs B)

Example 1
Configuration:Filter: Trim spaces: ON | Case-sensitive: OFF.
Input Data
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
Output Result
• 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.com
Analysis & Interpretation: Identifies 2 existing customers in the new campaign (preventing duplicate marketing emails), 2 customers unique to List A, and 2 brand-new leads in List B ready for CRM onboarding.

Mathematical Set Operations & Comparison Filters

Understanding the 4 output tabs, casing options, and space normalization.

Common Items (Intersection: A ∩ B)

Extracts lines that exist in both List A and List B.

Impact: Essential for finding overlapping accounts, shared keywords, or duplicate records.

Only in A (Relative Complement: A B)

Lines that appear in List A, but do not appear in List B.

Impact: Finds dropped items, churned users, or missing catalog products.

Only in B (Relative Complement: B A)

Lines that appear in List B, but do not appear in List A.

Impact: Isolates new additions, imported contacts, or freshly scraped rows.

Differences (Symmetric Difference: A △ B)

Lines appearing in either List A or List B, but not in both (Union minus Intersection).

Impact: Shows total divergence between two spreadsheet column revisions.

Browser Memory & Large List Performance

Handling massive datasets beyond 50,000 lines.

DOM Rendering Boundaries with 50,000+ Lines

While JavaScript Set data structures compute comparisons in milliseconds, rendering 50,000 lines into HTML textareas can cause browser rendering lag.

Recommended Workaround: Use the "Download TXT" button rather than copying from the UI, or use RunMacro desktop Excel automation for multi-million row datasets.

Key Capabilities of Our List Comparator

4 Distinct Set Operations

Effortlessly extract intersection (A ∩ B), difference (A \ B, B \ A), and symmetric difference in one click.

Case & Space Normalization

Support strict case-sensitive matching or lenient comparison ignoring accidental spaces.

Client-Side Processing

Your private customer records, emails, or internal IDs are processed in your browser and are not uploaded.

Instant TXT Export

Download clean comparison outputs ready to paste directly back into Excel or Google Sheets.

Frequently Asked Questions

Clear answers about using this tool and automating workflows with RunMacro.

Are my lists uploaded to any server when comparing?

No. The comparison runs 100% locally in your browser memory using JavaScript. Your input text is never uploaded, logged, or sent to external servers.

What do the four result categories (Common, Only in A, Only in B, Differences) mean?

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.

How do Case-sensitive and Trim spaces settings affect the comparison?

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.

How large can the compared lists be in the browser?

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.

How can RunMacro automate spreadsheet reconciliation?

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.

Related Free Tools

Explore other helpful browser-based utilities in the same category.