Skip Navigation

Programming @programming.dev

JackbyDev @programming.dev

5mo ago

TIL that RFC 4180 specifies the CSV format to use CRLF line endings

datatracker.ietf.org

RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) Files

I noticed a repository's .gitattributes entry for *.csv used text eol=crlf so I investigated and found this.

5 comments

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
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…
We want to move down to the next line (line feed) but also to the beginning of that line (carriage return) after all.