3 ms·
The main reason you'd choose CSV is precisely that you can open it in Excel.
by emodendroket 9y ago
The main reason you'd choose CSV is precisely that you can open it in Excel.
- rjbwork 9y agoI use CSV (really tsv) because big data tools can open them extremely easily, because they're human readable, and because they're easy for my software stack to parse and use. I do most of my data processing for local consumption on a repl-like tool. We have a defined configuration for TSV we use internally that is lossless in terms of storing and extracting a number of complex data types. Embedded JSON with embedded separators in that JSON? No problem.
- tinus_hn 9y agoOriginally the xls format was the only open format in the office family and it was actually much easier to create xls files than to deal with the stupidity of csv
- emodendroket 9y agoThey're all open now, but the spec is monstrously large and difficult to work with. Definitely not easier to do than CSV.
- tinus_hn 9y ago.xlsx is not .xls
- emodendroket 9y agoIsn't xls a binary format? I can't imagine that's more pleasant to work in.
- tinus_hn 9y agoI take a defined format like .xls over an unspecified de facto ‘standard’ like .csv anytime. In many locales .csv files don’t even contain comma separated values because the comma is the decimal symbol already. It’s a mess, half of the time Microsoft can’t make it work either even when you only use their software.
- emodendroket 9y agoYou can use sep for that.