List Operations
Comparing, merging, and analysing lists as sets.
How to Compare Two Lists Online
Compare two lists in seconds and see exactly what's shared, what's missing, and what's new. Real examples for Excel, CSV, and plain text. No software needed.
Read article →
List Union vs. Intersection Explained
Union gives you everything from either list. Intersection gives you only what is in both. What each one means, when to use it, and real examples.
Read article →
How to Merge Two Lists Online
Stack, zip, or interleave two lists in your browser. Pick the merge mode that matches your job: append, alternate, join rows, or combine without duplicates.
Read article →
ListDiff vs. CompareTwoLists.com
A factual, feature-by-feature comparison: Instagram export formats, TikTok support, mobile layout, dark mode, and language support.
Read article →
How to Remove Duplicates Across Multiple Lists
Combine several lists into one clean, deduplicated list, or find exactly which items are repeated across them. Two different tasks, two different tools.
Read article →
10 Spreadsheet Tasks You Can Do Faster Without Opening Excel
Comparing columns, removing duplicates, sorting, extracting columns, cleaning messy exports - ten common spreadsheet jobs that take seconds in a browser tool instead of Excel.
Read article →
How to Find Missing Records Between Two Database Exports
You have two exported files, not a live database connection. Here's how to find what's missing from either one without writing a LEFT JOIN or EXCEPT query.
Read article →
Comparing Expected vs. Actual Output: A QA Tester's Guide
Paste expected output as one list and actual output as the other to instantly see missing records, unexpected extras, and matches - without opening a spreadsheet.
Read article →
How to Compare Three or More Lists Online
Comparing lists two at a time falls apart past two sources. See what's shared across all lists, unique to one, or partially overlapping - for 3 to 8 lists at once.
Read article →
How to Make a Venn Diagram Directly from Your List Data
Most Venn diagram tools make you type region counts by hand. This one computes every region from your actual lists and lets you click to see the exact items.
Read article →
How to Combine Two Lists Side by Side
Join same-index items from two lists with a separator, like TEXTJOIN across spreadsheet columns, or alternate their lines - without opening a spreadsheet.
Read article →
How to Compare Two Lists in Google Sheets (and a Faster Way)
COUNTIF, MATCH, and conditional formatting all work for comparing two lists in Google Sheets, but each has gaps. Formulas, pitfalls, and a faster alternative.
Read article →
How to Find the Difference Between Two Lists in Every Major Language
A reference for finding what is only in list A, only in list B, or in both - shown in Python, JavaScript, SQL, Java, Bash, PowerShell, Excel, and Google Sheets.
Read article →
How to Find the Difference Between Two Lists in Python
Four ways to find what is in one Python list but not another: set difference, symmetric difference, an order-preserving comprehension, and Counter for duplicates.
Read article →
How to Find the Difference Between Two Arrays in JavaScript
Filter with Set.has, the new Set.prototype.difference(), symmetric difference, and lodash - four ways to diff two JavaScript arrays, with performance notes.
Read article →
How to Find the Difference Between Two Lists in SQL
EXCEPT/MINUS, NOT IN, NOT EXISTS, and LEFT JOIN - four ways to find rows in one table but not another in SQL, including the NOT IN NULL trap and symmetric difference.
Read article →
How to Find the Difference Between Two Lists in Java
removeAll, HashSet-based subtraction, Streams, and Apache Commons CollectionUtils - four ways to diff two Java lists, and why removeAll can be O(n * m).
Read article →
How to Compare Two Lists in Bash
comm, grep -Fxvf, diff, and join - four command-line ways to compare two text files line by line, plus the sorting and line-ending pitfalls that break each.
Read article →
How to Compare Two Lists in PowerShell
Compare-Object, -notin, and HashSet-based comparison - three ways to find the difference between two lists in PowerShell, plus the default case-insensitivity trap.
Read article →
How to Find the Difference Between Two Lists in C#
Except(), ExceptBy, HashSet.ExceptWith, and a duplicate-preserving Where clause - four ways to diff two C# lists, and why Except() silently drops duplicates.
Read article →
How to Find the Difference Between Two Pandas DataFrames
merge with indicator=True, concat + drop_duplicates, isin(), and DataFrame.compare() - four ways to diff two pandas DataFrames, and index-alignment pitfalls.
Read article →
How to Compare Two Lists in VBA (Excel Macro)
A full commented VBA macro using Scripting.Dictionary to compare two Excel columns, plus CountIf and Collection alternatives, and the pitfalls each avoids.
Read article →
How to Find the Difference Between Two Arrays in PHP
array_diff, array_diff_key, array_udiff, and array_flip + in_array - four ways to diff two PHP arrays, plus the string-comparison caveat array_diff has.
Read article →
How to Find the Difference Between Two Slices in Go
Go has no built-in set type, so the map[string]struct{} idiom, a generic Difference function, and a sorted two-pointer scan are the three ways to diff slices.
Read article →
How to Find the Difference Between Two Vectors in R
setdiff(), the %in% operator, symmetric difference via union of two setdiffs, and dplyr anti_join - four ways to diff two vectors or data frames in R.
Read article →
How to Find the Difference Between Two Arrays in Ruby
The a - b one-liner, Set#difference, symmetric difference, and the multi-argument difference() method - four ways to diff two Ruby arrays, precisely explained.
Read article →
How to Find the Difference Between Two Arrays in TypeScript
A typed generic difference function, readonly array support, the ES2024 Set.prototype.difference proposal, and comparing arrays of objects by key - all in TypeScript.
Read article →
How to Find the Difference Between Two Lists in Kotlin
The minus operator, subtract(), a Set-based filterNot for large lists, and symmetric difference - four ways to diff two Kotlin lists, and why minus can be O(n * m).
Read article →
How to Find the Difference Between Two Arrays in Swift
Set subtracting(), an order-preserving filter, CollectionDifference for ordered diffs, and symmetricDifference() - four ways to diff two Swift arrays.
Read article →
How to Compare Two Tables in Power Query (Anti Join Explained)
Merge with Left Anti and Right Anti joins, an Inner join for matches, and List.Difference in M code - four ways to compare two tables or lists in Power Query.
Read article →
How to Compare Two Arrays in Google Apps Script
A Set-based filter for comparing two arrays in Google Apps Script, the getValues() 2D-array gotcha, and a full copy-paste function that compares two sheet columns.
Read article →
How to Remove Duplicates from a List in Every Programming Language
A reference for removing duplicate values from a list or array - shown in Python, JavaScript, SQL, Java, Bash, PowerShell, pandas, and Excel/Google Sheets.
Read article →
How to Remove Duplicates from a List in Python
dict.fromkeys() vs set() for deduplicating a Python list, preserving order, handling lists of dicts, case-insensitive dedup, and the pandas equivalent.
Read article →
How to Remove Duplicates from an Array in JavaScript
The Set spread pattern, filter/indexOf and why to avoid it, deduping objects by key with Map, and case-insensitive dedup - four ways to dedupe a JS array.
Read article →
How to Remove Duplicate Rows in SQL
SELECT DISTINCT and GROUP BY for query results, a ROW_NUMBER() OVER (PARTITION BY...) CTE to delete duplicate rows from a table, and DISTINCT ON in Postgres.
Read article →
How to Remove Duplicates from a List in Bash
sort -u, why uniq needs sorted input first, the order-preserving awk one-liner, and how to dedupe by a specific field - four ways to remove duplicate lines in Bash.
Read article →
How to Remove Duplicates from an Array in PowerShell
Select-Object -Unique (order-preserving, case-insensitive by default), Sort-Object -Unique, why Get-Unique needs sorted input, and HashSet for large arrays.
Read article →
How to Remove Duplicate Rows in Pandas
drop_duplicates() with subset and keep parameters, duplicated() to inspect before deleting, case/whitespace-insensitive dedup, and value_counts() to see counts.
Read article →