Column Extractor
Extract specific columns from CSV or delimited text by column number (1-based).
Input
Output
Output Options
Frequently Asked Questions
What is a "column" in this context?
A column is one of the fields on a line, separated by the chosen delimiter. Columns are numbered from 1 starting at the left.
Example line (Delimiter: comma) Alice,30,Engineer,London Col 1 = Alice Col 2 = 30 Col 3 = Engineer Col 4 = London
How do I extract more than one column?
Enter column numbers separated by commas in the Extract Columns field. For example
1,3 extracts the first and third field from every line.
Input (Extract: 1,3) Alice,30,Engineer Bob,25,Designer Carol,35,Manager
Output Alice Engineer Bob Designer Carol Manager
Can I reorder the columns in the output?
Yes - enter the numbers in the order you want them.
3,1 outputs column 3 first, then column 1.
Input (Extract: 3,1) Alice,30,Engineer Bob,25,Designer
Output Engineer Alice Designer Bob
What does "Output Delimiter" control?
It controls how the extracted columns are joined together in the output.
Same delimiter - reuses your input delimiter between extracted columns.
Double space - separates columns with two spaces (good for plain-text alignment).
Tab - separates with a tab character (good for pasting into Excel).
Same delimiter - reuses your input delimiter between extracted columns.
Double space - separates columns with two spaces (good for plain-text alignment).
Tab - separates with a tab character (good for pasting into Excel).
What happens if a line has fewer columns than I requested?
Missing columns are simply skipped for that line. If you request columns
1,3,5 but a line only has 3 fields, columns 1 and 3 are extracted and column 5 is omitted for that line.How do I extract a single column to get a plain list?
Enter just one number, e.g.
2, to pull the second field from every line. This is useful for extracting email addresses, IDs, or any single field from structured data.
Input (Extract: 2) Alice,alice@example.com,Admin Bob,bob@example.com,User
Output alice@example.com bob@example.com
Is my data stored anywhere?
No. All processing runs entirely in your browser. Your data never leaves your device.
Related reading