CSV Delimiter Converter

Switch a CSV between comma, semicolon, tab and pipe delimiters. Quoted fields are parsed properly and re-quoted, so values like “Doe, John” survive the trip intact.

csv-delimiter-converter · runs locally
0Rows
0Columns

Why a converter beats find-and-replace

Swapping delimiters looks like a one-line job until a field contains the delimiter itself. A naive find-and-replace on "Doe, John",Berlin turns one name into two columns and shifts every field to its right — silently corrupting the rows you least want corrupted. This tool avoids that by actually parsing the CSV (RFC 4180: quoted fields, embedded delimiters, doubled quotes, multi-line cells) and then re-serializing with the new delimiter, quoting only the fields that need it. What goes in as valid CSV comes out as valid CSV.

The Excel semicolon problem

The most common reason to need this tool: a colleague in Europe sends a CSV and it opens as one long column. Windows locales that use the comma as the decimal separator make Excel export with semicolons instead, and plenty of importers only accept commas. Paste the file here, leave the source on auto-detect, choose comma as the target, and download the fixed file. The same trick works in reverse for sending files to semicolon-expecting systems, or for producing pipe-delimited feeds and tab-separated files that paste cleanly into spreadsheets.

What to do with the result

  1. Paste your CSV — the source delimiter is detected automatically, but you can override it.
  2. Pick the target delimiter: comma, semicolon, tab or pipe.
  3. Copy the converted text, or download it as a .csv/.tsv file.

Everything runs locally in your browser, so exports containing real customer data stay on your machine. Once the delimiter is fixed, the CSV to JSON Converter turns the file into objects for code, and the CSV Duplicate Remover cleans up repeated rows.

Frequently asked questions

Is my data uploaded to a server?

No. The file is parsed and rebuilt entirely in your browser — nothing is transmitted or stored. CSVs full of customer names, emails and order data can be converted without leaving your machine.

Why does Excel save my CSV with semicolons?

In much of Europe the comma is the decimal separator (1,5 means one and a half), so Windows regional settings use the semicolon as the list separator — and Excel follows suit when saving CSV. That is why a “comma-separated” file from a German or French machine is actually semicolon-separated, and why tools expecting commas see one giant column.

Why can't I just find-and-replace the delimiter?

Because delimiters can legally appear inside quoted fields. Replace every semicolon with a comma in "Doe; John";Berlin and the name splits into two columns, shifting every field after it. This tool parses the CSV first (RFC 4180, quotes and all), then re-serializes with the new delimiter and re-quotes only the fields that need it.

What is the difference between TSV and CSV?

TSV uses a tab character as the delimiter instead of a comma. Tabs rarely occur inside data, so TSV needs less quoting and pastes cleanly into Excel and Google Sheets. Choose Tab as the target delimiter and the download button produces a .tsv file.

CSV to JSON Converter

Turn CSV data into a JSON array of objects, with automatic type detection.

Open tool →

CSV to SQL IN Statement

Turn a CSV column into a quoted SQL IN (…) list — with escaping, dedupe and chunking.

Open tool →

CSV Duplicate Remover

Remove duplicate rows from CSV — whole-row or by key column — and see what was dropped.

Open tool →