Column Extractor
Pull selected columns from CSV, TSV or tables.
How to use
- 1 Paste your delimited text into the input box.
- 2 Pick the input delimiter that matches your data.
- 3 List the column numbers you want, e.g. 1,3.
- 4 Optionally set the join character and skip-missing option.
- 5 Copy the extracted columns from the output.
About Column Extractor
The Column Extractor lifts the columns you actually need out of delimited text and leaves the rest behind.
Paste a CSV export, a tab-separated table, a pasted spreadsheet selection, a log file split by pipes, or any rows separated by whitespace, then tell it which columns to keep.
You choose the input delimiter — comma, tab, whitespace, pipe or semicolon — and list the columns you want by their 1-based position.
The columns come out in exactly the order you list them, so the tool doubles as a quick reorder: ask for "3,1" and you get the third column first.
You can also set the character used to join the extracted fields back together, so a comma file can become a tab file or a neatly piped list.
When a row is shorter than expected, the missing field comes back as an empty value by default, or you can switch on "skip rows missing a column" to drop those rows entirely.
This is a simple, quote-unaware splitter, which keeps it predictable for ad-hoc data and pasted tables.
Everything runs locally in your browser.
Your data is never uploaded, logged or stored, so it is safe for sensitive exports, and it keeps working offline once the page has loaded.
FAQ
Are columns counted from 0 or 1?
From 1. The first column is column 1, the second is column 2, and so on. Listing 0 or a negative number is rejected.
Can I reorder columns while extracting?
Yes. Columns appear in the order you list them, so entering 3,1 puts the third column before the first.
Does it understand quoted CSV fields with embedded commas?
No. It is a simple splitter that does not parse RFC-4180 quoting, which keeps results predictable for pasted tables and logs.