Delimited Text Extractor
Pull specific columns out of CSV, TSV, or any delimited text.
Delimited Text Extractor
Extract specific columns from CSV, TSV, or any delimited text. Choose the delimiter, type the column numbers you need, and get just those fields – without opening a spreadsheet.
Features
- Any delimiter – comma, tab, semicolon, pipe, space, or a custom string.
- Flexible column selection – single columns, lists, and ranges like
1,3-5. - Reorder columns by listing them in a different order.
- Quoted CSV support for values that contain the delimiter.
- Change the output delimiter or put each value on its own line.
- Skip header row option.
Examples
- Pull the email column out of a CRM export.
- Get IDs from a log file separated by pipes.
- Convert selected CSV columns to tab-separated data for Excel.
- Extract usernames from
/etc/passwdwith a:delimiter.
Everything is processed locally in your browser, so even sensitive exports stay on your machine.
Frequently Asked Questions
How do I choose which columns to extract?
Enter column numbers starting at 1, separated by commas (1,3), or ranges (2-4), or both (1,3-5). Columns are returned in the order you type them, so 3,1 swaps the columns.
Does it handle quoted values with commas inside?
Yes. Values wrapped in double quotes, like "Doe, John", are treated as a single cell, and doubled quotes inside them are unescaped, following the CSV standard.
Can I change the delimiter in the output?
Yes. Use 'Output delimiter' to convert, for example, a comma-separated file into tab-separated columns you can paste directly into Excel.