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

Tips for Successful CSV Imports
Sublist Data Import
Importing Subrecord Data
Supported Subrecord Imports
Effects of Auto-Generated Numbers during Imports
General CSV File Conventions
Tips for Using Numbers in CSV Files
Boolean Values in CSV Files
Delimiters for Hierarchical and Multi-Select Fields
Name References
State and Province Names for CSV Import
Country Names for CSV Import

General Notices