A CSV file is an ASCII file where fields are separated by a specified field delimiter. You can choose the delimiter to use (e.g., comma, semicolon, tab). The import file may also contain text delimiters, but this is optional. Note: Do not use a delimiter that appears in your content.
Structure: The first row of the table should contain the field names (e.g., Last Name, Email, Address). Check your file: Are the contents correctly distributed in the appropriate columns? Columns with irrelevant information can be deleted. Ensure your data is not spread across multiple tables (worksheets) in the document.
Character set: UTF-8 (Unicode)* or ISO-8859-1 (Western European)
Field delimiter: ;
Text delimiter: “