software

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:
gt; I have a CSV File in Japanese which is encoded in UTF-8 encoding.
gt;
gt; If i try to open in Notepad , the data is displayed properly
gt; if i open the file in Excel (Office 2000) , the data is not displayed
gt; properly
gt;
gt; Can you pls tell me how to open this CSV file in Excel.
gt; Is there any setting in excel to support UTF-8 encoding.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533660Thanks 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.

quot;Bryan Hesseyquot; wrote:

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


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:
gt; Thanks for your information.
gt; As u said there is an option available in Office 2003.
gt; But it is not present in Office 2000.Is there any patches to be
gt; installed
gt; for the same.
gt;
gt; Apart from Import option is there any method to open the CSV
gt; File(utf-8
gt; data) directly.
gt;
gt; quot;Bryan Hesseyquot; wrote:
gt;
gt; gt;
gt; gt; try opening via Data, Import Data, and in the first Wizard screen
gt; select
gt; gt; File Origin as UTF-8
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; Elayaraja Wrote:
gt; gt; gt; I have a CSV File in Japanese which is encoded in UTF-8 encoding.
gt; gt; gt;
gt; gt; gt; If i try to open in Notepad , the data is displayed properly
gt; gt; gt; if i open the file in Excel (Office 2000) , the data is not
gt; displayed
gt; gt; gt; properly
gt; gt; gt;
gt; gt; gt; Can you pls tell me how to open this CSV file in Excel.
gt; gt; gt; Is there any setting in excel to support UTF-8 encoding.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Bryan Hessey
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; Bryan Hessey's Profile:
gt; www.excelforum.com/member.php...oamp;userid=21059
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=533660
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533660