How to use the Fix the CSV Delimiter
- 1 Drop the CSV file on the studio, or try the example.
- 2 Under Source, check the delimiter. The detected one is shown; choose another if the preview shows one column.
- 3 Under Export options choose the delimiter you need (Excel in many European regions wants a semicolon, in the US and UK a comma).
- 4 Download the file.
Why a CSV opens in one column
“CSV” stands for comma-separated values, but nothing forces the comma. Many programs in countries that write decimals with a comma use a semicolon instead, and some tools use tabs or pipes. Excel decides what to expect from the list separator in your computer’s regional settings: a file with another delimiter opens as a single column, every row squeezed into column A.
Two ways to fix it
You can tell Excel how to read the file, with Data → From Text/CSV and choosing the delimiter, or you can change the file. This page does the second: it detects the delimiter by comparing how consistently each candidate splits the first rows, lets you override it, and writes the file back with the delimiter you pick. Quoted fields are respected, so a comma inside “Smith, John” does not split the name.
For Excel on a system with European settings, the Export options have a preset that writes a semicolon and UTF-8 with a byte-order mark. Microsoft documents the import options in Import or export text (.txt or .csv) files.
Limits
Only comma, semicolon, tab and pipe are offered. A file with a single column genuinely has no delimiter; the studio says so rather than inventing one.
Frequently asked questions
How does it know which delimiter a file uses?
It splits the first rows with each candidate and picks the one that gives the same number of fields on most rows. When that is a close call it tells you the choice is a guess.
Will quoted commas break my columns?
No. Text inside double quotes is one field, whatever it contains, and fields that need quotes are quoted again on export.
Why does Excel still show wrong characters after fixing the delimiter?
That is the encoding, not the delimiter. See converting the encoding of a CSV file.
Last updated: