If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Open UTF-8 in Excel 2007
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? "simplex" wrote: 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? |
#3
|
|||
|
|||
UTF-8 Delimited
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: On Tuesday, April 22, 2008 8:08 PM simple wrote: 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? On Tuesday, April 29, 2008 9:24 AM Entit wrote: I'm in a like situation. I am in a like situation. So far there iseems to be very little information on this in the context of MS 2007 products... Did you happen to find a solution since 4/22? "simplex" wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice C# And The Little Iterator That Could http://www.eggheadcafe.com/tutorials...e-iterato.aspx |
Thread Tools | |
Display Modes | |
|
|