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

问题描述

我有一个Excel文件，有一些西班牙文字符（波浪号等），我需要转换为一个CSV文件用作导入文件。但是，当我另存为CSV时，可以将特殊的西班牙字符转换为ASCII字符。它似乎也是这样做的，左边和右边的引号和长破折号，似乎来自原来的用户在Mac中创建Excel文件。

由于CSV只是一个文本文件我确定它可以处理一个UTF8编码，所以我猜这是一个Excel限制，但我正在寻找一种方法从Excel到CSV，并保持非ASCII字符不变。

解决方案

简单的解决方法是使用Google电子表格。粘贴（只有具有复杂公式的值）或导入工作表然后下载CSV。我刚刚尝试了几个字符，效果很好。

注意：导入时，Google表格有限制。请参阅此处。

注意：使用Google表格小心敏感数据。

编辑：另一种替代方法 - 基本上他们使用VB宏或加载项来强制保存为UTF8。我没有尝试任何这些解决方案，但听起来很合理。

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.

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.

解决方案

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.

NOTE: Google Sheets does have limitations when importing. See here.

NOTE: Be careful of sensitive data with Google Sheets.

EDIT: 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到CSV与UTF8编码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！