解决Excel打开UTF-8编码的CSV文件乱码的问题

学向勤中得，萤窗万卷书。这篇文章主要讲述解决Excel打开UTF-8编码的CSV文件乱码的问题相关的知识，希望能为你提供帮助。
解决Excel打开UTF-8编码的CSV文件乱码的问题

引用自：https://en.wikipedia.org/wiki/Comma-separated_values

“
CSV formats are not limited to a particular character set. They work just as well with Unicode character sets (such as UTF-8 or UTF-16) as with ASCII (although particular programs that support CSV may have their own limitations). CSV files normally will even survive naive translation from one character set to another (unlike nearly all proprietary data formats). CSV does not, however, provide any way to indicate what character set is in use, so that must be communicated separately, or determined at the receiving end (if possible).

Databases that include multiple relations cannot be exported as a single CSV file.
”

CSV是一个平面文件，它的编码方式有多种。比如，MongoDB以UTF-8格式存储数据，在使用mongoexport导出为CSV文件时，CSV的编码即为UTF-8。（可以将导出的CSV文件用UltraEdit打开来验证编码格式）

当直接使用Excel打开UTF-8编码的CSV文件时会出现乱码。

“
Microsoft Excel will open .csv files, but depending on the system\'s regional settings, it may expect a semicolon as a separator instead of a comma, since in some languages the comma is used as the decimal separator. It also applies some magic, such as reformatting what looks like numbers, eliminating leading + or 0, which breaks phone numbers, or a leading = makes the cell a formula, where function names must be in the opener\'s local language. Also, many regional versions of Excel will not be able to deal with Unicode in CSV. One simple solution when encountering such difficulties is to change the filename extension from .csv to .txt; then opening the file from an already running Excel instance with the "Open" command, where the user can manually specify the delimiters, encoding, format of columns, etc.
”

Excel打开CSV文件依赖于系统的区域设置。由于区域设置的影响，以及CSV文件不同的实现，那么Excel需要以正确的方式来打开CSV文件。我们以从MongoDB导出的UTF-8格式编码的CSV文件为例：

1. 打开Excel应用程序。

2. 点击“数据”菜单的“自文本”：