SPARKPOND / CHANGE CSV DELIMITER

Change a CSV Delimiter Online

Fix files that open in one spreadsheet column without replacing punctuation inside quoted fields. Source detection and output delimiter are confirmed separately.

✓ Processed locally✓ No account✓ Original unchanged

LOCAL WORKSPACE

Open your data file

CSV, TSV, Delimited text. atau letakkan di sini.

Download the example file ↓

Focused purpose

What this tool does

Change a CSV or TSV delimiter locally between comma, semicolon, tab and pipe. Preserve quoted separators, preview columns and download without an account.

  • ✓ Comma, semicolon, tab and pipe
  • ✓ Quoted-field preservation
  • ✓ Column preview
  • ✓ Independent input and output choices

Workflow

How to use it

  1. 01

    Open the file and inspect the detected columns.

  2. 02

    Correct the input delimiter if needed.

  3. 03

    Choose the output delimiter and export a new copy.

Available controls

Available options

  • Confirm the detected source delimiter.
  • Choose comma, semicolon, tab or pipe output.
  • Select line endings and quoting policy.
  • Add a UTF-8 BOM only when required.

Semicolon-separated CSV

Example before and after

A semicolon file may open as one column in software expecting commas.

Before

name;email;country
Ada;ada@example.com;FR

After

name,email,country
Ada,ada@example.com,FR

Expected result: Fields are re-serialized with commas while quoted content remains intact.

Download example ↓

Practical scenarios

Common use cases

Fix CSV opening in one Excel column.

Convert regional semicolon CSV to comma CSV.

Turn tabular clipboard text into CSV.

HONEST LIMITS

Important limitations

  • iMixed unquoted delimiters can be structurally ambiguous.
  • iChanging delimiters does not convert numbers or dates.

FAQ

Questions about this tool

Why does my CSV open in one column?

The application probably expects a different delimiter than the file uses.

Are separators inside quotes replaced?

No. Parsing distinguishes field separators from punctuation inside quoted values.

Can I convert CSV to TSV?

Yes. Choose tab as the output delimiter and download a .tsv file.