TIL that RFC 4180 specifies the CSV format to use CRLF line endings
TIL that RFC 4180 specifies the CSV format to use CRLF line endings
This RFC documents the format used for Comma-Separated Values (CSV) files and registers the associated MIME type "text/csv". This memo provides information for the Internet community.
I noticed a repository's .gitattributes entry for *.csv used text eol=crlf so I investigated and found this.
I think csv is a bad format, if you can even call it that. Yes, there are some cases where it makes sense. I worked with an oscilloscope at uni which output csv. But other than that, I consider it more of a concept than an interface / exchange standard
We want to move down to the next line (line feed) but also to the beginning of that line (carriage return) after all.
I hate that the pleasant news about standardization of CSV come with the let-down that is using two bytes for new lines.
Don't worry, it's not really standardised despite this attempt. You can use UNIX line endings and nothing bad will happen.
Unless you open it in Excel. In which case bad things will happen no matter what you have in the CSV…