CSV Column Extractor
Extract specific columns from a CSV by header name, index or range. Reorder, drop or keep the columns you need — free and 100% in your browser.
What is the CSV Column Extractor?
The ByteTools CSV Column Extractor pulls just the columns you need out of a wide CSV. Load your file, tick the columns from the list, or type a selection such as email, 1, 3-4 to choose them by name, by 1-based index or by range — and in exactly the order you want them.
- Select columns by header name, 1-based index or range
- Output columns in the exact order you list them
- Invert the selection to drop columns instead
- Change the output delimiter independently of the input
- Handles quoted fields, embedded commas and newlines
- 100% private — CSV never leaves your browser
How to use the CSV Column Extractor
- 1
Paste your CSV, or drop a .csv file, then click Load columns.
- 2
Tick the columns you want, or type a selection like name, 3, 5-7 to control their order.
- 3
Optionally invert the selection to drop those columns instead.
- 4
Click Extract columns, then copy the result or download it as a .csv file.
About the CSV Column Extractor
The ByteTools CSV Column Extractor pulls just the columns you need out of a wide CSV. Load your file, tick the columns from the list, or type a selection such as email, 1, 3-4 to choose them by name, by 1-based index or by range — and in exactly the order you want them.
Invert the selection to drop columns instead of keeping them, change the output delimiter, and decide whether the header row is written to the result. It is ideal for trimming a bloated export before importing it somewhere, or for building a small extract from a report without opening a spreadsheet.
Parsing and extraction run 100% locally in your browser with JavaScript. Your CSV is never uploaded, logged or stored, so files containing customer or financial data stay on your machine.
Frequently asked questions
How do I extract specific columns from a CSV file?
Load the CSV so the tool can read your header row, then either tick the columns you want or type a selection such as email, 1, 3-4. Click Extract columns and you get a new CSV containing only those columns.
Can I reorder the columns while extracting them?
Yes. Typing a selection controls the order — city, name outputs city first even if name comes first in the file. Using the checkboxes instead keeps the original file order.
Are column indexes zero-based or one-based?
One-based, so the first column is 1. The checkbox list shows each column's number next to its name, which makes it easy to build a selection like 1, 4-6 without counting.
How do I remove columns instead of keeping them?
Choose the columns you want gone, then tick 'Invert — drop the chosen columns instead'. The output keeps every other column in its original order, which is quicker than listing the dozens you want to keep.
Is my CSV uploaded anywhere?
No. Parsing and extraction happen entirely in your browser using JavaScript. Nothing is transmitted or stored, so confidential exports never leave your computer.
Related tools
CSV Splitter
Split a large CSV into smaller files by rows per file or number of files, repeating the header in each part. Free online CSV splitter, 100% in your browser.
CSV Cleaner & Deduplicator
Clean CSV online: remove duplicate rows, trim whitespace, drop empty rows and normalise the delimiter. See before/after counts — 100% in your browser.
CSV Viewer & Table
View CSV as a clean HTML table online. Live search filter, row and column counts, delimiter and header options — all processed locally in your browser.
CSV to JSON Converter
Convert CSV to a JSON array of objects online. Header-row detection, comma/semicolon/tab delimiters and pretty-printed output — 100% in your browser.
TSV to CSV Converter
Convert TSV to CSV online, or CSV to TSV with one toggle. Fields with commas, quotes or newlines are quoted correctly. 100% local, in your browser.