Guides
Practical, connected guides for comparing lists, finding duplicates, and reconciling data across spreadsheets, CSV files, databases, inventories, subscriber platforms, and websites. Each guide covers a specific workflow — picking the right comparison key, handling delimiters and whitespace, and reading the five results (only in A, only in B, intersection, union, and symmetric difference) in context — then links back to the free comparison tool so you can run it on your own data immediately.
Topical library
Start with the underlying set operations, then move into the spreadsheet, file-format, developer, or business workflow that matches your task.
Compare Excel and Sheets columns, CSV/TSV exports, JSON, Word, and text files.
Safely compare Instagram follower and following exports without handing over your login.
See all 2 →Find and remove duplicates, hidden characters, and messy formatting before you compare.
List comparison and deduplication in SQL, Python, pandas, JavaScript, and PowerShell.
Reconcile database exports, subscriber lists, inventory counts, and URL migrations.
The core concepts: union, intersection, difference, and how DiffLists compares to alternatives.
All guides
Stuck cross-checking two lists by eye? Paste both in and instantly see matches, duplicates, and differences — free, private, no signup required.
Confused by set operations? A plain-English guide to union, intersection, difference, and symmetric difference — with real examples, no jargon.
Chasing duplicate entries across two spreadsheets? Find every shared item instantly, plus how to clean duplicates within a single messy list.
Tired of unreliable VLOOKUP formulas? Compare two Excel columns 3 ways — conditional formatting, COUNTIF/MATCH, or an instant online tool.
Sick of nested MATCH/ISNA formulas? Compare two Google Sheets columns the formula way, or skip it entirely with a faster browser-based tool.
Wondering who unfollowed you on Instagram? Export your followers/following lists and compare them instantly to find out — free and private.
Compare CSV exports without fragile formulas. Learn when to match full rows, when to isolate a key column, and how to prevent delimiter and whitespace errors.
Use directional differences, intersection, union, and match rate to reconcile database exports and explain exactly what changed between systems.
Reconcile subscriber exports, verify suppressions, find new contacts, and avoid false matches while keeping email addresses in your browser.
Compare inventory exports by SKU, identify missing and new products, and separate record coverage problems from stock-quantity differences.
Compare URL lists to audit old and new site inventories, find missing pages and unexpected additions, and build a cleaner redirect validation workflow for site migrations.
Paste a messy list and get it back sorted A-to-Z or Z-to-A instantly, with natural sort for numbered items and an option to dedupe at the same time.
See two lists next to each other with matches, differences, and duplicates highlighted — no spreadsheet formulas, no manual scrolling back and forth.
Turn a plain list of IDs, SKUs, or emails into a properly quoted, comma-separated SQL IN clause you can paste straight into a WHERE statement.
Compare the four common ways to remove duplicates from a Python list — dict.fromkeys(), set(), a list comprehension, and pandas — and when to use each.
Learn drop_duplicates() and unique() in pandas: deduping full rows, deduping by specific columns, choosing which occurrence to keep, and checking your work.
Delete duplicate rows in SQL safely using ROW_NUMBER() and PARTITION BY, plus DISTINCT and GROUP BY for cases where you just need unique results, not deletions.
Find the difference between two JavaScript arrays with filter + includes, or use a Set for large arrays — plus how to remove duplicates from a single array.
Remove duplicates from a PowerShell array with Select-Object -Unique or Sort-Object -Unique, plus how case sensitivity and object properties affect the result.
Remove duplicate entries from any list in seconds. Covers what actually counts as a duplicate, why case and whitespace break matching, and how to verify the result.
Merge two lists into one without duplicate entries. Learn the difference between appending, merging, and joining, and how to keep the combined list clean.
Compare three or more lists using repeated pairwise comparisons. A practical method for finding what's common to all of them, and what's unique to each.
CSV and TSV hold the same data with a different separator. Learn when tabs beat commas, how quoting differs, and which format survives messy real-world data.
Compare two text files in the browser to see which lines were added, removed, or left unchanged — and when a line-by-line diff beats a set comparison.
Install the Compare plugin in Notepad++ and diff two files side by side, plus when a browser-based diff is the faster option.
Use Word's built-in Compare feature to see every difference between two drafts, plus what to do when you only need the text differences rather than tracked changes.
Compare two JSON files without key order and formatting swamping the real differences. Covers normalizing before diffing and what a plain text diff can and can't tell you.
The same deduplication problem solved in Python, pandas, SQL, JavaScript and PowerShell — with the order-preservation and case-sensitivity gotchas for each.
Find your Instagram mutual followers by exporting your followers and following lists and comparing them — no third-party app and no password required.
Zero-width spaces and non-breaking spaces break string matching while looking like nothing at all. How to detect them, where they come from, and how to strip them.
An honest feature comparison of DiffLists and ListDiff — what both do identically, where each one is genuinely ahead, and which to pick for a given job.
An honest, fact-based comparison of DiffLists and Diffchecker — what each is actually built for, real pricing, and when to pick one over the other.
An honest feature comparison of DiffLists and CompareTwoLists.com — what both do, where each has a real edge, and which to pick.