How to specify the encoding of MS Excel to UTF-8?
Posted on 2011-03-02
I have a CSV file containing French characters, encoded in UTF-8. When I open it using MS Excel it just displays garbled characters. On the other hand, if I open it using OpenOffice, I was prompted with a dialog letting me to choose the encoding so I could choose UTF-8 and displays it properly.
So how do I tell MS Excel to change the encoding to UTF-8 so I can properly view the CSV file?