blocks|key|3468733|text|CSV文件可以是任何格式，具体取决于从Excel导出时指定的编码选项：(保存对话框、工具按钮、Web选项项、编码选项卡)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3468734|更新:+Excel+(包括Office+2013)实际上并不支持在“另存为...”中选择的web选项。对话框，所以这是某种类型的bug。我现在只是使用UTF打开我的XLSX文件，并将它们导出为OpenOffice文件(编辑过滤器设置，选择UTF8编码)。|3468735|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

CSV files could be in any format, depending on what encoding option was specified during the export from Excel: (Save Dialog, Tools Button, Web Options Item, Encoding Tab)

UPDATE: Excel (including Office 2013) doesn't actually respect the web options selected in the "save as..." dialog, so this is a bug of some sort. I just use OpenOffice Calc now to open my XLSX files and export them as CSV files (edit filter settings, choose UTF-8 encoding).

blocks|key|416818|text|在内存中，Excel使用特定于计算机的ANSI编码。因此，对于EN-US安装，这将是Windows-1252；对于俄语，这将是1251，等等。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|416819|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

From memory, Excel uses the machine-specific ANSI encoding. So this would be Windows-1252 for a EN-US installation, 1251 for Russian, etc.

blocks|key|414537|text|唤醒这个旧线程..。我们现在是2017年了。Excel仍然无法将简单的电子表格保存为CSV格式，同时保留原始编码……真是太棒了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|414538|幸运的是，Google+Docs生活在正确的世纪。对我来说，解决方案就是使用Google+Docs打开电子表格，然后以CSV格式下载回来。结果是一个正确编码的CSV文件(所有字符串都以UTF8编码)。|414539|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Waking up this old thread... We are now in 2017. And still Excel is unable to save a simple spreadsheet into a CSV format while preserving the original encoding ... Just amazing.

Luckily Google Docs lives in the right century. The solution for me is just to open the spreadsheet using Google Docs, than download it back down as CSV. The result is a correctly encoded CSV file (with all strings encoded in UTF8).

blocks|key|411039|text|上周我也遇到了类似的问题。我收到了许多具有不同编码的CSV文件。在导入到数据库之前，我使用chardet+libary自动嗅探出正确的编码。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|411040|Chardet是Mozillas字符检测引擎的一个端口，如果样本大小足够大(一个突出的字符就不行)，效果会很好。|411041|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/chardet/chardet^0|19|E|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I had a similar problem last week. I received a number of CSV files with varying encodings. Before importing into the database I then used the <a href="https://github.com/chardet/chardet" rel="nofollow noreferrer">chardet libary</a> to automatically sniff out the correct encoding.

Chardet is a port from Mozillas character detection engine and if the sample size is large enough (one accentuated character will not do) works really well.

blocks|key|416808|text|Russian+Edition提供CSV、CSV+(Macintosh)和CSV+(DOS)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|416809|当以纯CSV格式保存时，它使用windows-1251。|416810|我只是尝试将法语单词Résumé和俄语文本一起保存，它像52+3F+73+75+6D+3F一样将其保存在HEX中，3F是question+mark的ASCII代码。|416811|当然，当我打开CSV文件时，单词变得不可读(R?sum?)|416812|entityMap^0|0|F|H|3|L|F|11|9|0|3|3|F|C|0|A|6|S|H|1G|3|1L|2|1O|D|22|5|0|7|3|M|6|0^^$0|@$1|2|3|4|5|6|7|N|8|@$9|O|A|P|B|C]|$9|Q|A|R|B|C]|$9|S|A|T|B|C]|$9|U|A|V|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|11|8|@$9|12|A|13|B|C]|$9|14|A|15|B|C]|$9|16|A|17|B|C]|$9|18|A|19|B|C]|$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|J|3|K|5|6|7|1E|8|@$9|1F|A|1G|B|C]|$9|1H|A|1I|B|C]]|D|@]|E|$]]|$1|L|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]]|M|$]]

