CSV Column Selector
Keep only the columns you need, or drop the ones you do not, by header name or position. The order you type is the order you get. Your CSV never leaves your browser.
- No email required
- Stays on your device
- By name or number
- Reorders as you type
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
CSV column selector in three steps
No account, no email, no waiting for an upload.
- STEP 01
Add your CSV
Paste text or open a .csv, .tsv, .tab or .txt file.
- STEP 02
List the columns
Type header names or numbers separated by commas, such as name, email or 1, 3, 5-7. Choose Keep or Remove.
- STEP 03
Copy or download
The result keeps your separator and shows how many columns remain.
What CSV column selector does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Names, numbers and rangesMix header names (case-insensitive), column numbers starting at 1, and ranges like 5-7.
- Keep mode reordersColumns appear in the order you list them, so you can rearrange while selecting.
- Remove modeName the columns to drop, and everything else is kept in its original order.
- Helpful mistakesIf a name is not found, the message lists your actual column names.
- Works with no headerTurn off the header option and select by number only.
Good to know
- Exact namesNames must match a header (ignoring case). A header with a trailing space needs the space matched too, so check it in the CSV viewer.
- Commas in header namesBecause the list is comma-separated, use the column number for headers that contain commas.
- At least one column must remainRemoving every column is refused.
Your data never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use CSV column selector
Strip sensitive columns before sharing
Remove emails, phone numbers or IDs from an export.
Shrink a file for import
Keep only the fields your target system needs.
Prepare a chart
Take two columns and send them to a plotting tool.
Rearrange for a template
Put columns in the order an uploader expects.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
Writing the column list
Use commas between entries. Entries can be a header name, a column number counted from 1, or a range with a dash. So id, name, 4-6 keeps the id and name columns and the fourth to sixth columns, in that order.
The Keep option uses your order. The Remove option ignores the order and keeps the remaining columns where they were.
Common patterns
A few examples you can adapt:
- Keep email, name: a contact list with two columns.
- Remove ssn, notes: take sensitive fields out.
- Keep 1-3: the first three columns of any file.
- Then sort with the CSV sorter or remove duplicates with the CSV deduplicator.
An example: CSV column selector
A customer export has id, name, email, phone, notes and country. To share a version for analysis, choose Remove and list email, phone, notes. To build an upload for a mailing tool, choose Keep and list email, name, country. The order you type is the order of the columns in the result.
Questions, answered
How do I remove columns from a CSV?
Choose Remove, type the column names or numbers, and copy the result.
Can I reorder columns?
Yes. In Keep mode, columns come out in the order you list them.
Can I strip sensitive columns without uploading the file?
Yes. Columns are removed by script in this tab, so neither the original nor the result is sent anywhere.
Can I select by position?
Yes, use numbers from 1 or ranges like 2-4.
What if a column name is not found?
You get a message listing the column names the file actually has.
Can I trim columns from my phone?
Yes. Type the column names in a current mobile browser, then copy or save the trimmed CSV.