Home › Developer Tools › CSV Column Extractor
CSV Column Extractor
Pull just the columns you need out of a CSV file. Tick the columns to keep, drag them into a new order, rename headers, and filter rows with conditions like "status equals shipped" or "amount > 100". Export the result as CSV or JSON.
Last updated:
1. Choose, order & rename columns
Tick the columns to keep. Drag a row or use the arrows to change the order; type a new name to rename.
2. Filter rows (optional)
Keep rows that match
of these filters:
3. Output
Advertisement
Advertisement
How to use the CSV Column Extractor
- Open your CSV or paste the data; the delimiter and columns are detected automatically.
- Tick the columns to keep, drag them into the order you want and type new names where needed.
- Add filters (optional) to keep only matching rows, for example country equals US.
- Choose the output: CSV with any delimiter, or JSON.
- Check the preview and click Download or Copy.
Filter conditions
| Condition | Keeps rows where the cell… | Example |
|---|---|---|
| contains / does not contain | includes (or lacks) the text anywhere | email contains @gmail. |
| equals / does not equal | is exactly the value (spaces at the ends ignored) | status equals shipped |
| starts with / ends with | begins or ends with the text | sku starts with LMP- |
| >, ≥, <, ≤ | is larger or smaller; numbers numerically, other text in natural order | date ≥ 2024-03-01 |
| is empty / is not empty | has no value (or has one) | phone is not empty |
| matches regex | matches a JavaScript regular expression | zip matches ^\d{5}$ |
Common uses
- Mailing lists: keep only name and email from a CRM export, filtered to subscribers who opted in.
- Imports with a fixed layout: reorder and rename columns to match the template another system expects.
- Privacy: drop sensitive columns (phone numbers, addresses) before sharing a file.
- Quick JSON: turn selected columns into JSON for an app or test fixture. For full-file conversion see CSV to JSON, and to remove repeated records use the CSV Duplicate Row Remover.
Frequently asked questions
How do I extract specific columns from a CSV file?
Open the CSV, then tick only the columns you want in the column list. The preview updates immediately; click Download CSV to save a new file containing just those columns, in the order shown.
Can I change the order of the columns?
Yes. Drag a column by its handle, or use the up and down arrow buttons (which also work with the keyboard). The output follows the order of the list.
How do I rename a column?
Click the column name in the list and type a new one. The new name is used as the header in the CSV or as the key in JSON; the original name is shown underneath for reference.
How do the row filters work?
Each filter tests one column with a condition such as contains, equals, is empty, greater than or a regular expression. With several filters you choose whether a row must match all of them (AND) or any of them (OR). Text comparisons ignore case unless Case-sensitive is ticked.
How are greater than and less than compared?
If both the cell and the filter value are numbers, they are compared numerically (1,200 counts as 1200). Otherwise they are compared as text in natural order, which works for ISO dates such as 2024-03-15.
Can I convert the extracted columns to JSON?
Yes. Choose JSON (array of objects) to get one object per row keyed by the column names, or JSON (array of arrays) for a compact table. Numbers and true/false values can be output as real JSON types.
Is my file uploaded?
No. The CSV is parsed and filtered entirely in your browser, so it never leaves your device.
Are all the tools on FreeToolCabin tested for quality and accuracy?
Yes! Every tool on our site undergoes automated Q/A testing in real browser environments to ensure high precision, correct output, and zero errors. If you happen to spot a bug or have a suggestion, please contact us at [email protected] and our team will review it right away.
Related tools
CSV ViewerOpen a CSV or TSV file as a sortable, filterable table.CSV to JSONConvert CSV data to JSON with live preview.CSV Duplicate Row RemoverRemove duplicate rows from a CSV by all or selected columns and download the cleaned file.CSV SplitterSplit a large CSV into smaller files by row count, file count or column value, header kept.Merge Lines Side by SideCombine two to four lists line by line with any separator, padding or filling uneven lengths.One Word Per LineSplit any text into a list with one word per line; strip punctuation, dedupe, lowercase and sort.JSON to Excel ConverterTurn JSON into a styled .xlsx spreadsheet; nested arrays become their own linked sheets.JSON to CSVConvert JSON data to CSV for spreadsheets.Excel to CSVConvert XLSX spreadsheets to CSV.Excel Viewer (XLSX / XLS)Open XLSX, XLS and ODS spreadsheets in your browser without Excel.Line Ending ConverterConvert text and files between CRLF, LF and CR line endings.Markdown to HTMLConvert Markdown to clean HTML with a live editor.XML to JSONConvert XML to JSON with validation.Text Encoding ConverterDetect and convert text file encodings like UTF-8, UTF-16 and Latin-1.JSON ViewerExplore JSON as a collapsible tree, search keys and values and copy any node's path.TTF to WOFF2 ConverterConvert TTF and OTF fonts to WOFF2 or WOFF and get a ready @font-face CSS snippet.Chmod CalculatorConvert Linux file permissions between checkboxes, octal (755) and symbolic (rwxr-xr-x) notation.JSON to TypeScriptGenerate TypeScript interfaces or types from JSON, with nested types and optional fields.Morse Code TranslatorTranslate text to Morse code and back, then play it as sound or a blinking light, or save a WAV.HTML Table GeneratorBuild HTML tables in an editable grid with styles, header rows, CSV import and live preview.Hex to Text ConverterConvert hex to text and text to hex with UTF-8 support and space, 0x, \x or comma formats.JSON to XML ConverterConvert JSON to well-formed XML with attributes, arrays and pretty print.JSON to YAML ConverterConvert JSON to clean YAML as you type, with indent, quoting and sort options.YAML to JSON ConverterConvert YAML to pretty or minified JSON, with errors pinned to the exact line.HTML to Markdown ConverterTurn HTML or pasted rich text into clean Markdown with tables and live preview.Markdown Table GeneratorBuild Markdown tables in a grid or paste from Excel/CSV, with alignment and preview.JSON ValidatorCheck JSON with the exact line and column of each error, fix tips and one-click auto-fix.Image to Base64Convert images to Base64 data URIs, CSS backgrounds and HTML img tags in your browser.Base64 to ImagePaste a Base64 string or data URI to preview, identify and download the image.JSON CompareCompare two JSON documents and see every added, removed and changed path.Hex to DecimalConvert hex to decimal instantly with steps and signed mode.Decimal to HexConvert decimal to hex instantly with steps and signed mode.Binary to DecimalConvert binary to decimal instantly with steps and signed mode.Decimal to BinaryConvert decimal to binary instantly with steps and signed mode.Two's Complement CalculatorDecimal to two's complement binary and back for 4-64 bits, with invert-and-add-1 steps.XML to CSV ConverterConvert XML to CSV: detects repeating records, flattens nested data, pick your columns.CSV to XML ConverterConvert CSV to well-formed XML with custom root and row names, escaping and pretty print.TOML to JSON ConverterConvert TOML to JSON and JSON to TOML with a full v1.0 parser and clear error lines.JSONL to JSON ConverterConvert JSON Lines / NDJSON to a JSON array and back, with line-level error reports.Properties to YAML ConverterConvert Java .properties to nested YAML (application.yml) and YAML back to properties.PX to EM ConverterConvert pixels to em using the parent font size, and em back to px, with conversion tables.Query String to JSONConvert URL query strings to JSON with nested brackets and arrays, and JSON back to a query string.REM to PX ConverterConvert CSS rem values to pixels for any root font size, with a quick 0.25–6rem table.SQL to JSON ConverterConvert SQL INSERT statements and dumps into a JSON array of row objects, with CSV export.TSV to CSV ConverterConvert TSV to CSV and back, or between tab, comma, semicolon and pipe, with correct quoting.TypeScript to JavaScriptConvert TypeScript or TSX to clean JavaScript instantly: strip types, keep or compile JSX.XML to YAML ConverterConvert XML to clean YAML with attributes, text nodes, lists and exact error lines.YAML to XML ConverterConvert YAML to pretty, well-formed XML with custom root, attributes and array item tags.Boolean Algebra SimplifierSimplify boolean expressions or minterm lists to minimal SOP and POS with Quine-McCluskey steps.Compare Excel FilesCompare two Excel spreadsheets cell by cell, highlight changes and export a diff report.CSV CleanerClean messy CSV in one click: trim spaces, drop empty rows and columns, fix headers, dedupe.CSV VLOOKUP ToolJoin two CSV or Excel files on a key column like VLOOKUP, with left, inner and full joins.Remove Duplicates in ExcelFind and remove or highlight duplicate rows in XLSX or CSV files by the columns you choose.GeoJSON ViewerView GeoJSON on a map, inspect and edit properties, validate against RFC 7946 and export.GPX ViewerOpen GPX tracks on a map with distance, elevation profile, moving time, speed and splits.JSON Repair ToolFix broken JSON automatically: trailing commas, quotes, comments, truncated data, with a diff.Karnaugh Map SolverSolve 2–6 variable K-maps: click cells or enter minterms to get the minimal SOP or POS with groups.Merge Excel FilesCombine XLSX, XLS and CSV files into one workbook or append all rows into a single sheet.Parquet File ViewerOpen Apache Parquet files in your browser: schema, rows, filters and CSV or JSON export.Query CSV with SQLRun SQL on CSV, Excel, JSON and Parquet files in your browser with DuckDB. Join and export.Online Serial MonitorTalk to Arduino, ESP32 and USB serial devices in your browser: log, send, plot and save.Split Excel FileSplit an Excel sheet into several files by row count or by each value in a column, as ZIP.SQL Create Table GeneratorDefine columns, keys, defaults and indexes; get CREATE TABLE SQL for MySQL, Postgres and more.SQL IN Clause GeneratorTurn a pasted list into a SQL IN ('a','b') clause with quoting, dedupe and 1,000-item chunks.SQL Online CompilerRun SQL queries online on SQLite with sample databases, a result grid, CSV export and .db save.SQL to ER DiagramPaste CREATE TABLE statements and get an entity-relationship diagram with keys and links.XML to XSD GeneratorGenerate an XML Schema (XSD) from sample XML: types, occurrences, attributes and namespaces.XML ValidatorCheck if XML is well-formed, see the exact line and column of each error and pretty-print it.