>_QueryLocalCSV & JSON tools that run in your browser
QueryLocal / Semicolon ⇄ comma CSV

Convert semicolon CSV ⇄ comma CSV

Drop your file, then pick the format you need: standard CSV (comma) or CSV for Excel (semicolon).

Why your CSV has semicolons

In countries where the comma is the decimal separator — France, Germany, Spain, Italy, Brazil and many others — Excel saves "CSV" files with semicolons between fields, so that 12,5 can stay a number. Most software, databases and programming libraries expect commas and a dot for decimals. The result: an import where everything lands in a single column, or numbers read as text.

The reverse happens too: a standard CSV double-clicked in a French Excel shows every row squashed into column A.

Semicolon → comma (for software, databases, Python, R…)

  1. Drop the semicolon file. The separator is detected and decimal commas are understood as numbers.
  2. Click CSV in Download. You get a comma-separated, UTF-8 file with dots as decimal separators.

Comma → semicolon (to open in Excel)

  1. Drop the standard CSV.
  2. Click CSV for Excel (;). The file uses semicolons, decimal commas, and starts with a UTF-8 marker so é, ü or ñ display correctly.

Fields containing the separator, quotes or line breaks are quoted properly in both directions, so no column shifts.

Other free CSV tools

Open a CSV too big for ExcelMillions of rows, hundreds of MB. No 1,048,576-row limit. CSV viewerLook inside any CSV without Excel. Private and instant. Remove duplicate rowsDeduplicate a CSV in one click, then download it clean. CSV to JSONConvert a CSV into a JSON array of objects, typed numbers included. JSON to CSVFlatten a JSON array or JSON Lines file into a clean CSV. Count rows in a CSVExact row count of any CSV, even a huge one, in seconds. Filter a CSVKeep only the rows you need and download them. Column summaryFilled, distinct, min and max for every column at once. Query CSV with SQLReal SQLite on your file: GROUP BY, JOINs, window functions.

Frequently asked questions

Will accents be preserved?

Yes. The input is read as UTF-8, and the Excel variant adds a byte-order mark so Excel doesn't misread accents.

What about dates?

Dates are copied as written in the source file. If you need to change their format, you can do it in the query before downloading.

Can I also convert tab-separated files?

Yes. Tab and pipe separators are detected too, and the download gives you a comma or semicolon file.