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