Notes on Creating CSV Files
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,...