CSV Format Issues
Discussions revolve around the simplicity, parsing problems, and Excel-related pitfalls of CSV files, with defenses of CSV and suggestions for alternatives like TSV or JSON.
Activity Over Time
Top Contributors
Keywords
Sample Comments
What's wrong with pure CSV, again?
What's wrong with CSV? I love me a CSV file.
Or just use some other text format instead? CSV is supposed to be simple.
If CSV is giving you such problems over the years, then I have no confidence in your opinion.
CSV predates Excel, and other CSV implementations don't have this behavior
Hey! What's wrong with csv files?!
No. Excel's fault. Not CSV. There are plenty of busted CSV parsers (and serializers) too.
Or just not use CSV as a data transfer format :D
The CSV format doesn't interpret anything, it's spreadsheet applications doing that.
Yes, the "CSV road to hell":- comma separated, nothing escaped (crash when 1 column contains a comma)- comma separated, quotes around all elements, quotes not escaped- comma separated, double-quotes around all elements, double-quotes not escaped- comma separated, quotes around some elements, quotes not escaped- comma separated, double-quotes around some elements, double-quotes not escaped- comma separated, quotes around all elements, quotes escaped (using ''