CSV & Columns
Splitting, joining, aligning, and extracting delimited data.
How to Compare Two Excel Columns Online
Compare two Excel columns instantly in your browser. Find matching values, differences, and unique items. No formulas, no macros, no Excel needed.
Read article →
How to Split a CSV Row Into Separate Lines (and Join Them Back)
Turn a single comma-separated row into one item per line, or combine a list back into a row. Works with any delimiter, with quoting options for SQL.
Read article →
How to Align Delimited Text into Readable Columns
Turn comma, tab, or pipe-separated text into a neat fixed-width table you can paste into an email, Slack message, or code comment.
Read article →
How to Extract Specific Columns from CSV or Delimited Text
Pull one or more fields out of CSV, TSV, or any delimited text by column number - reorder them, join them with a new separator, and skip everything else.
Read article →
How to Remove Quotes from a CSV File Online
Strip the double or single quotes wrapping every value in a CSV export in one pass, whether it's a single quoted row or a whole file's worth of quoted lines.
Read article →
CSV vs TSV: What's the Difference and When to Use Each
CSV separates values with commas, TSV with tabs. Here is what that actually changes in practice, and how to convert between the two without reformatting by hand.
Read article →
A VLOOKUP Alternative That Works Without Opening Excel
Match two datasets by a key column without formulas, N/A errors, or counting column indexes. Paste two exports, pick key columns, and see matches, changes, and gaps instantly.
Read article →
How to Remove Duplicates in Google Sheets
Remove duplicates in Google Sheets three ways: the built-in Data cleanup tool, the UNIQUE function, or COUNTIF to flag repeats first, plus multi-column tips.
Read article →