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 "".
For example, a field containing 'xy"z' should be described in the CSV file as follows:

abc,"xy""z",def