4 ms·
Excel generates RFC-compliant CSV files if you are using the en-us/en-uk locales, but not for many other locales. Of course, this is a system-wide setting, and
by formerly_proven 5y ago
Excel generates RFC-compliant CSV files if you are using the en-us/en-uk locales, but not for many other locales. Of course, this is a system-wide setting, and Excel has no option to generate a standard CSV independent of locale.
- shellac 5y agoI used Excel recently and it added a BOM, which is pretty awful. Is there any way to stop that nonsense?
- cpach 5y agoAFAIK: Nope. Microsoft loves that BOM, for reasons I cannot comprehend.
- andylynch 5y agoAlmost certainly for backwards compatibility. Excel in particular uses the BOM as a single to open a file in a Unicode encoding, rather than cp1252 etc.
- dbsmith83 5y agoI use a script to strip it from the file. Definitely not ideal.
- dspillett 5y ago> the en-us/en-uk locales Though be careful if you communicate with people using both locals. Things interpreted as dates will get corrupted in fun ways.