Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

When I open a CSV file in Excel 2013, it correctly delimits the file.

You may have non-standard CSV files (or at least delimited files that are not properly escaped)



There are no standard CSV files. There's even no "Excel standard": Excel uses different delimiters in different locales. It's a huge pain.


It's important to point out that there is no standard for CSV files, only conventions.


There is RFC4180, but that came way after people were using it in lots or ways incompatible with the spec, so it isn't a huge help when paraing arbitrary files. I'd recommend following it if you're generating files though.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: