| | 3 | LiteCart tries to support the most common variations of non-standard CSV |
|---|
| | 4 | formats but one is prefered. |
|---|
| | 5 | |
|---|
| | 6 | \^ Format \^ Delimiter \^ Column Wrapper \^ Escape character \^ Encoding |
|---|
| | 7 | \^ EOL | CSV | , | " | " | UTF-8 w/o BOM | CR+LF |
|---|
| | 8 | |
|---|
| | 9 | A list of CSV formats supported by applications. |
|---|
| | 10 | |
|---|
| | 11 | \^ Application \^ Format \^ Delimiter \^ Column Wrapper \^ Escape |
|---|
| | 12 | character \^ Encoding \^ EOL \^ Recommended \^ Comments | Google Docs |
|---|
| | 13 | Spreadsheet (Web application) | CSV / TSV | , or TAB | " | " | |
|---|
| | 14 | Any | CR / LF / CR+LF | **Yes** | | Microsoft Office Excel 2010 |
|---|
| | 15 | (numerals with decimal point) | CSV (MS-Dos) | , | " | " | UTF-8 |
|---|
| | 16 | w/o BOM | CR+LF | No | Excel 2011/Mac cannot correctly interpret a |
|---|
| | 17 | CSV file containing umlauts and diacritical marks no matter what |
|---|
| | 18 | encoding. | Microsoft Office Excel 2010 (numerals with decimal comma) |
|---|
| | 19 | | DSV (MS-Dos) | ; | " | " | UTF-8 w/o BOM | CR+LF | No | |
|---|
| | 20 | Excel 2011/Mac cannot correctly interpret a CSV file containing umlauts |
|---|
| | 21 | and diacritical marks no matter what encoding. | Microsoft Office Excel |
|---|
| | 22 | 2011 (numerals with decimal point) | DSV (Mac) | , | " | " | |
|---|
| | 23 | Windows-1252, UTF-8 w/ BOM | CR | No | Many regional versions of |
|---|
| | 24 | Excel will not be able to deal with Unicode in CSV. | Microsoft Office |
|---|
| | 25 | Excel 2011 (numerals with decimal comma) | CSV (Mac) | ; | " | " |
|---|
| | 26 | | Windows-1252, UTF-8 w/ BOM | CR | No | Many regional versions of |
|---|
| | 27 | Excel will not be able to deal with Unicode in CSV. | LibreOffice Calc |
|---|
| | 28 | (Multi platform) | CSV / DSV / TSV | Any | " or ' | " | Any | |
|---|
| | 29 | CR / LF / CR+LF | **Yes** | Supports all variations |
|---|
| | 30 | |
|---|
| | 31 | w/ BOM = With Byte Order Mark |
|---|
| | 32 | |
|---|
| | 33 | w/o BOM = Without Byte Order Mark |
|---|