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

[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.

 

[Bryan Hessey]

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

HTH

 

[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]

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

--

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 b
installed
for the same.

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