How to open a .csv file that uses UTF-8 character encoding

From Kolmisoft Wiki
Jump to navigationJump to search

One easy way to change excel ANSI encoding to UTF-8 is the open the .csv file in notepad, then select File > Save As.

Now at the bottom you will see encoding which is set to ANSI. Change it to UTF-8, save the file as new file and then your done.

See also

https://www.itg.ias.edu/content/how-import-csv-file-uses-utf-8-character-encoding-0