LocalToolsOffline browser tools collection

Category: Developer tools

CSV Column Extractor

System ideaMissing a tool?

Pull specific columns out of CSV data by index or name

Paste CSV data and list the columns to keep, by 1-based position or by header name, to produce a smaller CSV with just those columns, in the order you listed. Runs entirely in your browser.

Extracted 2 column(s) from 3 row(s).

JSON
role,name
Engineer,Ada Lovelace
Admiral,Grace Hopper
Tester,"Doe, John"
Download CSVDownload CSV

Everything on this page is processed in your browser. Nothing is uploaded.

What this tool does

A wide export often has far more columns than the next step needs. This tool parses comma, semicolon or tab separated CSV, including quoted fields, and lets you pick columns either by their position (1, 2, 3...) or, when the first row is a header, by name. The output keeps the columns in the order you listed them, so listing '3, 1' reorders as well as filters.

How to use it

  1. Paste your CSV data into the input box, or load the example.
  2. List the columns to keep, separated by commas, by index or by header name.
  3. Copy the resulting CSV or download it as a file.

Privacy

This tool runs entirely in your browser. Your input is never uploaded, stored or shared — closing the tab removes it.

Frequently asked questions

Is my CSV data uploaded anywhere?
No. Parsing and extraction happen in JavaScript running in the page, so spreadsheet exports never leave your device.
Can I select columns by name instead of position?
Yes, as long as "First row is a header" is on. Type the exact header text, or use a 1-based column number either way.
What happens if a requested column does not exist?
It is skipped and named in a warning above the output, so a typo does not silently produce an empty column.

Back to all tools