CSV Column Extractor

What this tool does

The CSV Column Extractor takes a CSV file and lets you build a trimmed copy that keeps only the columns you want, in the order you want them. You drop a file or paste CSV text, the tool lists every column as a checkbox, and you tick the ones to keep. A live preview table shows the resulting CSV as you work, and you can copy it or download it as extracted.csv when it looks right.

A CSV — short for comma-separated values — is just a plain-text spreadsheet. Each line is a row, and the values on that line, separated by commas, are the cells. The first line is usually a header row naming each column. This tool reads that structure, shows you the columns by name, and rebuilds the file with your selection.

Why and when you’d use it

Real-world exports are almost always wider than you need. A CRM export of your contacts might have forty columns when you only care about name, email and company. A sales report might carry internal IDs, timestamps and notes that you do not want to hand to a colleague. Trimming columns is one of the most common data-cleaning steps, and doing it by hand in a spreadsheet — deleting columns one by one, then re-saving — is slow and easy to get wrong.

Typical reasons to extract columns:

• Sharing a safe subset. Send a vendor a contact list without the internal account numbers, lifetime-value figures or private notes.
• Prepping data for a pivot table or chart. Pivot tables are easier to read when the source has only the relevant fields.
• Reordering for an import template. Many tools expect columns in a fixed order; reorder once here instead of fighting the importer.
• Cutting a large file down to size. Fewer columns means a smaller, faster file to open and email.

How to use it

1. Drop a CSV file onto the upload area, or paste CSV text into the box. A sample loads automatically so you can see how everything behaves.
2. If the columns look wrong, change the Delimiter — try Auto-detect first, then Comma, Semicolon, Tab or Pipe. Toggle First row is a header if your file has no header line.
3. In the column list, tick the columns to keep and untick the rest. Use Select all, Select none or Invert to move quickly.
4. Reorder kept columns with the up and down arrows until the sequence matches what you need.
5. Check the live preview, then use Copy CSV or Download .csv to save the result as extracted.csv.

Common pitfalls and tips

Watch out for spreadsheet software changing your data when you re-open a CSV. Excel famously turns leading-zero values — ZIP codes like 02118, or SKUs like 00742 — into plain numbers, dropping the zero. If a column holds codes, keep the CSV as text and avoid round-tripping it through Excel. The same goes for long numbers, which Excel may show in scientific notation.

Mixed or unexpected delimiters are the other frequent surprise. If your preview shows everything crammed into one column, the delimiter is wrong; if it shows too many columns, a value probably contains the delimiter character. Quoted fields handle embedded commas correctly, so a properly quoted file parses cleanly. Finally, smart quotes and stray encoding characters can sneak in from copy-pasting out of a document — paste from a plain-text source when you can.

If you also need to drop unwanted rows rather than columns, the companion CSV Row Filter handles conditions like “status equals shipped”, and the CSV Merger combines several files into one. They all share the same parser, so a file that works here works there too.

Privacy

This tool runs entirely in your browser. The CSV you drop or paste is parsed, trimmed and re-serialised by JavaScript on your own device. It is never uploaded, never stored between visits and never logged. When you close the tab, the data is gone — which makes the extractor safe for customer lists, financial exports and any file you would rather keep off the network.