使用UTF-8将Excel(XLS)转换为CSV [英] Excel (XLS) to CSV with UTF-8
问题描述
我已阅读以下建议以转换为UTF-8编码(希伯来语)通过Google文档将XLS转换为CSV,并且有效。当我在Sublime2中使用UTF8编码打开CSV时,希伯来语正确显示。但是然后,当我尝试使用SQLyog将数据导入到我的数据库时,在确保将我的目标表和导入定义都设置为UTF8之后,我得到了胡言乱语,例如:מ××¨×©×•× ª
我哪里出错了?
I have read the following advice for converting UTF-8 encoded(Hebrew) XLS to CSV via Google Docs, and it worked. When I open the CSV in Sublime2 with UTF8 encoding the Hebrew is showing correctly. But then, when I try to import the Data to My DB using SQLyog, after making sure that both my target table and the import definitions are set to UTF8, I get gibberish, like: מ×"רשות Where did I go wrong?
推荐答案
从excel导出到csv的最佳方法是:
The best way to export from excel to csv is:
- 打开excel文件,然后单击另存为...
- 插入名称,然后在另存为文件类型选择 CSV(逗号分隔)
-
然后,单击工具并选择 Web选项
- Open the excel file and click on "Save as..."
- Insert a name and then in "Save as File Type" select "CSV (Comma delimited)"
Then, click on "Tools" and select "Web Options"
转到编码,在将该文档另存为选项下,选择 Unicode(UTF-8)。
Go to "Encoding", under the option "Save this document as" select "Unicode (UTF-8)".
Listo! I couldn't leave the answer in the proper question : (
找到原始帖子> eHow(西班牙语)
此图片。
Some images of this.
这篇关于使用UTF-8将Excel(XLS)转换为CSV的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!