How do I convert CSV to TSV?

Set input delimiter to comma, output delimiter to tab, select 'Convert delimiter', and click Run. The commas separating columns are replaced with tab characters.

How do I extract column 2 and 4 from a pipe-delimited file?

Set the input delimiter to pipe (|), enter '2,4' as the column selection, and click Run. Columns 2 and 4 will be extracted.

Delimited Column Tools - Free Online CSV & TSV Column Extractor

How to Use This CSV & TSV Column Extractor

Paste your delimited data into the input field.
Specify the current delimiter (comma, tab, pipe, semicolon, or custom).
Choose an operation: Extract, Delete, Reorder, or convert delimiter.
The output is processed instantly in your browser for fast results.

Delimited Column Tools provides a fast and efficient way to manipulate tabular data without the overhead of a spreadsheet application. Delimited text files - CSV, TSV, pipe-separated, and custom formats - all share the same fundamental structure: values separated by a specific character, with optional quoting. This delimited data tool serves as a versatile csv column editor that handles the quoting complexity that makes delimited text tricky to process by hand.

Advanced CSV and Tabular Data Manipulator Features

Not all delimited files are standard CSV. Log files often use pipes (|) or spaces, while legacy billing exports may use semicolons. This TSV column extractor and delimited column tools utility accepts any single-character delimiter and applies column operations - extract, delete, reorder - using a robust parser. Whether you need to swap csv columns for a database import or extract columns from file for a report, this tool provides the precision needed for professional data cleaning and tabular data manipulator tasks.

Supports comma, tab, pipe, semicolon, space, and custom single-character delimiters
Extract specific columns by position or header name
Reorder or delete columns with a comma-separated column list
Convert delimiter from any format to any other instantly

Frequently Asked Questions

What is the difference between this tool and CSV Column Tools?

CSV Column Tools is specifically for comma-delimited files. This tool is delimiter-agnostic - it accepts any delimiter character, making it suitable for TSV, pipe-separated, and other formats that CSV Column Tools would misparse.

How do I extract columns by name vs by position?

If row 1 is a header row, you can reference columns by their header name. With "No header" selected, columns are referenced by position number (1-indexed). You can mix both in the same operation.

Does it handle quoted fields?

Yes - the parser implements RFC 4180-style quoting for any delimiter. A field containing the delimiter character is enclosed in double quotes; a double quote inside a quoted field is escaped as two consecutive double quotes.

Can I handle files with irregular numbers of columns?

Yes - rows with fewer columns than the maximum are padded with empty fields in the output. Rows with extra columns are included with the additional cells.

See also CSV Column Tools, CSV Delimiter Changer, and TSV Column Tools to build a complete data pipeline with this Delimited Column Tools.