Notes on Creating CSV Files

Article Number:020150

An item for describing data in a CSV file is called a field.
To properly import a CSV file, you must be aware of the following points and describe the data correctly in the field.

Character Encoding

The following character codes are available.

  • Japanese (Shift-JIS)
  • English (Latin1)
  • Simplified Chinese (GBK/GB2312)
  • Unicode (UTF-8)

Delimiter

The following delimiters are available.

  • Comma (,)
  • Semicolon (;)
  • Tab
  • Space

Notations for Special Characters

The fields containing any of the following characters must be enclosed with double quotation marks (").

  • Comma (,)
  • Double quotation mark (")

If you want to describe double quotation (") in a field in the CSV file, you should add another " so that it looks like "".

  • Example of how to write "xy"z" in a CSV file.
    ...,abc,"xy""z",def,...