How to open a UTF-8 encoded CSV file in Excel

I have a CSV File in Japanese which is encoded in UTF-8 encoding.

If i try to open in Notepad , the data is displayed properly
if i open the file in Excel (Office 2000) , the data is not displayed properly

Can you pls tell me how to open this CSV file in Excel.
Is there any setting in excel to support UTF-8 encoding.

try opening via Data, Import Data, and in the first Wizard screen select File Origin as UTF-8

HTH

Originally Posted by Elayaraja

I have a CSV File in Japanese which is encoded in UTF-8 encoding.

If i try to open in Notepad , the data is displayed properly
if i open the file in Excel (Office 2000) , the data is not displayed properly

Can you pls tell me how to open this CSV file in Excel.
Is there any setting in excel to support UTF-8 encoding.

Thanks for your information.
As u said there is an option available in Office 2003.
But it is not present in Office 2000.Is there any patches to be installed
for the same.

Apart from Import option is there any method to open the CSV File(utf-8
data) directly.

"Bryan Hessey" wrote:

>
> try opening via Data, Import Data, and in the first Wizard screen select
> File Origin as UTF-8
>
> HTH
>
> Elayaraja Wrote:
> > I have a CSV File in Japanese which is encoded in UTF-8 encoding.
> >
> > If i try to open in Notepad , the data is displayed properly
> > if i open the file in Excel (Office 2000) , the data is not displayed
> > properly
> >
> > Can you pls tell me how to open this CSV file in Excel.
> > Is there any setting in excel to support UTF-8 encoding.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=533660
>
>

Unfortunately I no longer have access to the earlier versions of Office, and am not aware of the UTF-8 capabilities of '2000.

Hopefully someone better qualified will answer your question

--

Originally Posted by Elayaraja

Thanks for your information.
As u said there is an option available in Office 2003.
But it is not present in Office 2000.Is there any patches to be installed
for the same.

Apart from Import option is there any method to open the CSV File(utf-8
data) directly.

"Bryan Hessey" wrote:

>
> try opening via Data, Import Data, and in the first Wizard screen select
> File Origin as UTF-8
>
> HTH
>
> Elayaraja Wrote:
> > I have a CSV File in Japanese which is encoded in UTF-8 encoding.
> >
> > If i try to open in Notepad , the data is displayed properly
> > if i open the file in Excel (Office 2000) , the data is not displayed
> > properly
> >
> > Can you pls tell me how to open this CSV file in Excel.
> > Is there any setting in excel to support UTF-8 encoding.
>
>
> --
> Bryan Hessey
> ------------------------------------------------------------------------
> Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
> View this thread: http://www.excelforum.com/showthread...hreadid=533660
>
>