Column Extractor — Get Columns from CSV & Delimited Text
Extract column N (or several columns) from CSV, TSV, semicolon, pipe or whitespace-separated text. Quote-aware parsing, auto-detect and private processing.
🔒 Runs entirely in your browser — nothing is uploadedPull out just the column you need
Spreadsheets are great for big tables, but sometimes you only need one column from a CSV export, a pasted report or the output of a command. This column extractor gets column N from any delimited text without opening Excel or writing a script. Paste the data, and the tool auto-detects whether it is separated by commas, tabs, semicolons or pipes, shows a button for every header in the first row, and extracts the column you click.
You can also type a column specification: a single number such as 2, a list such as 1,3, a range such as 2-4, or negative numbers that count from the end, such as -1 for the last column. Columns are output in the order you list them, which makes it easy to reorder or swap them. Tick "Skip header row" to drop the first line, and "Trim values" to remove stray spaces around each cell.
Proper CSV parsing
Splitting a CSV line on every comma breaks as soon as a value contains a comma, like "Doe, Jane" or an address. The extractor follows the CSV standard (RFC 4180): values wrapped in double quotes may contain the delimiter, line breaks and escaped quotes written as two double quotes. When the extracted values are written back out, they are re-quoted only if necessary, so the result is still valid CSV. Choose a different output separator to convert, for example, a semicolon-separated European export into comma- or tab-separated data.
The whitespace delimiter treats any run of spaces or tabs as a single separator and ignores indentation, which is perfect for the aligned columns printed by commands such as ls -l, ps, df or docker ps.
Private data stays on your device
Exports often contain customer names, emails and financial data. Parsing happens entirely in your browser; nothing is uploaded, and the Download button saves the result straight from your browser.
How to use
- Paste delimited textAdd CSV, TSV, semicolon- or pipe-separated data, or whitespace-aligned output.
- Check the delimiterAuto-detect picks the most likely separator, or choose one yourself.
- Pick the columnsType a column number, a list such as 1,3 or a range such as 2-4, or click a header button.
- Copy or downloadChoose the output separator and copy or download the extracted columns.