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.Paste the data
The current separator is detected automatically, or choose it yourself.
2.Pick the new separator
Comma, semicolon, tab (TSV) or pipe.
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.
Related tools
JSON ↔ CSV Converter
Convert JSON arrays to CSV and CSV back to JSON.
CSV to Markdown Table Generator
Turn CSV or spreadsheet cells into Markdown, ASCII or HTML tables.
CSV & JSON to SQL INSERT Generator
Turn CSV or JSON rows into SQL INSERT statements.
JSON Formatter & Validator
Pretty-print, minify, sort and validate JSON with line-numbered errors.
JSON to TypeScript Interface Generator
Generate TypeScript interfaces or types from a JSON sample.
JSON ↔ YAML Converter
Convert JSON to YAML and YAML to JSON.
More Developer tools
JSON & data
CSV tools
Network & system
Web & API
Git & releases
Encoding & security
- Base64 encode & decode
- URL encode & decode
- JWT decoder
- Hash generator
- HTML entity encoder
- Text to binary
- Morse code translator
- Caesar cipher & ROT13
- Random string generator
- Secret key generator
- 2FA code generator (TOTP)
- Encrypt & decrypt text
- Encrypt & decrypt files
- SSH key generator
- Base32 encoder and decoder
- Unicode escape converter
- Nano ID generator
- JWT generator
Text & code
- Regex tester
- Text diff checker
- Cron expression explainer
- Lorem ipsum generator
- Markdown previewer
- Slug generator
- Strip HTML tags
- Unicode character inspector
- URL parser
- Markdown TOC generator
- cURL converter
- Whitespace visualizer
- Markdown link extractor
- Regex escape
- Regex match extractor
- Split text by regex
- HTML, CSS and JS playground
- Mock data generator
- Keyboard event tester
- ASCII table