3 ms·
CSV is not standardized, it might use comma or semicolon as seperator, there are different conventions for quoting and escaping, headers might be included or no
by bazoom42 3y ago
CSV is not standardized, it might use comma or semicolon as seperator, there are different conventions for quoting and escaping, headers might be included or not.
JSON is also hierarchical which makes it appropriate for a wider range of data structures.
That said, I’m not sure there is any agreed upon standard for representing data tables in JSON, so it might not be any better for the CSV use case.
- rusk 3y agoI think most people hold RFC-4180 to be the CSV standard, even if it’s not officially a standard. It is sufficiently parametrised to suit all variants while at the same time providing a language and structure that is portable across all. Don’t get hung up on the fact that RFC’s aren’t officially standards. It’s a publicly accessible standard which many people fall back on as a reference, which is more than you can say for a lot of ISO standards.
- marcosdumay 3y agoOh, you can hold it all you want, popular implementations still break it.
- SkyPuncher 3y agoExactly, the files my users submit are rarely spec compliant. I have to process them properly regardless of correctness.