CompareTwoLists

List & Data Cleaning Toolkit

Free Online List & Data Cleaning Tools

A focused toolkit for comparing, cleaning, sorting, merging, filtering, and converting lists. Fast, private, and free in your browser.

Runs locally in your browserYour data never leaves this page.
List Comparison Toolkit Find overlaps, differences, and changes across lists and text. 4 tools List Cleaning Toolkit Deduplicate, filter, normalize, and audit messy lists. 11 tools List Sorting & Arrangement Toolkit Sort, randomize, and batch lists without changing the source file. 6 tools List Formatting & Conversion Toolkit Merge and convert list formats for spreadsheets, code, and databases. 19 tools

Directory

All tools

Choose a task-specific utility or start with a toolkit. Every tool processes your input locally and has a permanent URL you can bookmark.

Compare Three Lists Online Find overlaps and unique values across three lists. Text Diff Checker Online Highlight line-level changes between two text blocks. Remove Duplicate Lines Online Deduplicate a list while preserving a predictable order. Filter List Lines Online Keep matching rows or remove unwanted rows from a list. Online List Cleaner Apply the most common list cleanup steps in one pass. List Item Frequency Counter Count repeated values and identify the most common lines. Sort a List Online Sort lines with alphabetical, natural, numeric, or length rules. List Randomizer & Shuffler Randomly shuffle list items with one click. Split a List into Chunks Break a long list into manageable fixed-size batches. Merge Two Lists Online Combine two lists with append, interleave, union, or overlap modes. Split Text into a List Turn delimited text into a clean line-by-line list. Convert List to Comma-Separated Text Join list lines using commas or another delimiter. Comma-Separated Text to List Turn comma-separated values into one item per line. Add Prefix or Suffix to Each Line Wrap or decorate every list item with fixed text. Convert a List to a JSON Array Create a valid JSON array from a line-by-line list. Convert a JSON Array to a List Turn a JSON array of values into a line-by-line list. Remove Empty Lines Online Remove blank rows without changing the remaining order. Trim Whitespace from Every Line Clean spaces and tabs from the start and end of every row. Reverse List Order Online Flip the top-to-bottom order of a list. Add Numbers to Each Line Create a numbered list with a custom start and separator. Remove Line Numbers Online Delete common numbering prefixes from a pasted list. Find and Replace Text in Lines Bulk replace text or patterns throughout a pasted list. Keep Only Duplicate Lines Extract the values that repeat in a list. Highlight Duplicate Lines with Counts Review duplicate rows in context before deleting them. Random Line Picker Online Select random winners, samples, or assignments from a list. List Statistics Calculator Audit the size and quality of a list before cleaning it. Compare Four Lists Online Analyze membership and overlap across four separate lists. Compare Two Columns Online Compare copied spreadsheet columns without formulas. Convert a List to a SQL IN Clause Create a paste-ready SQL IN value list from plain lines. Convert SQL IN Values to a List Turn a pasted SQL IN value sequence back into plain lines. Convert a List to a JavaScript Array Turn one item per line into JavaScript array code. Convert a List to a Python List Generate Python list code from plain text lines. Convert a List to a PHP Array Turn plain lines into a PHP array assignment or literal. Convert Text Lines to an HTML List Create safe ul/li or ol/li markup from a plain list. Convert Lines to a Markdown List Turn plain lines into Markdown bullets or numbered items. Add Quotes Around Every List Item Quote each line without manual find and replace. Bulk Slugify a List Generate one normalized slug for every input line. Change a List Delimiter Online Replace one literal list separator with another in one step. Extract a Column from Delimited Text Pull one field from every pasted row without a spreadsheet formula. Transpose Rows and Columns Online Transpose pasted tabular text directly in the browser.