3 ms·

Surprisingly, Excel can import CSV from UTF8 with BOM (at least new versions of Excel). However, be careful, as Ctrl+S will save it in some arbitrary codepage a

Surprisingly, Excel can import CSV from UTF8 with BOM (at least new versions of Excel). However, be careful, as Ctrl+S will save it in some arbitrary codepage and you'll probably end up with a document like: ID,Name 1,??? ???? 2,Kevin Dub?is so take care to always save such documents as .xmlx. (If you convert them to your local codepage and import that - when at all relevant - it will be saved in the local codepage, so less risk of data loss.)

masklinn 10y ago
> Surprisingly, Excel can import CSV from UTF8 with BOM (at least new versions of Excel). A BOM is abnormal and not recommended in UTF-8, it's basically a shitty MS hack: the BOM is necessary to detect endianness differences between the document and the host system, endianness has no impact impact on UTF-8. And as freak_nl above notes, Excel uses locale-dependent field separators, so in some countries/locales it will try to import "CSV" with semicolon separators.