michaelzhou23
asked on
How to specify the encoding of MS Excel to UTF-8?
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?
Thanks!
So how do I tell MS Excel to change the encoding to UTF-8 so I can properly view the CSV file?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
try adding a BOM to the front of the file
Perhaps this might help