<code>Russian Edition</code> offers <code>CSV</code>, <code>CSV (Macintosh)</code> and <code>CSV (DOS)</code>.

When saving in plain <code>CSV</code>, it uses <code>windows-1251</code>.

I just tried to save French word <code>Résumé</code> along with the Russian text, it saved it in <code>HEX</code> like <code>52 3F 73 75 6D 3F</code>, <code>3F</code> being the <code>ASCII</code> code for <code>question mark</code>.

When I opened the <code>CSV</code> file, the word, of course, became unreadable (<code>R?sum?</code>)

blocks|key|3255754|text|如果选择File+>+Save+As+>+Unicode+Text+(.txt)，Excel+2010将保存UTF-16/UCS-2TSV文件。它的后缀是".txt"，你可以把它改成".tsv“。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3255755|如果你需要CSV，你可以在Notepad%2B%2B，Ultra+Edit，Crimson+editor等文本编辑器中转换TSV文件，用分号，逗号等替换制表符。请注意，例如，对于读取到DB表，通常TSV已经很好地工作了(而且它通常更容易手动读取)。|3255756|如果您需要不同的代码页，如UTF-8，请使用上面提到的编辑器之一进行转换。|3255757|entityMap^0|4|10|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|P|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|K|$]]

Excel 2010 saves an UTF-16/UCS-2 TSV file, if you select <code>File &gt; Save As &gt; Unicode Text (.txt)</code>. It's (force) suffixed ".txt", which you can change to ".tsv". 

If you need CSV, you can then convert the TSV file in a text editor like Notepad++, Ultra Edit, Crimson Editor etc, replacing tabs by semi-colons, commas or the like. Note that e.g. for reading into a DB table, often TSV works fine already (and it is often easier to read manually). 

If you need a different code page like UTF-8, use one of the above mentioned editors for converting.

blocks|key|414221|text|cp1250在Microsoft+Office文档中广泛使用，包括Word和Excel2003。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|414222|http://en.wikipedia.org/wiki/Windows-1250|offset|length|414223|确认这一点的简单方法是：|414224|414225|创建具有较高顺序字符的电子表格，例如其中一个单元格中的"Veszprém“；|ordered-list-item|414226|使用您最喜欢的脚本语言来解析和解码spreadsheet;|414227|Look，当您打印出解码的数据时，脚本会生成该脚本。|414228|414229|perl脚本示例：|414230|#!perl

use+strict;

use+Spreadsheet::ParseExcel::Simple;
use+Encode+qw(+decode+);

my+$file++++=+"my_spreadsheet.xls";

my+$xls+++++=+Spreadsheet::ParseExcel::Simple->read(+$file+);
my+$sheet+++=+[+$xls->sheets+]->[0];

while+($sheet->has_data)+{

++++my+@data+=+$sheet->next_row;

++++for+my+$datum+(+@data+)+{
++++++++print+decode(+'cp1250',+$datum+);
++++}

}|code-block|syntax|javascript|414231|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|15|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|15|8|@]|9|@$D|16|E|17|1|18]]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1B|8|@]|9|@]|A|$]]|$1|L|3|M|5|K|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|K|7|1D|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|U|7|1G|8|@]|9|@]|A|$V|W]]|$1|X|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|C]]]]

cp1250 is used extensively in Microsoft Office documents, including Word and Excel 2003.

<a href="http://en.wikipedia.org/wiki/Windows-1250" rel="nofollow noreferrer">http://en.wikipedia.org/wiki/Windows-1250</a>

A simple way to confirm this would be to:

<ol>
<li>Create a spreadsheet with higher order characters, e.g. "Veszprém" in one of the cells;</li>
<li>Use your favourite scripting language to parse and decode the spreadsheet;</li>
<li>Look at what your script produces when you print out the decoded data.</li>
</ol>

Example perl script:

<pre><code>#!perl

use strict;

use Spreadsheet::ParseExcel::Simple;
use Encode qw( decode );

my $file = "my_spreadsheet.xls";

