如何使用Excel以UTF-8编码打开文本文件? [英] How to open a text file with Excel in UTF-8 encoding?

问题描述

我有一个扩展名为".tsv"的文本文件. 它具有UTF-8编码，并且包含西里尔字符. 当我尝试使用功能打开方式"->"Excel"打开它时，Excel无法显示正确的字符，而如果我以相同的方式用Notepad ++打开它，则可以正确看到字符. 我想避免使用向导在Excel中导入文件.

I have a text file with ".tsv" extension. It has UTF-8 enconding and it contains cyrillic characters. When I try to open it with the function: "Open with"-> "Excel", Excel doesn't show the correct characters, while if I open it with Notepad++ in the same way, I can see characters correctly. I would like to avoid importing the file in Excel with the wizard.

推荐答案

使用数据，获取外部数据，从文本获取并为文件来源提供正确的编码.

Use Data, Get External Data, From Text and supply the proper encoding for the File Origin.

这篇关于如何使用Excel以UTF-8编码打开文本文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！