Tools you might need next
Sort lines alphabetically or numerically in any text list. Free online line sorter for cleaning datasets, organizing names, and preparing sorted output.
Add line numbers to text automatically. Prefix each row with sequential indices for code snippets, documentation, legal excerpts, and shared references.
Remove duplicate lines from text while keeping unique rows. Clean email lists, URLs, log entries, and data files quickly with this free online tool.
Splits each line by a delimiter (tab, comma, spaces, custom) and extracts specified column indices. Supports zero-based or one-based indexing, multiple column selection, and column reordering.
For each line: columns = line.split(delimiter); output = selected_columns.map(i => columns[i]).join(output_delimiter)Auto-detection examines the first few lines for consistent delimiters: tab (TSV), comma (CSV), pipe, or fixed-width alignment. Fixed-width detection uses column position consistency across lines.
Updated: July 2026
Pull the email column (column 3) from a contacts CSV export.
→ List of email addresses only, one per line
Rearrange columns in a tab-separated dataset for a different import format.
→ Reordered TSV with columns in specified sequence
CSV fields containing commas are enclosed in quotes: "Smith, Jr.",value. Splitting on comma without respecting quotes breaks these fields. Use a proper CSV parser for quoted data.
Column numbering convention varies between tools (awk uses $1 for first column, Python uses index 0). Always verify the indexing convention before specifying column numbers.
Extract specific columns from delimited or fixed-width text. Pull fields from TSV, CSV-like, and space-separated data with flexible column selection. It applies the column extraction (For each line: columns = line.split(delimiter); output = selected_columns.map(i => columns[i]).join(output_delimiter)). For example: extract emails from csv — Pull the email column (column 3) from a contacts CSV export.