Avoiding Errors for Commas and Other Delimiter Symbols within CSV File Fields

The Import Assistant ignores extra trailing commas and other column separators repeated at the end of fields or rows.

If any of the fields in the CSV file you import contains characters that are also used as column separators in the file (comma, semicolon, pipe, space, or tab), errors might occur during the import. To avoid errors when importing these files, either remove these characters or enclose the content of such fields in quotation marks (“for example”). This applies also to spaces before or after the value in the field. When opening a CSV file with a simple text editor, there should be no other characters that are also used as column separators in it, unless you enclose them in quotation marks.

If the CSV file you import uses commas as both value separators and decimal marks, make sure that all floating point numbers are enclosed in quotation marks (for example, “1,42”).

Related Topics