Oturum Aç
 
Ana SayfaKütüphaneEğitimIndirinSorun GidermeForumlar
BT Uzmanları için Kaynaklar >
> 
> 
Can any version of Excel save to a CSV file that is either UTF-8 or UTF-16 encoded (unicode)?

Yanıt Can any version of Excel save to a CSV file that is either UTF-8 or UTF-16 encoded (unicode)?

  • 23 Aralık 2010 Perşembe 23:22
     
     
    Oylamak İçin Oturum Aç
    0

    Are there any versions of Excel (chinese, japanese, russian... 2003, 2007, 2010...) that can save CSV files in Unicode (either UTF-8 or UTF-16)?

    If not, is the only solution to go with tab-delimited files (save as Unicode-text option)?

     

     

     

     

Tüm Yanıtlar

  • 27 Aralık 2010 Pazartesi 05:26
    Moderatör
     
     Yanıt
    Oylamak İçin Oturum Aç
    0

    Hi,

    I have tested on my side with office 2010 professional and plus. I create an Excel and type both chinese characters and english characters in it. Then I save this file into .csv format with UTF-8. It saves OK.

    When I open this file, all english characters display normal, but all of chinese characters display as ?.

    So if you just use english characters, it is fine to save and open a CSV file with UTF-8.

    Hope that helps.

     
  • 28 Ocak 2011 Cuma 01:40
     
     
    Oylamak İçin Oturum Aç
    0

    Hi Jen,

     

    Thanks for the response. I have to use chinese characters in my csv file and having columns of ?? is no good.

     

    Can anyone help on how to keep the characters in there?

     

    Mark

     
  • 04 Mart 2011 Cuma 16:02
     
     
    Oylamak İçin Oturum Aç
    0

    Hi Mark,

    I have the same problem. Trying to save my CSV file in UTF8 encoding. After several hours in searching and trying this also in my VSTO Add-In I got nothing. Saving file as Unicode option in Excel creates file as TAB separated. Because I'd like to save the file in my Add-In application, the best to do is (for my problem) saving file as unicode tab delimited and then replacing all tabs with commas in the file automatically.

    I don't think there is a direct way to save CSV as unicode in Excel. And I don't understand why.

     
  • 25 Kasım 2011 Cuma 14:38
     
     
    Oylamak İçin Oturum Aç
    0

    This is not a solution to original problem. Can you please mark the question as unanswered?

    I am facing the same problem and haven't found a solution yet.

    ~Zendu
     
  • 21 Mart 2012 Çarşamba 04:52
     
     
    Oylamak İçin Oturum Aç
    0

    1) Save as Unicode ( Automatically in Tab Separated Format)

    2) Use Editplus, do the change a follows:

    search Tab, change to ","

    add " in the first

    add " at the end

    3) save it, that it the best method I can find

    Any comments?


    I am using Chinese Windows 7 (HK) with Office 2010.
    • Düzenleyen Bus's Ba Ba 21 Mart 2012 Çarşamba 04:52
    •  
     
  • 04 Ağustos 2012 Cumartesi 18:12
     
     
    Oylamak İçin Oturum Aç
    0

    This is really insufficient for all us not having English as our main language!! I can't even see which format the text is in, where does this info appear? Or is unicode the only format for Excel??

    I have to save excelfiles into .csv with utf-8 format in order to import the data into a MySQL database and need to see what I am doing!!

    Having to use lots of other programs after export from Excel is really unacceptable when you think about it!

    I'm using Excel 2007.