Open UTF-8 in Excel 2007

S

simplex

I have UTF-8 encoded tab delimited data files. They have the UTF-8 header
"EF BB BF". These files would open up perfectly in Excel 2003, but in 2007
the special characters are all garbled. Is there a setting for Excel 2007 to
recognize UTF-8?
 
E

Entity

I'm in a like situation. So far there seems to be very little information on
this in the context of MS 2007 products... Did you happen to find a solution
since 4/22?
 
R

Ray Price

Hi,

I had this problem too. Don't open the file... create a new sheet, go to the data tab and use 'from text'. Then you can select the encoding.



simple wrote:

Open UTF-8 in Excel 2007
22-Apr-08

I have UTF-8 encoded tab delimited data files. They have the UTF-8 header
"EF BB BF". These files would open up perfectly in Excel 2003, but in 2007
the special characters are all garbled. Is there a setting for Excel 2007 to
recognize UTF-8?

Previous Posts In This Thread:

Open UTF-8 in Excel 2007
I have UTF-8 encoded tab delimited data files. They have the UTF-8 header
"EF BB BF". These files would open up perfectly in Excel 2003, but in 2007
the special characters are all garbled. Is there a setting for Excel 2007 to
recognize UTF-8?

I'm in a like situation.
I am in a like situation. So far there iseems to be very little information o
this in the context of MS 2007 products... Did you happen to find a solutio
since 4/22

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
C# And The Little Iterator That Could
http://www.eggheadcafe.com/tutorial...32-0ae26adaa533/c-and-the-little-iterato.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top