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

Delimited text files (CSV, TSV, pipe-separated) are the most common format for exchanging structured data. This tool lets you extract specific columns, change the delimiter, delete unwanted columns, and transpose rows and columns — all without writing code or installing software.

Common Delimiters

CSV (comma) — most widely supported, requires quoting fields containing commas
TSV (tab) — less common but avoids quoting issues with text data
Pipe (|) — used in log files and some database exports
Semicolon (;) — common in European CSV files (Excel uses ; when the locale uses comma as decimal separator)

Frequently Asked Questions

Why does Excel open my CSV with semicolons?

In European locales, Excel uses semicolons as the CSV delimiter because commas are used as decimal separators. You can change this in regional settings or save with UTF-8 encoding and BOM.

Can I reorder columns?

Yes. In the column field, enter the numbers in the order you want them. For example, entering "3,1,2" in a 3-column file will put column 3 first, then column 1, then column 2.

Delimited Column Tools online

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

Common Delimiters

Frequently Asked Questions

Why does Excel open my CSV with semicolons?

Can I reorder columns?