.CSV File Format

When an import file is a .CSV file, it is a “comma-separated values” file. A “comma-separated values” file is a text file in which the values are separated by commas.

For example, you can download as Comma-separated values (.csv) in Google Drive (Sheets). You can also upload an Excel file to Google Drive. Google Drive lets you download the Excel file as a .csv file.

> Important Note: > If the file includes any characters outside the normal ANSII character set, the file must be correctly encoded as UTF-8. > UTF-8 encoding is required when the file includes characters outside the normal ANSII character set. > For this reason, using Google Drive is recommended. > Excel does not have an option to save a .csv file encoded as UTF-8. > A .csv file encoded as UTF-8 is also Unicode text.

International characters

Accented characters, e.g. à, á, â, ã, ä, å, etc.
Multibyte character sets, e.g. Arabic, Chinese, Greek, Hebrew, Hindi, Japanese, Russian, etc.
Special characters, e.g. ∞ π ∅ ≤ ≥ ≠ ≈ ∧ ∨ ∩ ∪ ∈ ∀ ∃ ∑ ∏ ← ↑ → ↓ ↔ ↕ ⇒ ⇔ ∠ ∧ ∨ ∩ ∪ ∫ ∬ ∮ ∰ ∴ ∵ ∽