CSVCSV Dock

CSV guide

Convert a Semicolon-Delimited CSV to Comma-Delimited CSV

Some regional spreadsheet settings and business systems export CSV records with semicolons instead of commas. Converting the delimiter requires parsing the records first: punctuation inside quoted fields is data, not a separator to replace blindly.

Convert the CSV delimiter

Step by step

  1. Open the source file and confirm that the detected delimiter is semicolon.
  2. Review the header and a few rows, especially fields containing commas, semicolons, quotes or line breaks.
  3. Choose comma as the export delimiter and download the repaired CSV.
  4. Open or import the new file in the destination system and confirm that the column layout is unchanged.

Check the result

  • The source and exported files should report the same data-row and column counts.
  • Quoted punctuation and multiline values should remain in the same cells after conversion.
  • Test the result in the actual importer because some regional Excel configurations still expect semicolons.

Common pitfalls

  • Replacing every semicolon with a comma can alter legitimate text inside quoted fields.
  • Decimal commas do not automatically mean that commas are the file delimiter.
  • Changing a regional system setting affects other applications and is unnecessary for a one-file conversion.

Download the example

The public sample contains synthetic data only. Download the test input and open it in the linked tool.

Expected outcomes and file checksums are published in the versioned CSV edge-case dataset.

Privacy boundary

Files selected in the workbench are processed locally. A public URL is requested directly by the browser and must permit cross-origin access. No server proxy is used by the MVP.