after saving chinese character in csv, i opened it again, and its turned into "?"
obviously the csv is not encoded.

so i tried to do save as and select UTF-8 by going to the save dialogue box, tools drop down button, and select web options, and select UTF-8 there.
didn;t work.

so I tried it on another computer.

this time.
I could see the option
CSV UTF-8 (Comma Delimited) (*.csv)
straight away in the drop down of many extensions, no need to progress to web options.

this method worked, i opened the csv again, and it retained the characters. this is excel 2016.

the problem is...on my own pc, with excel 2016, i do not have this option.
what can i do?