CSV existed for over 30 years before RFC 4180. Excel, and countless other tools, have their own incompatible variants. Excel in particular is infamous for mangling separators when exporting to CSV.
Excel mangles everthing…
I work with a lot of EANs and every CSV import into Excel means I have to pay extra attention to the EAN field, because Excel likes to think for me, and thinks that the scientific notation would be very helpful for me… It’s not! 8.72E+12 is useless to me, Excel!!!
And don’t get me started on FEB-01.
CSV existed for over 30 years before RFC 4180. Excel, and countless other tools, have their own incompatible variants. Excel in particular is infamous for mangling separators when exporting to CSV.
Excel mangles everthing…
I work with a lot of EANs and every CSV import into Excel means I have to pay extra attention to the EAN field, because Excel likes to think for me, and thinks that the scientific notation would be very helpful for me… It’s not! 8.72E+12 is useless to me, Excel!!!
And don’t get me started on FEB-01.
I just fuckin’ hate Excel.