.CSV File Format

Source:

Published:

Keywords: .CSV, comma-separated values, UTF-8, Google Drive, international characters

Document ID: https://platform-support.certain.com/hc/en-us/articles/33038066199063--CSV-File-Format#split1

.CSV File Format

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

For example, you can download a comma-separated values .csv file in Google Drive (Sheets). You can use 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, then the file must be correctly encoded as UTF-8. > Certain recommends using Google Drive for this encoding. > Excel does not have an option to save a .csv file encoded as UTF-8. > UTF-8 encoding is Unicode text.

International characters

Examples include à, á, â, ã, ä, å, etc.

Examples include Arabic, Chinese, Greek, Hebrew, Hindi, Japanese, Russian, etc.

Examples include ∞ π ∅ ≤ ≥ ≠ ≈ ∧ ∨ ∩ ∪ ∈ ∀ ∃ ∑ ∏ ← ↑ → ↓ ↔ ↕ ⇒ ⇔ ∠ ∧ ∨ ∩ ∪ ∫ ∬ ∮ ∰ ∴ ∵ ∽

Examples also include π ø ≤ ≥ ≠ /≈

Examples also include Σ Π < ↑ → ↓