ZapKit

CSV Delimiter Converter

Convert comma-separated data to semicolons, tabs or pipes and back, with quoted values and line breaks inside cells handled properly.

What is a CSV delimiter?

A delimiter is the character that separates one value from the next in a delimited text file. CSV stands for comma-separated values, but many files use semicolons, tabs or pipes instead, depending on the software and region that created them.

When a file uses a different delimiter from the one your spreadsheet, database import or script expects, everything lands in a single column or columns shift. This converter changes the delimiter safely, so data analysts, accountants and developers can move exports between Excel, Google Sheets, MySQL, Python and other tools without corrupting any values.

How to use the CSV Delimiter Converter

  1. 1.Paste the data

    The current separator is detected automatically, or choose it yourself.

  2. 2.Pick the new separator

    Comma, semicolon, tab (TSV) or pipe.

  3. 3.Download the file

    Save it and open it in Excel, Sheets or your database tool.

Example: a semicolon file from European Excel

Three rows separated by semicolons, including a quoted name with a comma and the amount 1.250,50:

Read as
Semicolon (;)
Rows
3
"Rao, Priya"
kept quoted because it contains a comma
1.250,50
quoted as "1.250,50" in comma output

Every value keeps its exact text and the file opens in the right columns as standard CSV.

Why a find-and-replace isn't enough

Swapping every ; for a comma breaks any value that contains a comma, such as "Rao, Priya" or the European number 1.250,50. This converter parses the file properly first, following RFC 4180, then writes each value back out, quoting it only when it contains the new separator, a quote or a line break.

Excel in much of Europe and Latin America saves CSV with semicolons because the comma is the decimal mark there, which is why files often open as one long column elsewhere. Converting the delimiter fixes that without touching the values.

Frequently asked questions

Why does my CSV open in one column in Excel?

Excel expects your region's list separator. Convert the file to that separator, often a semicolon in Europe, and it opens in columns.

What is a TSV file?

Tab-separated values. It's CSV with tabs between fields, and pastes straight into spreadsheets.

Are numbers like 1.250,50 changed?

No. Values are copied exactly; only the separator between them changes.

Can I quote every field?

Yes. Tick Quote every field for systems that require quotes around all values.

More Developer tools