?
Solved

How to specify the encoding of MS Excel to UTF-8?

Posted on 2011-03-02
3
Medium Priority
?
739 Views
Last Modified: 2012-05-11
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!
0
Comment
Question by:michaelzhou23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 47

Expert Comment

by:for_yan
ID: 35018550
0
 
LVL 9

Accepted Solution

by:
McOz earned 500 total points
ID: 35018557
Check out this link:
http://www.itg.ias.edu/node/544
0
 
LVL 92

Expert Comment

by:objects
ID: 35022269
try adding a BOM to the front of the file
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Suggested Courses
Course of the Month15 days, 3 hours left to enroll

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question