如何将csv文件编码转换为utf-8 [英] How to convert csv files encoding to 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.

这篇关于如何将csv文件编码转换为utf-8的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！