Developer tools

CSV delimiter change: comma, semicolon, tab or pipe

This tool changes the delimiter of a CSV file. It reads comma, semicolon, tab or pipe-separated text and writes it again with the separator you pick, and every field keeps its text, including commas and line breaks inside quotes. It runs in your browser; you copy the result or download it as CSV or TSV.

Processed in your browser

Paste CSV or open a UTF-8 file.

Conversion options

Quoted line breaks inside fields stay unchanged. Convert again after changing options.

Enable JavaScript to convert CSV.

How to change the CSV delimiter

Paste CSV into the Input CSV box, or select Open UTF-8 file to read a .csv, .tsv or .txt file. A file is converted as soon as you choose it, with the current options. Input delimiter starts on Auto-detect, which tries comma, semicolon, tab and pipe.

Output delimiter starts on Semicolon. Quoting and Record separators set which fields get quotes and how records end. Changing any option clears the old output, so select Change delimiter again.

The Converted output panel shows the number of records, the most fields in one record, the output size and the delimiter that was read. Inspect tabs, line endings and escaped characters shows the output as a JSON string, so a tab or a CRLF is visible.

  1. Add your data

    Paste CSV or select Open UTF-8 file. A chosen file converts immediately with the current options.

  2. Choose the format

    Check Input delimiter, then choose Output delimiter, Quoting and Record separators. Select Change delimiter.

  3. Save your result

    Check the output, then select Copy output or Download CSV. Tab output downloads as TSV.

Example: semicolons to commas

Excel saves CSV with the list separator from the region settings, which is a semicolon in many countries that write decimals with a comma. Take name;price;date then Tea;3,50;01.02.2026 then Coffee;12,00;15.03.2026. Auto-detect reads the semicolon, and with Output delimiter set to Comma the result is name,price,date then Tea,"3,50",01.02.2026 then Coffee,"12,00",15.03.2026.

The prices now contain the new delimiter, so they get double quotes and each stays one field. Nothing else in those rows needed quotes.

Load example shows the other direction. One of its fields holds a comma, a semicolon and a pipe. With Semicolon or Pipe output, that field keeps its quotes.

With Tab (TSV) the same field loses them, because it holds no tab, quote or line break. Converting the example to semicolons and back to commas gave the same text in a check.

Quoting, line endings and values

Quoting has two settings. Necessary fields quotes a field when it holds the output delimiter, a double quote, a line break, or a space at its start or end, and it always quotes an empty field. All fields wraps every value in quotes. In both, a quote inside a field is doubled, so x"y becomes "x""y".

Record separators sets the break between records: LF, the default, or CRLF, the break that RFC 4180 names for CSV. A line break inside a quoted field is kept as it was. The output is UTF-8 with no byte order mark and no line break after the last record.

File input keeps line breaks inside quoted fields. Pasted text uses the browser's LF line endings, and clipboard line endings can follow your operating system. Download preserves the exact output bytes.

Values stay text. In a check, 007 kept its leading zeros, 12345678901234567890 kept every digit, and =SUM(A1) stayed as written. There is no header setting: the first row is converted like any other, and rows of different lengths stay that way.

Duplicate or blank headers, surrounding spaces and empty fields also stay as text. Spreadsheets can interpret formulas, dates and numbers when opening the result. Import columns as text to keep their literal values.

Limits

The tool changes separators, quoting and record line endings, and nothing else. It does not remove or reorder columns, trim spaces, change the encoding, or rewrite formulas and dates. It reads UTF-8 only: a file in another encoding stops with an error, and so does a quoted field that never closes, with no partial output.

A UTF-8 file can begin with a byte order mark. Its extension and file type do not select the delimiter. Input record breaks can be LF, CRLF or CR. Empty input gives zero records; blank records before a final line break remain and export as quoted empty fields.

Auto-detect looks at the first 10 records and can be unsure, for example with a single column. Then it uses comma and says so. Choose the Input delimiter yourself when that happens. Comma, semicolon, tab and pipe are the only choices, on both sides.

The tool sets no cap on rows or file size. In a Node check of the same code, a header and 100,000 rows of 20 columns gave 16,777,869 bytes of output. The browser's memory and text length limits set the real ceiling. The complete input, parsed records, output and escaped preview use memory, so a large file can fail. Cancel stops a run and keeps your input.

Questions

How do I change the separator in a CSV file?

Paste the CSV or select Open UTF-8 file, leave Input delimiter on Auto-detect, and choose the new separator under Output delimiter. Select Change delimiter, then Copy output or Download CSV. Every record is written again with the new separator, and a value that now contains it gets quotes, so no field is split.

Is CSV always comma delimited?

No. The name means comma-separated values, but many files use semicolons, tabs (often called TSV) or pipes. Excel writes CSV with the list separator from the region settings, which is a semicolon in many countries that use a decimal comma. Auto-detect on this page tries all four.

What is a CSV delimiter?

It is the character that separates one field from the next in a record. A comma is the usual one. A value that contains the delimiter is wrapped in double quotes, so 3,50 in a comma file is written as "3,50". Records are separated by line breaks, which Record separators sets here.

Can I convert TSV to CSV, or CSV to TSV?

Yes. For TSV to CSV, leave Input delimiter on Auto-detect or pick Tab (TSV), and choose Comma under Output delimiter. For CSV to TSV, choose Tab (TSV) as the output; the button then reads Download TSV and saves converted.tsv. A field that contains a tab gets quotes, so it stays one field.

Will my data change?

Field text stays the same. Leading zeros, long numbers, formulas, empty fields and rows of different lengths are kept. What can change is the format around the values: the delimiter, which fields carry quotes, the record line endings, a byte order mark at the start and a final line break, which are both removed.

Is my CSV uploaded?

No. The text or file is read and converted by a worker in your browser, and nothing is uploaded or stored. Copy output writes to your clipboard only when you select it. Reset clears the input and the output and revokes the download link, and leaving the page clears them too. Reset cannot remove files you already downloaded or clear your clipboard.