Semicolon CSV to Comma CSV

Fix a European CSV that opens in one column: change the semicolon separator to a comma, or the other way round. Free, in your browser.

Quick answer: Validate, beautify and clean JSON, CSV, XML and YAML.

How to use the Semicolon CSV to Comma CSV

Validate, beautify and clean JSON, CSV, XML and YAML.

The Data Formatter checks and tidies JSON, CSV, XML and YAML. It shows the exact line and column of an error, can fix common JSON mistakes, and cleans CSV by trimming spaces, removing empty rows and columns and dropping duplicates. Developers use it to read API responses, analysts to prepare files before an import. The result can be copied or downloaded, and your text never leaves your device.

Paste or upload your data
Choose the options
Copy or download the result

Tips

Invalid JSON shows the exact line and column. “Auto-fix” repairs comments, trailing commas and single quotes.
Numbers and key order are kept exactly as written – nothing is rounded.
CSV: any delimiter is detected automatically; pick the one you want for the output.
YAML: comments are kept, and you can convert YAML → JSON or paste JSON to get YAML.

Example

Input: id;name 1;Ada

Output: id,name 1,Ada

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Why does my CSV open in one column?

The file uses a different separator than your spreadsheet expects, often a semicolon. Change it to a comma and it opens in columns.

Is the current delimiter detected?

Yes. Comma, semicolon, tab and pipe are detected automatically.

What can the Data Formatter do?

Validate, beautify, minify and clean JSON, CSV, XML and YAML. Errors show the exact line and column, and JSON can be auto-fixed for common mistakes such as trailing commas and single quotes.

Data Formatter: JSON, CSV, XML and YAML: Validate, beautify and clean JSON, CSV, XML and YAML for free. Highlight columns, rows and words and download as Excel. Runs in your browser.
JSON Formatter and Validator: Beautify, minify and validate JSON online for free. It shows the exact line of an error and can auto-fix common mistakes. Runs in your browser.
CSV Formatter and Cleaner: Clean a CSV online for free: trim spaces, drop empty or duplicate rows, change the delimiter and tidy headers. Runs in your browser.
XML Formatter and Validator: Beautify, minify and validate XML online for free. It shows the line and column of any error so you can fix it fast. Runs in your browser.
YAML Formatter and Validator: Format and validate YAML online for free, or convert YAML to JSON in one click. Errors show the exact line. Runs in your browser, no upload.
JSON Validator Online: Validate JSON online and see the exact line and column of any error. Auto-fix comments, trailing commas and single quotes. Free, in your browser.
JSON Minifier: Minify JSON online to remove spaces and line breaks and make the file smaller. Free, runs in your browser, nothing is uploaded.
XML Validator Online: Check if your XML is well-formed and find the exact line and column of the first error. Free, in your browser, nothing is uploaded.

Topic guides

CSV Guides and Free CSV Tools