Unable to save CSV and Unicode in Microsoft Office 2003

[Ajitey]

Sponsored Links

Hello friends, when save any of the excel file to CSV then it do not ask about the encoding of the file. Well i want to save the Unicode in UTF-8 but i am not able to save it. I have tried to work on the CSV file and add some of the Chinese character on to it and save it, so when i try to open again in the Excel then also it was not asking for the encoding. So does anyone has the solution to get it done and also to have the work it. So please tell me about it. Thank you.

[Alfons]

I have searched for one thing which that the get around opening is that to change the .csv to .txt then it works. So when you will open the test file then you will be able to get the encoding it and also you will get what you wish to have it. So it was the thing that you have to do little changes in the file extension and behavior then it works. As the Excel does not care about the UTF-8.

[Killer-Boy]

Well i am also using the Excel 2003 and in that there is one option which is for the Unicode. I just wanted to know that are you doing some changes with the metaphors as saving the XLS file to CSV and then doing the unicode format. So i wanted to ask if i do directly, like from XLS to unicode, so it is possible to do it or not. Please tell me about it.

[Gania]

I have the answer to the question which you have asked, but before that let me tell you that there is difference between what is displayed and what is kept hidden in the Excel .csv file. So you wanted to do the unicode of the .CSV file then follow the step

• Open the Excel file in which you are having the information, it should be the .xls/.xlsx file
• Now go to the "Save As" and in that you select the "CSV (Comma Delimited) (*.csv) as the save file type
• When you have selected that then click on save
• Now you open the Notepad.
• Now tey to open the .csv file which you have saved it, when you will search for the file then select file type "All Files"
• Once the file is been opened then go the file and select the "Save As"
• So when you are saving it then you will see the option of the Encoding in the bottom, so you select the UTF-8 (Do not select the ANSI, if you do that then you will lose all the contacts).
• You now click on the Save and it will be saved in the UTI 8,

Now you will be able to get all the contacts and also you can import the contacts.

[Ajitey]

Originally Posted by Gania

I have the answer to the question which you have asked, but before that let me tell you that there is difference between what is displayed and what is kept hidden in the Excel .csv file. So you wanted to do the unicode of the .CSV file then follow the step

• Open the Excel file in which you are having the information, it should be the .xls/.xlsx file
• Now go to the "Save As" and in that you select the "CSV (Comma Delimited) (*.csv) as the save file type
• When you have selected that then click on save
• Now you open the Notepad.
• Now tey to open the .csv file which you have saved it, when you will search for the file then select file type "All Files"
• Once the file is been opened then go the file and select the "Save As"
• So when you are saving it then you will see the option of the Encoding in the bottom, so you select the UTF-8 (Do not select the ANSI, if you do that then you will lose all the contacts).
• You now click on the Save and it will be saved in the UTI 8,

Now you will be able to get all the contacts and also you can import the contacts.

Thanks, i know just came to know that how to get the unicode for the CSV file and i have the method it is been working for me. I have tried the other method to get but none was not working.