.CSV File Format
When an import file is a .CSV file, it's 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. You can download the Excel file as a .csv file from Google Drive.
> Important Note: > If the file includes any characters outside the normal ANSII character set (see examples below), then the file must be correctly encoded as UTF-8. > The guidance recommends using Google Drive for UTF-8 encoding—see above. > Excel does not have an option to save a .csv file encoded as UTF-8. > Excel cannot save a .csv file encoded as UTF-8 as 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. ∞ π ∅ ≤ ≥ ≠ ≈ ∧ ∨ ∩ ∪ ∈ ∀ ∃ ∑ ∏ ← ↑ → ↓ ↔ ↕ ⇒ ⇔ ∠ ∧ ∨ ∩ ∪ ∫ ∬ ∮ ∰ ∴ ∵ ∽
- (Additional character examples shown in the page content:
π ø ≤ ≥ ≠ ≈ ∧ ∨ ∩ ∪ ∈ ∀ ∃ ∑ ∏ ← ↑ → ↓ ↔ ↕ ⇒ ⇔ ∠ ∧ ∨ ∩ ∪ ∫ ∬ ∮ ∰ ∴ ∵ ∽andΣ Π ← ↑ → ↓.)