my $xls = Spreadsheet::ParseExcel::Simple-&gt;read( $file );
my $sheet = [ $xls-&gt;sheets ]-&gt;[0];

while ($sheet-&gt;has_data) {

 my @data = $sheet-&gt;next_row;

 for my $datum ( @data ) {
 print decode( 'cp1250', $datum );
 }

}
</code></pre>

blocks|key|416831|text|虽然将包含特殊字符的excel文件导出到csv文件确实很麻烦，但有一个简单的解决办法:只需将单元格复制/粘贴到google+docs中，然后从那里保存即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|416832|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

While it is true that exporting an excel file that contains special characters to csv can be a pain in the ass, there is however a simple work around: simply copy/paste the cells into a google docs and then save from there.

blocks|key|3468757|text|您可以使用下面的Visual+Studio+VB.Net代码来获取编码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3468758|Dim+strEncryptionType+As+String+=+String.Empty
Dim+myStreamRdr+As+System.IO.StreamReader+=+New+System.IO.StreamReader(myFileName,+True)
Dim+myString+As+String+=+myStreamRdr.ReadToEnd()
strEncryptionType+=+myStreamRdr.CurrentEncoding.EncodingName|code-block|syntax|javascript|3468759|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You could use this Visual Studio VB.Net code to get the encoding:

<pre><code>Dim strEncryptionType As String = String.Empty
Dim myStreamRdr As System.IO.StreamReader = New System.IO.StreamReader(myFileName, True)
Dim myString As String = myStreamRdr.ReadToEnd()
strEncryptionType = myStreamRdr.CurrentEncoding.EncodingName
</code></pre>

blocks|key|414428|text|您可以使用编码UTF8+%2Bhttps://en.wikipedia.org/wiki/Byte_order_mark+(https://en.wikipedia.org/wiki/Byte_order_mark)创建CSV文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|414429|前三个字节是物料清单(0xEF、0xBB、0xBF)，然后是UTF8内容。|414430|entityMap|0|LINK|mutability|MUTABLE|url|https://en.wikipedia.org/wiki/Byte_order_mark|1^0|D|19|0|1O|19|1|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@$A|P|B|Q|1|R]|$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|W|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|M]]]]

You can create CSV file using encoding UTF8 + BOM (<a href="https://en.wikipedia.org/wiki/Byte_order_mark" rel="nofollow noreferrer">https://en.wikipedia.org/wiki/Byte_order_mark</a>).
First three bytes are BOM (0xEF,0xBB,0xBF) and then UTF8 content.

blocks|key|416798|text|根据维基百科的说法，像那些来自Excel2007的OOXML文件是用UTF8编码的。我不知道CSV文件，但它会使用相同的格式…|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|416799|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Office_Open_XML^0|P|5|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://en.wikipedia.org/wiki/Office_Open_XML" rel="nofollow noreferrer">OOXML</a> files like those that come from Excel 2007 are encoded in UTF-8, according to wikipedia. I don't know about CSV files, but it stands to reason it would use the same format...

I have a Java app which reads CSV files which have been created in Excel (e.g. 2007). Does anyone know what charset MS Excel uses to save these files in?

I would have guessed either:

<ul>
<li>windows-1255 (Cp1255)</li>
<li>ISO-8859-1</li>
<li>UTF8</li>
</ul>

but I am unable to decode extended chars (e.g. french accentuated letters) using either of these charset types.

What charset does Microsoft Excel use when saving files?

Visual Studio

数据库

Windows

Java

我有一个Java应用程序，读取CSV文件已在Excel中创建(例如2007)。有人知道MS Excel使用什么字符集来保存这些文件吗？我也会猜到的：窗口-1255 (Cp1255)ISO-8859-1UTF8但我无法使用这两种字符集类型解码扩展字符(例如，法语重音字母)。

问Microsoft Excel在保存文件时使用什么字符集？
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Microsoft Excel在保存文件时使用什么字符集？EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Microsoft Excel在保存文件时使用什么字符集？
EN