Developer tools ● Local processing

CSV Delimiter Converter

Convert semicolon- or tab-separated text to comma-separated CSV in your browser. Preserve quoted fields, with no account or file upload required.

Preparing tool…
Try an example

Try an example

Fictitious data: semicolons separate columns. The comma in “Paris, France”, the semicolon in “tea; coffee”, the line break and the identifier 001 stay in their cells.

Before: semicolon separator

id;name;note
001;Ada;"Paris, France"
002;Sam;"tea; coffee"
003;Jo;"first line
second line"

After: expected comma-separated result

id,name,note
001,Ada,"Paris, France"
002,Sam,tea; coffee
003,Jo,"first line
second line"

Example settings: semicolon input, comma output.

Loads the data, selects Semicolon and runs the converter below. Existing input or a changed separator choice will not be replaced.

Processed in your browser. Changing delimiters does not neutralize formulas: review untrusted cells before opening them in a spreadsheet. CSV quotes alone do not prevent formulas.

✓ Local processing✓ No account✓ Inputs processed here✓ Free

Quick answer

Choose the input separator and convert each row to comma-separated CSV. Quoted fields are preserved and re-quoted when needed.

The page and its assets load from the site; this operation uses your entered values only in this browser and does not send them to a calculation endpoint.

How to use it

Paste your rows, choose the separator used between columns in the original data (comma, semicolon, or tab), then convert. The tool writes comma-separated CSV and keeps quoted separators inside their fields. Quotes must start at the beginning of a field; double them to include a literal quote, and do not add characters after a closing quote.

Limits

This converts field separators but does not change values or infer data types. Select the separator used between columns in the original text. Quoted fields must follow CSV quoting rules: a quote opens at the start of a field, double quotes escape a quote inside a field, and no text may follow the closing quote before the next separator or line break.

Example: convert semicolon-separated CSV to commas

Choose Semicolon as the input separator. The two input lines name;city and Ada;Paris become name,city and Ada,Paris.

A comma inside a value needs quoting in the result: Ada;Paris, France becomes Ada,"Paris, France". A semicolon already inside a quoted field stays part of that value.

Convert tab-separated text to CSV

Paste tab-separated rows and select Tab. The output always uses commas between columns. This tool does not produce semicolon- or tab-delimited output, and it does not change decimal separators or infer dates.

To inspect rows and columns before conversion, use the CSV explorer. To change the data format, choose CSV to JSON or JSON to CSV.

Before opening the CSV in a spreadsheet

Changing the delimiter does not make untrusted cells safe. Values such as =1+1 remain unchanged and may be interpreted as formulas by spreadsheet software. Review untrusted data before opening the result; CSV quotation marks alone do not prevent formula interpretation.

Frequently asked questions

How do I choose the input separator?

Choose the character that appears between columns in the original data. For example, choose Semicolon for rows such as name;city.

Will it split a separator inside quotes?

No. Text inside a quoted field stays together, even when it contains the selected separator.

Why is a quote placement rejected?

A quoted field must start at the beginning of the field. Escape a quote inside it by doubling it, and place no characters after its closing quote except the selected separator or a line break.

Sources and references

These references document the cited standard or browser API; they do not validate the tool’s output.

Follow a worked example

From semicolon CSV to JSON, keeping leading zeroes