Excel到UTF8编码的CSV [英] Excel to CSV with UTF8 encoding

查看:357
本文介绍了Excel到UTF8编码的CSV的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个Excel文件,其中包含一些西班牙字符(波浪线等),需要转换为CSV文件以用作导入文件。但是,当我另存为CSV它会损坏不是ASCII字符的特殊西班牙字符。它似乎也是这样做的左和右引号和长破折号,似乎是来自原始用户创建在Mac的Excel文件。

I have an Excel file that has some Spanish characters (tildes, etc.) that I need to convert to a CSV file to use as an import file. However, when I do Save As CSV it mangles the "special" Spanish characters that aren't ASCII characters. It also seems to do this with the left and right quotes and long dashes that appear to be coming from the original user creating the Excel file in Mac.

由于CSV只是一个文本文件我确定它可以处理一个UTF8编码,所以我猜它是一个Excel的限制,但我正在寻找一种方式从Excel到CSV,并保持非ASCII字符完整。 p>

Since CSV is just a text file I'm sure it can handle a UTF8 encoding, so I'm guessing it is an Excel limitation, but I'm looking for a way to get from Excel to CSV and keep the non-ASCII characters intact.

推荐答案

一个简单的解决方法是使用Google电子表格。粘贴(仅当您有复杂公式时为值)或导入工作表,然后下载CSV。

A simple workaround is to use Google Spreadsheet. Paste (values only if you have complex formulas) or import the sheet then download CSV. I just tried a few characters and it works rather well.

注意:Google表格在导入时有限制。

NOTE: Google Sheets does have limitations when importing.

EDIT:另一种替代方法 - 基本上他们使用VB宏或插件强制保存为UTF8。我没有尝试过任何这些解决方案,但他们听起来很合理。

Another alternative - basically they use VB macro or addins to force the save as UTF8. I have not tried any of these solutions but they sound reasonable.

这篇关于Excel到UTF8编码的CSV的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