23 Aralık 2010 Perşembe 23:22
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)?
27 Aralık 2010 Pazartesi 05:26Moderatör
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.
- Yanıt Olarak İşaretleyen Jennifer ZhanModerator 31 Aralık 2010 Cuma 05:53
28 Ocak 2011 Cuma 01:40
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?
04 Mart 2011 Cuma 16:02
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
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.
21 Mart 2012 Çarşamba 04:52
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
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
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.