1

I want to open UTF-8 coded csv- or text-files directly in Excel 2016 or later. Of course I am aware of the import option, but I want to do this with a simple double-click.

Problem is that this way Excel will not show all UTF-8 characters - e.g. Cyrillic characters - correctly.

My OS is Windows 10.

Stefan Martens
  • 11

1 Answers1

1

The ways to achieve this that I can see are:

  • Prepend a Byte Order Mark (BOM) at the beginning of the file, preferably when the CSV file is created. The UTF-8 BOM is the hexadecimal byte sequence 0xEF,0xBB,0xBF.

  • For advanced users : Add a VBA macro to open the file as UTF-8 with the parameter Origin:=65001 for UTF-8.

You will find more details and flavors of the above in the post
Is it possible to force Excel recognize UTF-8 CSV files automatically?

harrymc
  • 498,455