3 ms·
1. They're an OK format if you avoid things like multiline strings, escape strings inside escape strings, data that needs complex character encoding, things tha
by michaelt 9y ago
1. They're an OK format if you avoid things like multiline strings, escape strings inside escape strings, data that needs complex character encoding, things that might get parsed as dates or times, numbers that could suffer from rounding problems, lines with different numbers of entries and so on.
There's actually quite a lot of stuff, in real business environments, that meets those criteria. Lots of stuff doesn't, obviously, but lots of stuff does.
2. If in doubt, most users will be happy enough if you do what Excel does.
3. A lot of this stuff is in business environments, where the end user doesn't make the purchasing decision, so if the data has to be manually formatted just so, users will often suck it up (and/or won't pay for improvements)