Extract Column from CSV/TSV - Online Column Extractor
Quick Tips
- • This tool runs entirely in your browser - your data stays private.
- • Press Ctrl+V (Cmd+V on Mac) to quickly paste text.
- • Use the Copy button to save your result to clipboard.
- • Bookmark this page for quick access!
Extract a specific column from CSV, TSV, or delimited text data.
Examples
Name,Email,Phone John,john@email.com,555-1234 Jane,jane@email.com,555-5678
john@email.com jane@email.com
ID Product Price 001 Widget 9.99 002 Gadget 19.99
Product Widget Gadget
red|large|10 blue|small|5 green|medium|8
large small medium
Frequently Asked Questions
Enter the column number starting from 1 (not 0). So for data like "name,email,phone", column 1 is name, column 2 is email, and column 3 is phone. You can also extract multiple columns by specifying a range or comma-separated list.
Rows that don't have enough columns for your requested column number are safely skipped. The tool extracts what it can without causing errors, making it robust for inconsistent real-world data.
This tool performs simple delimiter-based splitting. For CSV files with commas inside quoted fields (like "Smith, John"), use our CSV to JSON converter which properly handles RFC 4180 compliant CSV with quotes.
Toggle the "Skip first row" option to exclude the header from your extracted results. This gives you only the data values without the column name.
Yes, you can specify multiple column numbers separated by commas. The extracted columns are combined in the order you specify, allowing you to reorder or subset your data.
Related Tools
Column Swapper
<p>Our Column Swapper tool rearranges columns in delimited t...
Merge Columns
<p>Our Merge Columns tool combines multiple columns into a s...
List to CSV Row
<p>Our List to CSV converter transforms line-separated lists...
Split Text
<p>The <strong>Split Text Tool</strong> is an essential util...
Join Text
Join multiple lines into a single line with a custom delimit...