CSV Import – File Format

WordPress Plugin Staff List CSV Import – File Format.

Staff List CSV can read and import files containing any set of special characters as long as the file is in the CSV format and properly encoded.
The plugin will generate errors if the file contains characters not supported by the encoding selected when exporting data to CSV file.

CSV File Requirements

  1. Column names in the first row.
  2. Column delimiters: comma (,) semicolon (;) pipe (|) or tab (\t).
  3. Row delimiters: a line break (CRLF).
  4. Encoding: UTF8 if the file contains extended characters such as ä, è, ö, ü.
  5. BOM. No byte order mark (BOM) at the start of the file.
  6. If a field contains the column delimiter, then it must be escaped.
  7. Fields containing line breaks, double quotes, and commas should be enclosed in double-quotes.
  8. If double-quotes are used to enclose fields, then a double-quote appearing inside the field must be escaped by preceeding it with another double quote.
Unfortunately, MS Excel export to the CSV file in UTF-8 encoding does not always work. You can get a file in 8-bit ISO format, even if UTF-8 was chosen as export format. Therefore, please use OpenOffice or LibreOffice to open your Excel file and then export your data in the CSV format with UTF-8 encoding. The CSV Staff List import should now work properly.
CSV looks like a simple portable format from the outside, but the look is deceiving.
If you still have problems, please send us your source file and we will try to convert it correctly.