CanDoYa
All tools
Saved toolsYour favorites

Add to favorites

Saved in this browser only.
Private browser utility / Developer

Free CSV Column Extractor

Runs entirely in your browser - no upload, no sign-up.

Live workspaceLocal processing

CSV source

Paste data or choose a CSV, TSV, or text file.

or drop a file here
5 MB, 100,000 rows, and 500 columns max
Your columns will appear herePaste CSV, choose a file, or load the example to start selecting fields.
Share this tool
csv column extractor / browser utility
01 / Overview

What is a CSV column extractor?

A CSV column extractor keeps only the fields you choose from a comma-separated or delimited file. Paste or open data, select columns by their heading and physical position, reorder them, preview the smaller table, then copy or download every row as a new CSV without uploading the source.

02

How to use

  1. 01
    Add the source

    Paste CSV text, choose a local file, drop one into the source panel, or load the example.

  2. 02
    Confirm parsing

    Leave delimiter detection on automatic or choose comma, semicolon, tab or pipe, then set whether the first row contains headings.

  3. 03
    Select and order fields

    Analyze the source, check the columns to keep, and move selected fields earlier or later.

  4. 04
    Export the result

    Review the first rows, copy the complete CSV, or download it as a UTF-8 file.

03

Who it's for

  • Operations teams trimming customer or order exports before a focused import or handoff.
  • Analysts rearranging identifiers, dates and measures into the exact order a report expects.
  • Developers reducing large fixtures to the fields needed for tests, migrations or debugging.
  • Researchers removing sensitive or irrelevant columns before sharing a smaller dataset.

This extractor parses records before it selects fields, so a comma or line break inside a quoted cell does not shift later columns. It accepts comma, semicolon, tab and pipe delimiters, removes an optional UTF-8 byte-order mark, handles CRLF or LF records, and decodes doubled quotes.

Blank and repeated headings stay intact in the exported file. The selector adds a unique display label and column number only in the interface, so you can choose the right physical field without silently renaming source data. Short rows receive an empty cell for a missing selection; wider rows remain selectable.

FAQ

Is my CSV uploaded?

No. File reading, delimiter detection, parsing, column selection, preview and export all happen inside your browser. The tool does not send the rows to a conversion service. You can inspect the result and download it without creating an account or transferring the source file.

Is the CSV column extractor free?

Yes. You can paste or open a file, select and reorder columns, copy the complete result and download a CSV without payment or sign-up. The visible size, row and column limits exist only to keep the page responsive on typical phones and computers.

How large a CSV file can I process?

The browser tool accepts up to 5 MB, 100,000 data rows and 500 columns per source. It stops with a specific message instead of silently truncating the output. Split a larger dataset first or use a streaming desktop tool when every record must be retained.

Can I extract more than one CSV column?

Yes. Every detected field appears in a checklist. Keep any number of columns, clear the selection to start over, and move selected fields earlier or later. The preview and exported CSV follow the selected order while the original data-row order stays unchanged.

Does it handle quoted commas, newlines and double quotes?

Yes. Fields enclosed in double quotes may contain delimiters or line breaks, and two adjacent quotes inside a quoted field become one literal quote. Malformed input, such as a missing closing quote or text after a closing quote, produces a repair message beside the source.

What happens with blank or duplicate column headings?

The selector shows each field's physical column number and gives blank or repeated headings a unique display label. Export does not replace the source heading, so blank and duplicate names remain exact. This prevents a selection mistake without rewriting the schema behind your back.

Can I use TSV or semicolon-separated data?

Yes. Automatic detection checks comma, semicolon, tab and pipe separators in the first complete record, ignoring delimiters inside quotes. You can override that guess. Regardless of the input separator, copied and downloaded output uses standard comma-separated CSV with CRLF record endings.

Will spreadsheet values or formatting change?

The extractor preserves cell text and does not infer numbers, dates or booleans. Missing selected cells become blank, and values containing commas, quotes, line breaks or edge whitespace are quoted correctly in the output. Spreadsheet applications may still apply their own display or type formatting when opening the file.