How can I save a csv with utf-8 encoding using Excel 2013?
I would like so save a csv file from an Excel 2013 sheet with utf-8 encoding. I have not seen an option for this in the user interface. However there is an option after pressing save under the tools dropdown list / webalternatives / encoding. But if I select utf-8 there it has no effect.
Does someone know how to do this?
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 it set to ANSI change it to UTF-8 and save the file as new file and then your done. If someone has a program or script that can do this without notepad I sure would like to know how.
Hope this info helps someone.