Skip to content
GRID16

Format CSV

This tool rewrites a CSV file with a different delimiter, in your browser. A German or other European Excel export separates fields with semicolons, because it already uses the comma for decimals; the reverse is needed too, for example when a comma file has to open in a German Excel. Both delimiters are chosen from the same list, comma, semicolon, tab or pipe, and the tool starts on semicolon to comma. The rows and columns themselves are not changed, and everything happens on your device, so the file is never uploaded to a server.

Runs in your browser

Drop a file here

CSV, up to 50 MB

How it works

  1. 1 Choose a CSV file.
  2. 2 Set the delimiter your file uses and the delimiter you want in the result. It starts on semicolon to comma.
  3. 3 GRID16 rewrites the rows with the new delimiter in your browser.
  4. 4 Download the result.

Questions

Why would a CSV file need a different delimiter?
A German or other European Excel separates its export with semicolons, because it already uses the comma for decimals; most other software expects commas instead, and the reverse is needed too when a comma file has to open in a German Excel. This tool goes either way, and starts on semicolon to comma.
Does it interpret my header row or my columns?
No. A CSV to CSV job keeps the raw rows and never turns them into named fields, so duplicate column names and short rows survive exactly as they are, just with the new delimiter.
What happens to quotes and line breaks inside a field?
They are kept. A field that holds the new delimiter is quoted, a field that no longer needs quoting loses it, and a quoted field with a line break or a doubled quote survives unchanged. Line endings become LF.
Does the file need a particular encoding?
The file is read as UTF-8. A file saved in an older Windows encoding with characters such as umlauts or accents is reported instead of converted. A byte order mark at the start of the file is kept, so Excel still reads its umlauts and accents.
My result is one long column instead of a table.
That means the file uses a different delimiter than the one chosen to read it. Pick the delimiter the file actually uses and run it again.
Is my file uploaded to a server?
No. The conversion happens in your browser; the file never leaves your device.

More tools