Not sure I would call CSV a "standard text format" - I've seen many many problem...

k__ · on March 27, 2019

Haha, yes I remember building my first HTTP-API in 2010.

It had to deliver three kinds of formats: CSV, JSON, and XML.

JSON was a one-liner, then came CSV and then XML.

But all the consultants working in customer projects said CSV was the most important one because it's industry standard.

When the consultants sent me example CSV files from like 5 customers I couldn't believe they all had a different format.

jstimpfle · on March 27, 2019

Yes, CSV in the wild is an absolute mess. It was made an RFC standard at some point but even that was quite unclear if I recall correctly. That's why I wrote "a fixed CSV".