Delimiter Converter

Convert tabular text between comma, tab, semicolon, pipe, space and newline delimiters, or any separator you type, with quoted-CSV field handling.

Wrap

A column of ids becomes (‘a’, ‘b’, ‘c’) in one pass.

Result
Result: 4 lines, 63 characters
name	age	city
Ada	36	London
Alan	41	Cambridge
Grace	45	New York

Swap the delimiter in tabular text

Paste rows of data and instantly re-separate the columns with a different delimiter. Pick the delimiter your data currently uses under From delimiter, choose the one you want under To delimiter, and the result updates live as you type. Common conversions include CSV to TSV (comma to tab), pipe-delimited logs to CSV, and semicolon-separated European spreadsheets to standard comma format. Copy the converted output with one click.

How the conversion works

Each line is split on the source delimiter and its fields are rejoined with the target delimiter, so your row structure is preserved exactly — blank lines stay blank and, when you convert between two column delimiters, a row in is a row out. New line is the exception: as the source it reads the whole box as one list, one value per line, and answers with a single joined line; as the target it puts every field on its own line. Supported delimiters are comma, tab, semicolon, pipe, space and new line, plus Anything else…, a box you type your own separator into — spaces included, so a two-character separator like a comma and a space works. A Wrap row adds text before and after each field and around the whole row, with SQL list and Array presets, so a pasted column of ids becomes a quoted SQL list in the same pass. The delimiters, the wrapping and the quoted-fields switch are remembered on this device until you press Forget saved settings. Handle quoted fields (CSV) is on to begin with: the input is parsed as RFC-4180 CSV, so double-quoted fields that themselves include the delimiter (as real CSV exports have) stay whole, and the output is re-quoted only where the new delimiter requires it. Turn it off for a plain character replacement per column, which is fast and predictable.

Frequently asked questions

Which delimiters can I convert between?

Comma, tab, semicolon, pipe, space and new line — in any direction. There is also an Anything else… box for a separator you type yourself, spaces and several characters included, so a comma-and-space list works too. This covers CSV, TSV, pipe-delimited, space-separated and one-value-per-line data.

Does it handle quoted fields that contain the delimiter?

Yes, as long as "Handle quoted fields (CSV)" is on. In that mode the input is parsed as RFC-4180 CSV, so a double-quoted value containing the source delimiter (or newlines, or escaped quotes) stays as a single field, and output fields are re-quoted only when they contain the new delimiter. Turned off, the tool does the faster plain split-and-join.