Data and JSON tools Free · No sign-up · No upload

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
Your data
Header names or column numbers, separated by commas
  • Runs on your device. Files are never uploaded.
  • Free and unlimited. No sign-up, no watermark.
Private: processed in your browserNo upload waitIN: CSV → OUT: CSV
How was CSV column selector?
How it works

CSV column selector in three steps

No account, no email, no waiting for an upload.

  1. STEP 01

    Add your CSV

    Paste text or open a .csv, .tsv, .tab or .txt file.

  2. 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.

  3. STEP 03

    Copy or download

    The result keeps your separator and shows how many columns remain.

What you get

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.
Private by design

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 device→Their server→Your device

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

Your device does all the work

The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.

Made for real work

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.

Compare

Mediaextractr vs typical upload tools

MediaextractrPrivateTypical upload tools
Your file is uploadedNeverYes
Sign-up neededNoOften, after a few files
Daily file limitNoneOften 1–2 free files
WatermarkNeverSometimes
Wait for upload & downloadNoYes
Speed on very large filesDepends on your deviceDepends 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.

FAQ

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.