Notes on Creating CSV Files
The permanent link has been copied.
To properly import a CSV file, read the warnings below and describe the data correctly.
Character Encoding
The permanent link has been copied.
The following character codes are available.
- Japanese (Shift-JIS)
- English (Latin1)
- Simplified Chinese (GBK/GB2312)
- Unicode (UTF-8)
Delimiter
The permanent link has been copied.
The following delimiters are available.
- Comma (,)
- Semicolon (;)
- Tab
- Space
Notations for Special Characters
The permanent link has been copied.
Delimiter
The permanent link has been copied.
To include the same character as a delimiter in the field value, enclose the value with double quotation marks (").
For example, assume that you import a CSV file that uses comma (,) as the delimiter.
If you want to specify '1,000' as the field value, enter the value as follows in a CSV file.
abc,"1,000",def
Double quotation mark
The permanent link has been copied.
If the field value contains double quotation marks ("), you should specify two consecutive double quotation marks ("").
For example, to specify 'xy"z' as the field value, enter the value as follows in a CSV file.
abc,xy""z,def