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

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

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

--

Elayaraja Wrote:
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




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