The CSV standard is a relatively loose one, and it is not always clear which interpretation is the correct one. The Cambuildr, therefore, accepts several variants of CSV files:
Comma-Separated (value; value; value).
Semicolon-separated (value; value; value)
Column values with and without quotes, also mixed (value, "value", value)
The separator can be specified in the upload options. There are only two things to consider beyond that:
Encoding UTF-8
To ensure that special characters are imported correctly, the file should be encoded "UTF-8". It may (but does not have to) be the case that other encodings are also read correctly, but there is no guarantee for this.
You can see from the preview if special characters were read correctly - so it is recommended to use an entry with special characters in the first line, so that you can check the correct import in the preview.
Quotation marks for separators in column values
Since both possible separators - comma and semicolon - can occur in column values, the CSV standard offers the possibility to enclose such values in quotation marks.
Also note: Person Data - Fields and Values