Hacker News new | ask | show | jobs
by janosdebugs 1328 days ago
Any sort of office suite would be able to do it, but the data types would be very limited. CSV itself is not standardized, and with a well-constructed spreadsheet wouldn't contain information such as a currency symbol that would make more advances data types possible.
1 comments
sidpatil 1328 days ago
> CSV itself is not standardized

Actually, CSV is formalized in RFC 4180. Adherence to that spec is another story, of course. :-)

https://www.rfc-editor.org/rfc/rfc4180

link
Akronymus 1328 days ago
Over here commas are used to denote decimals. So MS decided to helpfully use the semicolon as a separator for csv files if your locale is set to german. Rather than wrapping the values in quotes. It's a PITA
link