Question

Q: How can I save a csv with utf-8 encoding using Excel 2013?

Hi!

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?

/Peter

Answer

A:

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.

Did this solve your problem?

Sorry this didn't help.

151 people were helped by this reply



 
Question Info

Views: 163,817 Last updated: May 17, 2018 Applies to: