I want to export Excel to Tab delimited (.txt) file with special character.
我想将Excel导出为带有特殊字符的制表符分隔（.txt）文件。
I've changethe format to UTF-8, but it still doesnt work.
我将格式更改为UTF-8，但它仍然无法正常工作。
The origin data is like Mädchen and what i got is M?dchen
原始数据就像Mädchen，我得到的是M？dchen
Anyone can help me? Thank you
有人可以帮帮我吗？谢谢
3 个解决方案
#1
1
This was similarly asked and answered before: Excel to CSV with UTF8 encoding. Take a look at Eric's answer.
之前也有类似的要求和回答：使用UTF8编码的Excel到CSV。看看Eric的回答。
#2
1
The best way to do it is to save the file as an Unicode text file. And save as the unicode text file, change the encoding to utf-8
最好的方法是将文件保存为Unicode文本文件。并保存为unicode文本文件，将编码更改为utf-8
#3
-1
Save it as Unicode text file. It will still save as Tab Delimited and preserve all the versatile non-English characters.
将其另存为Unicode文本文件。它仍将保存为制表符分隔并保留所有多功能的非英语字符。
#1
1
This was similarly asked and answered before: Excel to CSV with UTF8 encoding. Take a look at Eric's answer.
之前也有类似的要求和回答：使用UTF8编码的Excel到CSV。看看Eric的回答。
#2
1
The best way to do it is to save the file as an Unicode text file. And save as the unicode text file, change the encoding to utf-8
最好的方法是将文件保存为Unicode文本文件。并保存为unicode文本文件，将编码更改为utf-8
#3
-1
Save it as Unicode text file. It will still save as Tab Delimited and preserve all the versatile non-English characters.
将其另存为Unicode文本文件。它仍将保存为制表符分隔并保留所有多功能的非英语字符。