Open UTF-8 csv files by double-clicking in Excel

Asked in superuser.

It is not possible to open a UTF-8 csv file by simple double-clicking in Excel.

I must use the import feature "Get Data > From File > From Text/CSV". In the query panel, there will be a box to select encoding method.

The CSV file format has no provision for describing character encoding. The encoding is usually set at the receiving end. 1


Tags

  1. cat.tut

Footnotes

  1. https://support.google.com/docs/thread/134627444?hl=en&msgid=134658058˄