User Tools

Site Tools


csv_formats

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
CSV , UTF-8 w/o BOM

A list of CSV formats supported by applications.

Application Format Delimiter Column Wrapper Escape character Encoding EOL LiteCart Compliant
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
Microsoft Office Excel 2010 (numerals with decimal comma) DSV (MS-Dos) ; UTF-8 w/o BOM CR+LF No
Microsoft Office Excel 2011 (numerals with decimal point) DSV (Mac) , Windows-1252, UTF-8 w/ BOM CR No
Microsoft Office Excel 2011 (numerals with decimal comma) CSV (Mac) ; Windows-1252, UTF-8 w/ BOM CR No
LibreOffice Calc (Multi platform) CSV / DSV / TSV Any “ or ' Any CR / LF / CR+LF Yes

w/ BOM = With Byte Order Mark

w/o BOM = Without Byte Order Mark

csv_formats.txt · Last modified: 2015/06/08 02:29 by 78.72.180.122