CSV Column Extractor / Reorder

Drop a CSV in, pick the columns you want (and the order you want them in), get a clean output you can paste, copy, or download. Useful when an export has 50 columns and you only want 5 — saves the round trip through Excel just to delete a few columns. Handles RFC 4180 quoting properly so fields with commas and newlines survive.

How to use the CSV Column Extractor / Reorder

Paste a CSV (or load a file). The header row is auto-detected; each column becomes a draggable chip in the picker area. Drag chips into the desired order, or click to toggle inclusion. Hit Extract to get the reordered CSV with only the picked columns. Quoting is RFC 4180 compliant on both parse and emit, so a column containing commas or newlines round-trips cleanly.

About CSV Column Extractor / Reorder

Most BI exports include far more columns than you need for the next step — a Snowflake report dump might have 80 columns when you only want 6 for the slide deck. Excel’s column-delete workflow becomes painful past a dozen columns; the spreadsheet might also auto-coerce types and mangle leading-zero IDs or long numbers. This tool keeps the CSV exactly as you pasted it (no type coercion, no encoding changes), gives you a fast picker for which columns to keep, and lets you reorder them too.

Behind the scenes, the parser handles all the RFC 4180 edge cases: quoted fields with embedded commas, doubled-quote escaping (""), embedded newlines inside quoted fields, varying line endings. The output uses the same dialect as the input — commas and CRLF, no quoting where unneeded. Everything runs in your browser so production exports stay private.

Common use cases

  • BI report trimming — turn a 50-column Snowflake / Looker / Tableau export into a 5-column CSV for sharing.
  • Pre-processing for spreadsheets — reorder columns so the most-important ones are first, then paste into a smaller sheet.
  • Privacy passes — drop PII columns (email, name, phone) before sending a sample to a vendor or external team.
  • Database import prep — reorder columns to match a target table’s column order so COPY works without explicit column lists.

Frequently asked questions

Does it handle CSV without a header row?
It assumes the first row is the header. For headerless CSVs, prepend a synthetic header (col1,col2,col3) before pasting.

What's the file size limit?
Tested up to ~100MB browser-side. For larger files use a CLI like csvkit (csvcut) or xsv select.

Can it filter rows too?
No \xE2\x80\x94 columns only. For row filtering, pipe through csvkit (csvgrep) or use a quick query in our JSONPath tester after converting via CSV to JSON.