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 — Extract, Reorder, CSV/TSV Convert

How to Use delimited-column-tools

Paste your delimited data into the input.
Specify the current delimiter (comma, tab, pipe, semicolon, or custom).
Choose an operation: Extract, Delete, Reorder, or convert delimiter.
Copy the output or download it as a file.

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 tool manipulates columns across all delimiter types in one place, handling the quoting complexity that makes delimited text tricky to process by hand.

Working with Delimited Data

Not all delimited files are CSV. Log files often use pipes (|) or spaces. Billing exports may use semicolons. Internal tools may generate tab-separated data. This tool accepts any single-character delimiter and applies column operations — extract, delete, reorder — using the same underlying parser that handles quoted fields correctly regardless of the delimiter used.

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

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.

Delimited Column Tools online

Extract, reorder columns and convert between CSV, TSV, pipe, and other delimiters — runs in your browser