4 ms·
Switch from the developer world to the business world and everybody has Excel to open the CSV files with the article information, the sales numbers and so on an
by martin_a 5y ago
Switch from the developer world to the business world and everybody has Excel to open the CSV files with the article information, the sales numbers and so on and can work with that. How do you even read data from SQLite to Excel? VBA? Some obscure connector? With CSV it's "import" or even "open file".
- hnlmorg 5y agoIronically Excels implementation of CSV is terrible. It’s constantly destroying data (eg large numeric and pseudo-numeric fields) not to mention the whole issue around any cell bringing with an equal symbol being converted into a function.
- martin_a 5y agoIt totally is, but that is was most people know, next to the XLS/XLSX files themselves.
- msh 5y agoAnd some localizations of excel uses semi colon instead of comma! So no interoperability.
- hulitu 5y agoHaha. Wait to see when you receive a file made in a different language ( for example an excel file with formulas created on a japanese language computer).
- smackeyacky 5y agoSqlite has an odbc driver that excel can use