3 ms·
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 es
by balls187 12y ago
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)
- gcanyon 12y agoIt's important to point out that there is no standard for CSV files, only conventions.
- ajanuary 12y agoThere 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.
- pdw 12y agoThere are no standard CSV files. There's even no "Excel standard": Excel uses different delimiters in different locales. It's a huge pain.