List Tools
Compare, combine and calculate lists with exact, normalized, fuzzy, ordered and mathematical set operations.
Popular tools
Compare Two Lists
Compare two lists and calculate common, exclusive, union, symmetric-difference, duplicate and similarity results using the shared Comparison engine.
Compare Multiple Lists
Compare three to ten lists and find shared, exclusive and combined items.
Find Common List Items
Find the distinct items present in both lists using configurable equality rules.
Find Added and Removed List Items
Compare old and new lists to identify additions, removals and unchanged values.
Compare Lists with Fuzzy Matching
Match approximately equal list items with a configurable one-to-one similarity threshold.
Compare Ordered Lists
Detect additions, removals and positional changes with a longest-common-subsequence comparison.
List Difference Heatmap / Visual Diff
Create an aligned side-by-side list diff with clear markers for additions and removals.
Calculate Jaccard Similarity of Lists
Measure list similarity as intersection size divided by union size.
Multi-List Set Calculator
Build and calculate set expressions across Lists A, B, C and D with visual operator controls.
Merge Two Lists
Append two lists while preserving every item and its original order.
Merge Multiple Lists
Append up to twenty separated lists into one ordered result.
Merge and Deduplicate Lists
Combine lists and retain the first occurrence of every distinct item.
CSV Intelligence
Merge Lists by Key
Join delimited lists through matching key columns with inner, left or full results.
Universal List Converter
Convert among List, CSV, TSV, JSON, XML, YAML, Markdown and HTML formats.
Extract CSV Column as List
Extract one CSV column by header name or 1-based position.
Compare Two CSV Columns
Compare columns within one CSV and report common and exclusive values.
Compare CSV Column Against List
Compare a selected CSV column with a plain list and report both differences.
Merge CSV Files by Key
Join two CSV datasets by named key columns with inner, left or full joins.
CSV/List Lookup
Return CSV rows whose chosen column matches values in a lookup list.
CSV Column Profiler
Report row, uniqueness, duplicate, empty, type, length and frequency statistics.
List Frequency Table
Create a ranked CSV table with item counts and percentages.
Rank Items by Score
Rank CSV item-and-score rows in either score direction with tie-aware positions.
Create Leaderboard from List
Build a top-N leaderboard from item-and-score CSV rows.
List to CSV
Convert a plain one-value-per-line list into correctly escaped CSV.
CSV to List
Parse quoted CSV fields and convert their values into a plain list.
Extract Multiple CSV Columns
Select several CSV columns by names or positions and preserve them as CSV.
Convert CSV Row to List
Extract every field from a selected CSV data row into a vertical list.
Convert CSV Column to List
Convert a selected CSV column into a plain one-value-per-line list.
Find Missing CSV Values
Locate empty or token-marked missing values in a selected CSV column.
Find Duplicate CSV Values
Count repeated values in a selected CSV column and rank their frequency.
Group CSV Rows by Column
Group complete CSV rows by the value in a chosen column.
Intelligent Merging
Cartesian Product of Lists
Generate every possible ordered pairing between the values of two lists.
Interleave Lists
Alternate values from two lists and preserve remaining values from a longer list.
Zip Lists
Pair corresponding items from two lists into configurable delimited rows.
Zip Multiple Lists
Combine corresponding positions from several lists into aligned rows.
Merge Lists Row by Row
Join corresponding list rows with a configurable connector and missing-value fill.
Coalesce Lists
Select each primary list value or use its fallback value when empty.
Validation
Validate a List
Validate list items with reusable datatype presets and a line-by-line success report.
Validate Email List
Check every email address and separate valid entries from malformed values.
Validate Regex Against List
Test every list item against a custom JavaScript regular expression and flags.
Find Invalid List Items
Return only values that fail the selected datatype or regular-expression validation.
Split Valid and Invalid Items
Separate passing and failing list values into clear sections with a success rate.
List to JSON Array
Serialize list items as a valid formatted JSON array.
JSON Array to List
Validate a JSON array and convert its values into list entries.
Validate URL List
Check HTTP and HTTPS URLs and report invalid entries with their line numbers.
Validate IP Address List
Validate IPv4 and IPv6 address lists and identify malformed or out-of-range values.
Validate Domain List
Check fully qualified domain names for valid labels, length and top-level domains.
Validate UUID List
Validate standard UUID strings and report every nonconforming list value.
Validate Date List
Validate ISO-style dates and date-times, including impossible calendar dates.
Validate Number List
Validate finite integers, decimals and scientific-notation numbers in a list.
Validate Integer List
Check that every list value is a safe whole integer without units or decimals.
Validate Decimal List
Check decimal-number syntax and reject integers, units and nonnumeric values.
Validate Hex Color List
Validate three, four, six and eight-digit hexadecimal color values.
Validate JSON Value List
Parse each line as an independent JSON value and identify invalid JSON syntax.
Frequency & Distribution
List Frequency Counter
Count how often every normalized item occurs and sort the result by frequency.
List Frequency Histogram
Draw a proportional text histogram of list-item counts and percentages.
List Distribution Analyzer
Measure distinct values, diversity, duplicate occurrences and frequency spread.
Rank List Items
Rank list items alphabetically, by length or by occurrence frequency.
Calculate Item Percentages
Calculate each distinct item’s count, share and frequency rank.
Calculate Cumulative Frequency
Calculate ranked counts with running totals and cumulative percentages.
Find Rare List Items
Find items at or below a configurable maximum occurrence count.
Rank Items by Frequency
Order distinct list items by occurrence count from most to least frequent.
Quality & Cleaning Intelligence
Find Frequency Outliers
Identify unusually common or rare values using frequency z-scores.
List Quality Analyzer
Summarize uniqueness, duplication, length spread, types and detected quality issues.
Detect Inconsistent List Formatting
Identify rows that differ from the list's dominant capitalization style.
Detect Mixed Data Types
Classify list rows as text, numbers, dates, URLs, emails and other types.
Detect Invisible Characters in List
Reveal suspicious Unicode and control characters with code points and positions.
Detect Encoding Problems in List
Find replacement characters and common mojibake signatures in list values.
Find Suspicious List Items
Flag formula prefixes, bidirectional controls, control characters and repeated runs.
Find List Outliers
Identify unusually short or long rows using configurable length z-scores.
Smart List Cleaner
Clean Unicode, invisible characters, whitespace and normalized duplicates together.
Test If Two Lists Are Equal Sets
Test set equality without treating duplicate values or item order as differences.
Find Inconsistent Capitalization
Find equivalent values written with inconsistent uppercase and lowercase forms.
Find Inconsistent Separators
Diagnose mixed comma, semicolon, pipe and tab separators across input rows.
Ranking
Rank Numbers in a List
Rank finite numbers ascending or descending while assigning equal values the same rank.
Create Weighted Ranking
Multiply each item score by its weight and rank the calculated results.
Compare Two Rankings
Compare old and new ordered lists and report rises, falls, additions and removals.
Rank Items Alphabetically
Create ascending or descending locale-aware alphabetical rankings.
Rank Items by Length
Rank Unicode-aware text values from longest to shortest or shortest to longest.
Calculate Percentile Ranks
Calculate tie-aware midpoint percentile ranks for numeric list values.
Sampling & Random Selection
Stratified List Sampling
Preserve category representation with proportional or fixed-per-stratum sampling.
Reservoir Sample Large List
Sample large newline lists in one pass with bounded reservoir memory.
Split List into Random Groups
Shuffle and distribute items evenly across a chosen number of random groups.
Random Train/Test Split
Partition a list into non-overlapping training and test sets by percentage.
Create Reproducible Random Sample
Generate the same without-replacement sample whenever input, size and seed match.
Systematic List Sampling
Select evenly spaced rows using a calculated interval and controlled start position.
Advanced Grouping
Group List by Pattern
Group list values by a regular-expression match or first capture group.
Group List by First Character
Organize list items by their initial Unicode character with configurable case handling.
Group List by Length
Group Unicode text values by their exact character length.
Group List by Prefix
Group items by a configurable number of leading Unicode characters.
Group List by Suffix
Group items by a configurable number of trailing Unicode characters.
Group List by Frequency
Place distinct values into groups according to their exact occurrence counts.
Group Numbers into Ranges
Place finite numbers into mathematically aligned intervals of a chosen width.
Group Dates by Day/Month/Year
Organize ISO-style date values into daily, monthly or yearly sections.
Fuzzy List Matching
Group Similar List Items
Cluster approximately matching strings using normalized edit and token similarity.
Automatically Cluster List Items
Discover related text groups with strict, balanced or broad similarity sensitivity.
Fuzzy Compare Two Lists
Compare lists with configurable domain-aware similarity and one-to-one matching.
Find Similar List Items
Find approximately matching pairs within one list and report calculated scores.
Find Near-Duplicate List Items
Detect near-duplicate values within a list using a strict similarity threshold.
Calculate List Item Similarity
Calculate similarity percentages for corresponding rows in two lists.
Match Names Across Lists
Match personal and organization names after name-aware normalization.
Match Product Names Across Lists
Match product names using punctuation, corporate-term and token normalization.
Fuzzy Merge Lists
Merge matched and unmatched list rows with calculated confidence scores.
Match Misspelled List Items
Pair likely misspellings across two lists with one-to-one fuzzy matching.
Match Addresses Across Lists
Match address variants after normalizing common street abbreviations.
Match Records with Similar IDs
Match identifiers while ignoring punctuation and formatting differences.
Advanced Comparison
Structured Lists
Parse Structured List
Parse key-value list rows into validated JSON records.
List Schema Detector
Detect structured fields, coverage percentages and probable value types.
Convert Key-Value List to Table
Convert key-value records into a quoted CSV table with a unified schema.
Group Key-Value List
Group structured records by a selected field value.
Sort List by Field
Sort structured records by a text or numeric field in either direction.
Filter List by Field
Filter structured records by equality, containment, prefix or regular expression.
Join Structured Lists by Key
Join two key-value datasets with inner, left or full matching.
Convert Table to Key-Value List
Convert a CSV table into configurable key-value list records.
Extract Keys from List
Extract every distinct field name from a structured key-value list.
Extract Values from List
Extract one named field from every structured list record.
Deduplicate List by Field
Remove structured duplicates using one selected field as the identity.
Flatten Nested List
Flatten nested JSON arrays into a plain list with a controlled maximum depth.
List Studios
Comparison & Differences
Find List Differences
Calculate directional differences between two lists and show both A minus B and B minus A.
Find Items Only in List A
Return distinct items that occur in List A but not in List B.
Find Items Only in List B
Return distinct items that occur in List B but not in List A.
Find Most Frequent List Items
Find every item tied for the highest occurrence count.
Find Least Frequent List Items
Find every item tied for the lowest occurrence count.
Set Operations
List Union
Combine two sets and return every distinct item contained in either list.
List Intersection
Return every distinct item that occurs in both list sets.
List Difference (A − B)
Calculate the relative complement of B in A and return distinct A-only values.
List Symmetric Difference
Calculate items contained in either set but not in their intersection.
Test If List Is a Subset
Determine whether every distinct item in List A belongs to List B and report missing values.
Test If List Is a Superset
Determine whether List A contains every distinct item from List B and report omissions.
Structured Conversion
List Complement
Calculate all values in a universal set that are not contained in the selected subset.
List to TSV
Convert list items into tab-separated values with safe quoting.
TSV to List
Parse tab-separated rows and output every field as a plain list item.
List to JSON Objects
Convert every list item into an object using a chosen property name.
List to XML
Convert list entries into escaped XML item elements under one root.
XML to List
Extract decoded values from XML item elements into a plain list.
List to YAML
Convert list values into a safely quoted YAML sequence.
YAML to List
Parse a scalar YAML sequence into reusable plain list values.
List to Markdown
Turn plain items into a clean Markdown bullet list.
Markdown List to Plain List
Extract bullet and numbered Markdown entries into plain list values.
List to HTML List
Generate a safe escaped HTML unordered list from plain values.
HTML List to Plain List
Extract text from HTML list item elements and decode entities.