CSV Formats

LiteCart tries to support the most common variations of non-standard CSV formats but one is prefered.

\^ Format \^ Delimiter \^ Column Wrapper \^ Escape character \^ Encoding \^ EOL | CSV | , | " | " | UTF-8 w/o BOM | CR+LF

A list of CSV formats supported by applications.

\^ Application \^ Format \^ Delimiter \^ Column Wrapper \^ Escape character \^ Encoding \^ EOL \^ Recommended \^ Comments | Google Docs Spreadsheet (Web application) | CSV / TSV | , or TAB | " | " | Any | CR / LF / CR+LF | Yes | | Microsoft Office Excel 2010 (numerals with decimal point) | CSV (MS-Dos) | , | " | " | UTF-8 w/o BOM | CR+LF | No | Excel 2011/Mac cannot correctly interpret a CSV file containing umlauts and diacritical marks no matter what encoding. | Microsoft Office Excel 2010 (numerals with decimal comma) | DSV (MS-Dos) | ; | " | " | UTF-8 w/o BOM | CR+LF | No | Excel 2011/Mac cannot correctly interpret a CSV file containing umlauts and diacritical marks no matter what encoding. | Microsoft Office Excel 2011 (numerals with decimal point) | DSV (Mac) | , | " | " | Windows-1252, UTF-8 w/ BOM | CR | No | Many regional versions of Excel will not be able to deal with Unicode in CSV. | Microsoft Office Excel 2011 (numerals with decimal comma) | CSV (Mac) | ; | " | " | Windows-1252, UTF-8 w/ BOM | CR | No | Many regional versions of Excel will not be able to deal with Unicode in CSV. | LibreOffice Calc (Multi platform) | CSV / DSV / TSV | Any | " or ' | " | Any | CR / LF / CR+LF | Yes | Supports all variations

w/ BOM = With Byte Order Mark

w/o BOM = Without Byte Order Mark

Revisions

Top Editors
Recently Edited Articles