Results 1 to 6 of 6

Thread: MS excel is not asking for CSV and Unicode (or UTF-8)

  1. #1
    Join Date
    Jun 2011
    Posts
    29

    MS excel is not asking for CSV and Unicode (or UTF-8)

    I am having Microsoft office 2003 installed in my computer and the problem is that whenever I save the Excel file to CSV file then the Excel is not prompting that whether I have to save Unicode in UTF-8. I need to save that in save Unicode in UTF-8 but cannot do that. Other that this when I tried to amend a CSV to insert some Chinese characters within it then Excel do not concern for the encoding. I think that the Excel doesn't mind regarding UTF-8.

  2. #2
    Join Date
    Nov 2008
    Posts
    1,185

    Re: MS excel is not asking for CSV and Unicode (or UTF-8)

    If you see in the excel the you will find one of the save as options as the Unicode. I am not very much concerned about the Unicode and UTF-8 if you can answer some question fo mine then I may help you to understand this. I think that you are integrating your metaphors through saving an XLS file toward CSV and after that desiring it within Unicode format. You can try to go straight as of XLS toward Unicode. So do that and let us know what happens.

  3. #3
    Join Date
    Nov 2008
    Posts
    1,221

    Re: MS excel is not asking for CSV and Unicode (or UTF-8)

    First of all you will have to open the Excel file where you are having the .xls, .xlsx file. After that, from the Excel select CSV for the file type save it with that extension. Now open saved .csv file within Notepad and then select save as and you will get one of the options as "Encoding". Choose UTF-8 and save that with a bit change in the name and see if that can help you or not. This file is within UTF-8 and retains every characters as well as accents and can be trade in, for example, within MySQL and additional database programs.

  4. #4
    Join Date
    Nov 2008
    Posts
    1,022

    Re: MS excel is not asking for CSV and Unicode (or UTF-8)

    Click on the start an go to the control panel. Look for the Regional and Language options with the classic mode. Otherwise you can type its name in the search bar and you will get that. Go to the Advanced tab and then click locales. Finally click the desired utf08 encoding program which you would like to save through excel into csv. So try this and reply back if this works for you or not.

  5. #5
    Join Date
    May 2008
    Posts
    860

    Re: MS excel is not asking for CSV and Unicode (or UTF-8)

    I have newly had issue in opening .csv with Unicode encoding that the expressions with this encoding could be altered to approach stamps. I attempted so hard for tackling this situation and hunted on the net for hours to spot a key to root out why I could probably recovery xlsx that is Excel 2007 Universal emulate sort that is utilizing xml for safeguarding its information without any encoding situations with utf-8 and even persian and arabic expressions could be spared consummately.

  6. #6
    Join Date
    May 2008
    Posts
    913

    Re: MS excel is not asking for CSV and Unicode (or UTF-8)

    I did a touch of exploration on this and it appears that there's nothing that Webform can do on its close. I could want to tell you that CSV naturally just upholds ASCII message (without unique elements). Modifying the download headers from UTF8 to ASCII (or different encodings) doesn't have any impact. So as it is, the revising ought to happen on the side of the desktop provision to peruse in the record rightly.

Similar Threads

  1. Displaying the value of a Unicode character
    By Remedy in forum Software Development
    Replies: 5
    Last Post: 26-02-2010, 02:29 AM
  2. What is the unicode in PHP V5.3
    By Abigail101 in forum Software Development
    Replies: 5
    Last Post: 20-02-2010, 12:50 AM
  3. Regular expressions for unicode
    By Solaris in forum Software Development
    Replies: 4
    Last Post: 15-12-2009, 12:20 PM
  4. Conversion from Unicode to Hindi
    By D_chapple in forum Software Development
    Replies: 4
    Last Post: 28-11-2009, 06:48 PM
  5. Non-gui tool to modify unicode .ini file
    By cheerful in forum Windows Software
    Replies: 2
    Last Post: 25-08-2009, 09:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,491,533.11824 seconds with 17 queries