On 30-7-2015 20:07, Richard Hipp wrote: > On 7/30/15, Sylvain Pointeau <sylvain.pointeau at gmail.com> wrote: >> I understood from the mailing list, that CSV is not a defined format, then >> let's propose another format, well defined, the Excel one (which is in my >> experience a format to is good every time I had to exchange CSV files). >> >> Then why don't you propose an import of CSV from Excel (or similar)? >> csv(excel) >> >> is it possible? in a lot of cases, I cannot use sqlite (executable) because >> of the lack of a good CSV import. It would really great if this could be >> addressed. >> > > An Excel-to-SQLite converter utility sounds like it would be a great > open-source project. Why don't you start it up? >
+1 Except for the fact that "CSV is not a defined format"...... It's not a defined format because: 1) CSV is an acornym for 'Comma Separated Values' 2) There are countries in the world which use a comma ',' as a decimal separator 3) Excel (or Microsoft) decided to use the ';' as a separator in case the decimal separator is a ',' Defined would be: 1) All numeric values have a decimal separator (if the are decimals ) 2) All text values are enclosed in double quotes (to make sure a ',' containted in a text is not seen as a separator. And special treatment is provided for the double quoot in the text. 3) Some definition might be needed about line endings (CR, CRLF, LF)
