Re:SQLite as an Application File Format (2014)
by beefield on Tuesday December 25, 2018 @07:48AM
(#18757214)
Well, my personal rule is to never touch csv with excel, because depending on the locales, most of the time excel breaks something in the file. (Of course, in theory I might make a flawless data type mapping when importing the file to excel, but unfortunately that happening is quite rare...)
Re:SQLite as an Application File Format (2014)
by johannes1234321 on Tuesday December 25, 2018 @08:50AM
(#18757382)
This is a concern and there are lots of issues (also think about proper escaping etc.) but Excel is ubiquitous outside hackernews's demography.
For sqlite there's hardly an approvable tool for analysis of the data.
Excel is driving the world.