CSV Column Extractor
Extract CSV columns by number or name. Handle comments & empty lines. Perfect for data analysis, CSV processing, and column-based data extraction.
Input CSV
Sample CSV Data
Extracted Column
0 columns • 0 rows • 0 characters
🛠 Tool Options
Column to Extract
Specify the column positions or a range. For example, «1», «1, 2, 5», «1-4», or «1-4, 6».
Specify the column name.
In cases when a CSV file has multiple columns with the same name, extract all of them.
Output Column Format
Choose how to output the columns — as CSV, JSON, or plain text.
Specify a symbol that starts comments in the CSV.
Activate to remove empty lines from the extracted column.
About CSV Column Extractor
The CSV Column Extractor allows you to extract specific columns from CSV data using various methods. This is particularly useful for data analysis, processing large datasets, and isolating specific information.
Extraction Methods:
- By Number: Extract columns by their position (1, 2, 3, etc.)
- By Name: Extract columns by their header names
- Range Support: Use ranges like «1–4» or combinations like «1,3,5–7»
- Multiple Copies: Extract all columns with the same name
Output Formats:
- Plain Text: Simple text output, one value per line
- CSV Format: Proper CSV with headers and comma separation
- JSON Format: Structured JSON array of objects
Processing Options:
- Comment Handling: Skip lines that start with comment symbols
- Empty Line Removal: Filter out empty rows from the data