I will hard disagree here. Always have has a clrf issue or another weirdness come up. Especially if you work with teams from different countries, csv is hell.

I will hard disagree here. Always have has a clrf issue or another weirdness come up. Especially if you work with teams from different countries, csv is hell. I always generate rfc compliant csv, not once it was accepted from day one. Once, it took us two weeks to make it pass the ingestion process (we didn't have access to the ingest logs and had to request them each day, after the midnight processing) so in the end, it was only 10 different tries, but still. I had once an issue with json (well, not one created by me) , and it was clearly a documentation mistake. And I hate json (I'm an XML proponent usually). Csv is terrible.