convert

Select CSV Columns

Keep, reorder or remove CSV columns by name or number to trim a file down to what you need.

Runs on your deviceBatch readyPaste textNew

Paste or drop

Paste text below, or drop a file instead.

0 chars · 0 lines
…or drop a file
Drag and drop, or choose files
CSVTSVTXT

Choose an output

Keep, reorder or remove CSV columns by name or number to trim a file down to what you need.

Fine-tune

Optional — sensible defaults are already set.

Action

About Select CSV Columns

This tool trims a CSV down to the columns you need. You list columns by header name or number, and the tool either keeps them in the order you typed or removes them and keeps everything else. It suits wide exports from CRMs, analytics tools and databases that have dozens of fields you don't need.

When it helps

  • Removing personal fields like phone numbers or addresses before sharing a dataset.
  • Keeping only name and email from a full CRM export for a mailing tool.
  • Rearranging columns to match the order an import template requires.

Tips

  • Mix names and numbers, and use ranges for runs of columns, for example: name, email, 5-8.
  • In "Keep" mode the output follows the order you typed, so the tool also works for reordering columns.
  • Header names are matched exactly first, then without regard to case or surrounding spaces. If a name isn't found, the error lists the available headers.
  • Turn off "First row is a header" for files without headers, and refer to columns by number.

Good to know

Quick answers about select csv columns in your browser.

Yes. Choose "Keep these columns" and list every column in the new order, for example 3, 1, 2, 4-10.

If a header with that exact text exists, it is treated as that column. Otherwise text like 2-4 is read as a range of column numbers.

Yes. There is no sign-up, no watermark and no limit on how many files you process.

No. Files are read and processed locally in your browser, so they never leave your device.

Related tools

PDFSheet to CSVConvert the first worksheet or table to CSV.DATEPUB to PDFConvert EPUB text to a simple PDF.DATEPUB to HTMLExtract EPUB spine documents into one HTML file.DATEPUB to TXTExtract readable text from an EPUB.DATCSV/TSV to JSONConvert delimited data to JSON records.DATJSON to CSVConvert a JSON array or object collection to CSV.DATJSON to TSVConvert JSON records to TSV.DATData to HTMLRender data as a portable HTML table.TXTNewWord Frequency CounterList every word in your text with how often it appears, ranked and exported as a CSV spreadsheet.

Part of the CSV Tools collection.