New Analysis
Enter lists below and click CompareList Diff Tool is a free online list difference and comparison utility. Paste two lists to instantly find items only in List A, only in List B, common items, duplicates, and the full union. Use it as a list diff, list difference checker, or VLOOKUP alternative. Supports CSV, JSON, TXT import, Excel paste, fuzzy matching, and one-click export. All processing happens in your browser — no data is uploaded.
Ready for Comparison
Paste or type items into both lists above — differences, common items, duplicates, and the full union appear automatically.
How to Diff Two Lists — 3 Easy Steps
Compare two lists online in seconds — no formulas, no sign-up, nothing uploaded. Paste your data and this list compare tool shows the difference between List A and List B as you type.
-
1
Paste your lists
Type or paste items into List A and List B. Each item on its own line, or comma/semicolon/tab separated. Import .txt, .csv, or .json files directly — no reformatting needed.
-
2
Choose your options
Enable Case Sensitive, Deduplicate, Fuzzy Match, or Ordered Mode. Results update automatically as you type — no button click needed.
-
3
Export your results
See what's only in A, only in B, common to both, and the full union. Export any section as CSV (opens in Excel), JSON, or a shareable HTML report.
What Can You Compare?
Paste any kind of text list — names, emails, SKUs, order IDs, phone numbers, URLs, keywords, ingredient labels, or spreadsheet columns. Works for any two lists you need to diff, reconcile, or dedupe. No Excel formulas, no sign-up, no data uploaded.
Email & Subscriber Lists
Find duplicates across mailing lists, identify new subscribers, or reconcile unsubscribes between two CSV exports. Compare email lists for duplicates in seconds.
Inventory & Product Catalogs
Spot missing SKUs between two product lists, find items only in one warehouse, or merge inventory exports from two systems with one click.
Data Reconciliation
Reconcile two lists of records — invoices, order IDs, account numbers — to find missing entries or discrepancies between source systems. No Excel formulas required.
IT & Sysadmin
Compare IP address lists, domain names, DNS records, or server hostnames. Find what's been added, removed, or is common across two environments.
Developer & JSON Arrays
Compare two JSON arrays, API response sets, or code symbol lists. Use set operations (A∩B, A∪B, A−B) and export results as JSON for further processing.
Academic & Research
Compare word lists, student name rosters, bibliography references, or gene sets. Venn diagram visualization makes the overlap clear at a glance.
Excel & Google Sheets Columns
Compare two columns in Excel or Google Sheets without writing a formula. Copy a column, paste it into List A, paste the other into List B, and get the differences instantly.
VLOOKUP Alternative
Use Lookup mode as a browser-based VLOOKUP or XLOOKUP replacement — match keys from List A against a multi-column table in List B and pull back the columns you need, with optional fuzzy matching.
Find Missing or Added Items
Check which entries disappeared between an old and a new export, or which ones are brand new. See our find missing items guide for a step-by-step walkthrough.
Ingredient Labels & Food Allergies
Paste the ingredients from two cans, bags, or packets and see exactly which ones they share. Pet owners use it to narrow down the common ingredient behind a cat or dog food allergy — it works the same way for baby food, supplements, or any two ingredient panels.
Duplicate Detection & Dedupe
Remove duplicates from a list online, or find which values appear in both lists. Turn on deduplication to collapse repeats, then export a clean, unique list as CSV.
SEO Keywords & URL Lists
Diff keyword exports between two months, compare a sitemap against a crawl, or find URLs that dropped out of a ranking report. A fast list diff for SEO audits.
Customer & CRM Records
Compare customer lists from two CRMs, find accounts that exist in one system but not the other, and spot records that never synced — all without exporting data to a third-party service.
Phone Numbers & Contact Lists
Match two lists of phone numbers or contact IDs. Strip invisible characters and ignore leading zeros so numbers formatted differently in each export still line up correctly.
HR & Employee Rosters
Reconcile a payroll roster against an HR system export, confirm who joined or left between two periods, or check licence seats against an active-employee list.
Orders, Tracking & Serial Numbers
Compare shipped order IDs against a carrier's tracking export, or audit serial numbers and asset tags between a scanner dump and your inventory records.
Text Files & Config Lists
Drag two .txt or .csv files straight in to diff them line by line — dependency lists, allowlists, environment variables, or feature flags across two config files.
SQL & Database Exports
Paste two query result sets to verify a migration, find primary keys missing from a replica, or confirm that two environments return the same rows — a quick list difference checker for data QA.
Survey & Form Responses
Find out who responded twice, who hasn't replied yet, or which entries overlap between two form exports. Compare two lists of respondents in one click.
Frequently Asked Questions
What is the List Diff Tool?
The List Diff Tool is a free, powerful browser-based utility for comparing two lists and finding their differences. Also called a list difference checker or list comparison tool, it instantly identifies items only in List A, only in List B, common entries, and duplicates — without sending your data to any server.
Is my data secure and private?
Yes, absolutely. This tool runs entirely in your web browser using JavaScript. No data is ever uploaded to the cloud or saved on our servers. Your privacy is guaranteed by design.
Is this tool free to use?
Yes, it is 100% free for everyone. There are no limits, hidden fees, or subscriptions required to use any feature of the tool.
What file formats can I import?
You can import lists from Text files (.txt), CSV files (.csv), and JSON files (.json). The tool automatically detects the format and extracts the items for comparison.
Can I compare large lists?
Yes! Because the processing happens locally on your device, you can compare lists with tens of thousands of items in seconds, depending on your system's performance.
What does "Deduplicate" do?
The "Deduplicate" option automatically removes duplicate entries within each individual list before comparing them. This ensures that you are comparing unique sets of items.
How does "Case Sensitive" comparison work?
When "Case Sensitive" is checked, "Apple" and "apple" are treated as different items. If unchecked (default), they are considered equality.
What is "Ordered Mode" (LCS)?
"Ordered Mode" uses the Longest Common Subsequence algorithm to find items that appear in both lists in the same relative order, which is useful for comparing versions of code or text.
Can I download the results?
Yes. You can download your comparison results as a JSON file, a CSV file (Excel compatible), or a full HTML Report for sharing.
Does it work offline?
Yes. Once the page is loaded, the tool works completely offline. You don't need an active internet connection to perform comparisons.
What does "Normalize Whitespace" mean?
This feature cleans your data by trimming leading and trailing spaces and converting multiple consecutive spaces into a single space, ensuring clean and accurate matching.
How do I merge two lists?
The tool automatically generates a "Union" list which contains all unique items from both lists combined. You can view, copy, or export this merged list.
How can I find items only in one list?
Check the "Only in List A" or "Only in List B" result cards. These show items that are unique to each specific list.
Is the tool mobile friendly?
Yes, the interface is fully responsive and works great on mobile phones, tablets, and desktop computers.
Can I use this for email lists?
Absolutely. This tool is excellent for cleaning email lists, removing duplicates, and managing subscriber lists.
Does it support Dark Mode?
Yes. It automatically respects your system preference and also provides a manual toggle button in the header.
Does it save my history?
Your recent analysis sessions are saved in your browser's local storage so you can easily switch between them or come back later.
Can I export to Excel?
Yes. The "Export CSV" option creates a file that opens natively in Microsoft Excel, Google Sheets, or Apple Numbers.
What is Fuzzy Matching?
Fuzzy Matching identifies similar items that aren't exact matches. We support three distinct algorithms: Levenshtein (for typos), Soundex (for phonetic/sound matching), and Sørensen-Dice (for semantic/shared character match).
How does the Visual Diff work?
The Side-by-Side Visual Diff provides a line-by-line comparison in a modal window. It highlights additions and deletions with synchronized scrolling, making it easy to compare versions of code or structured text.
Can I use Regular Expressions (Regex)?
Yes! The tool includes a Regex Replace feature. You can use standard
JavaScript regex patterns (e.g., /pattern/g) to clean or transform your data before
comparison.
Do I need to click "Compare" for every change?
No. Results appear automatically as you type or paste into both lists — no button click needed. Settings changes (checkboxes, sliders) also trigger instant updates.
Does it have Undo and Redo?
Yes, full editing history is supported. Use Ctrl + Z to undo and Ctrl + Y (or Ctrl + Shift + Z) to redo any changes to your lists or settings.
How do I share my comparison?
The Share button generates a specialized URL that encodes all your current data and options. Simply copy the link and send it to share your work with colleagues or clients.
Are there power-user shortcuts?
Yes. Press Alt + ? to open the Shortcuts Modal. Common ones include Ctrl + Enter to compare, Alt + N for new analysis, and Ctrl + D for Visual Diff.
What are Visual Insights?
We provide visual data representations like Venn Diagrams and Distribution Charts. These help you understand the relationship between your lists at a glance.
What browsers are supported?
We support all modern browsers including Chrome, Firefox, Safari, Edge, and Opera. No plugins needed.
Can I paste data directly from Excel or Google Sheets?
Yes. When you copy a column from Excel or Google Sheets and paste it into either list, the tab-separated values are automatically detected and split into individual items. No reformatting needed.
How do I clear only one list without resetting both?
Each list panel has a Clear link in its header. Clicking it wipes only that list, leaving the other unchanged. The Reset Lists button in the action bar clears both at once.
How do I copy results?
You can copy individual items using the copy icon next to each row, or copy an entire result section using the Copy All button in each section's header. The Copy Result button in the top bar copies the full JSON result to your clipboard.
Can I copy a result section as plain text?
Yes. Each result section (Only in A, Only in B, Common, Union, Ordered Overlap) has a Copy All button that copies all visible items to your clipboard as newline-separated plain text — ready to paste anywhere.
Can I search through my saved analyses?
Yes. The sidebar includes a search box that filters your saved analyses by name in real time. This is useful when you have multiple sessions and need to switch between them quickly.
Can I see which specific duplicate items were removed?
Yes. When Deduplicate is enabled and duplicates are found, a "View removed duplicates" collapsible section appears below the stats. It lists exactly which items were removed from each list, so you always know what was cleaned up.
How do I find items in List A that are not in List B?
The "Only in A" result section shows every item that exists in List A but is absent from List B — this is the set-theory operation A minus B (A−B). Similarly, "Only in B" gives you B minus A. Both sections are exportable as CSV or JSON.
How do I find missing items between two lists?
Paste both lists and compare. The "Only in A" and "Only in B" sections immediately show items missing from each side. This is the fastest way to reconcile two datasets and spot omissions — no formulas, no Excel needed.
Can I use this to reconcile two lists of data?
Yes. Paste your two data sets (invoice numbers, order IDs, account references, etc.) and the tool instantly shows what's in one list but not the other. This makes reconciliation between two systems or exports simple: export the mismatches as CSV and you have your discrepancy report.
Can I compare two JSON arrays online?
Yes. Paste each JSON array (one value per line, or comma-separated) into List A and List B. The tool identifies which values are unique to each array, which are shared, and produces a union. You can export the results as JSON for further processing.
Can I compare email lists for duplicates?
Absolutely. Paste your two email lists — one per line — and click Compare. The Common items section shows addresses that appear in both lists (your duplicates). Enable Case Sensitive off (the default) so "User@Example.com" and "user@example.com" count as the same address. Export the results as CSV for your email platform.
Can I compare lists without Excel or VLOOKUP?
Yes — that's exactly what this tool is for. No formulas, no VLOOKUP, no COUNTIF. Just paste your two lists, get instant results for differences and matches, and export the output. It's faster and simpler than any spreadsheet approach, and works for any data type — not just numbers.
What is the difference between Union, Intersection, and Difference in list comparison?
Union (A∪B) — all unique items from both lists combined. Intersection (A∩B) — items that appear in both lists (shown as "Common items"). Difference (A−B) — items in A but not in B (shown as "Only in A"). Symmetric difference — items in A or B but not both (combine "Only in A" and "Only in B"). All four results are shown simultaneously after each comparison.
Can I compare two columns from Excel or Google Sheets?
Yes. Select a column in Excel or Google Sheets, copy it, and paste directly into List A. Then do the same for the second column into List B. Tab-separated values are automatically split into individual items — no reformatting required. It's the easiest way to compare two spreadsheet columns without writing a single formula.
Is this a list diff tool or a list compare tool?
Both — they are two names for the same job. A list diff (often written as one word, listdiff) shows what changed between two lists: the items only in List A and only in List B. A list compare tool also shows what the lists share (common items) and what they add up to (the union). This tool does all of it in a single pass, so whichever term you searched for, you are in the right place.
How do I compare two lists online for free?
Paste your first list into List A and your second into List B — the comparison runs automatically as you type, with no button to press and no account to create. Because everything is computed in your browser, you can compare lists online free, as often as you like, and nothing is uploaded to a server. Export any section as CSV, JSON or a self-contained HTML report when you are done.
What do List A and List B mean?
List A and List B are simply the two lists being compared — A on the left, B on the right. Every result is labelled against them: Only in List A is what A has that B does not, Only in List B is the reverse, and Common items is what both contain. Click either label to rename it to something meaningful, such as "January export" or "CRM contacts", and the results rename themselves to match.