Link to home
Start Free TrialLog in
Avatar of michaelzhou23
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!
Avatar of for_yan
for_yan
Flag of United States of America image

ASKER CERTIFIED SOLUTION
Avatar of McOz
McOz

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mick Barry
try adding a BOM to the front of the file