Skip to main content

Change CSV Delimiter

Convert CSV separators between comma, semicolon, tab, and pipe

Swap the delimiter of any separated-values file between comma, semicolon, tab, and pipe — in either direction, in one step. Paste the data or upload the file, pick the current and target separators, and download the rewritten file.

The file is parsed as structured data before anything is rewritten, so a value that contains the new delimiter is quoted instead of being split into two fields. That is the failure mode of find-and-replace in a text editor, and the reason this tool exists.

The most common use is regional Excel settings: many European locales expect semicolon-separated files, while most APIs and databases expect commas. You can also choose how the output is quoted — only where needed, around every field, or not at all — to match whatever the receiving system requires.

Files stay on this deviceRuns entirely in your browserFree — no signup

Drop your file here or browse from your device

Accepts CSV, TSV, TXT. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.

How to Use

  1. Paste CSV data or upload a delimited text file
  2. Choose the current delimiter and the delimiter you want
  3. Select how fields should be quoted
  4. Convert, copy, or download the new file

Features

  • Convert comma, semicolon, tab, and pipe delimiters
  • Control minimal, all, or no quote output
  • Paste data or upload CSV files
  • Preview and copy converted output
  • Download the converted file

Use Cases

  • Prepare CSV files for regional Excel settings that expect semicolons
  • Create pipe-delimited exports for legacy systems
  • Convert TSV data into CSV without opening spreadsheet software
  • Normalize vendor data feeds before import

Frequently Asked Questions

Can I convert semicolon CSV to comma CSV?

Yes. Select Semicolon as the input delimiter and Comma as the output delimiter.

Does this upload my file?

No. The delimiter conversion runs entirely in your browser.

Why not just find-and-replace the delimiter in a text editor?

Find-and-replace also rewrites delimiters that appear inside values. A field like "Smith, John" would be split into two columns. This tool parses the file first, so values containing the new delimiter are quoted and stay intact.

Why does Excel open my CSV in a single column?

Your regional settings probably expect a different separator — many European locales use semicolons instead of commas. Convert the file to the delimiter your locale expects and Excel will split it into columns correctly.

What do the quoting options mean?

Minimal quotes only fields that need them (they contain the delimiter, quotes, or line breaks). All wraps every field in quotes, which some strict importers require. None writes fields bare — only safe when you know no value contains the delimiter.