如何将csv文件编码转换为utf-8

问题描述:

是否可以将 iso-8859-13 编码的csv数据转换为 UTF-8

Is it possible to convert csv data that has iso-8859-13 encoding to UTF-8?

我的旧系统没有 UTF-8 编码,它只使用 iso-8859 -13 。我需要导入的系统没有 iso-8859-13 ,但是同时具有 UTF-8 UTF-16 。如果我尝试使用 iso-8859-13 以外的编码打开csv文件,则无法识别某些符号。如果我尝试将此类文件导入新系统,则会出现错误,我编码错误。我只能使用 windows-1252 导入它,但随后会导入无法识别的符号。如何将其转换为普通编码,例如 UTF-8

My old system does not have UTF-8 encoding, it uses only iso-8859-13. The system that I need to import to does not have iso-8859-13, but has both UTF-8 and UTF-16. If I try to open the csv file with an encoding other than iso-8859-13, then some symbols are not recognized. If I try to import such file into the new system, it gives an error that I have wrong encoding. I can only import it using windows-1252, but then it will import with unrecognized symbols. What can I do to convert it to normal encoding such as UTF-8?

我只能使用文本编辑器进行转换。我用 iso-8859-13 编码打开了csv文件。然后使用 utf-8 创建空csv文件。然后简单地将所有内容从一个csv复制到另一个。然后我可以将它导入新系统。

I was able to convert simply using text editor. I opened csv file with iso-8859-13 encoding. Then created empty csv file with utf-8. Then simply copied everything from one csv to another. Then I could import it into new system.

以前我试过用libreoffice做这个,但出于某种原因它会用 iso-8859保存-13 编码。

Previously I tried to do this with libreoffice, but for some reason it would save with iso-8859-13 encoding.