CSV reference based on official sources
CSV encoding compatibility matrix
See what the official documentation says about CSV encodings in Excel, Power Query / Power BI, Tableau, BigQuery and Google Sheets.
Fields not confirmed by the cited official source are marked Unknown, not guessed. Requirements can change; check the linked source before importing.
Scroll horizontally to view the rest of the table
| Encoding | Excel | Power Query / Power BI | Tableau | BigQuery CSV load | Google Sheets IMPORTDATA |
|---|---|---|---|---|---|
| UTF-8 | Caution | Caution | Supported | Recommended | Unknown |
| UTF-8 BOM | Recommended | Recommended | Supported | Caution | Unknown |
| Shift_JIS / CP932 | Unknown | Unknown | Unknown | Not supported | Unknown |
| CP949 | Unknown | Unknown | Unknown | Not supported | Unknown |
| EUC-KR | Unknown | Unknown | Unknown | Not supported | Unknown |
| Big5 | Unknown | Unknown | Unknown | Not supported | Unknown |
| GB18030 / GBK | Unknown | Unknown | Unknown | Not supported | Unknown |
| Windows-1252 | Unknown | Unknown | Supported | Not supported | Unknown |
| ISO-8859-1 | Unknown | Unknown | Unknown | Supported | Unknown |
Behavior can vary by OS, Excel version, locale and connection method.
Status definitions
- Recommended
- Explicitly recommended by the official source, or the safest documented choice.
- Supported
- The official source confirms that it can be read.
- Caution
- Requires attention to a BOM, setting, conversion or other condition.
- Not supported
- Not included in the official list of supported encodings.
- Unknown
- The cited official documentation does not establish support.
Prepare the CSV before importing
Meet a service's limits locally in your browser without uploading the file to LocaCSV.