下面是我们在生成csv文件时使用的简单方法，它确实会稍微改变值，所以并不适用于所有应用程序:

在csv中的所有值前加一个空格

excel将从诸如“1”、“2.3”和“-2.9e4”等数字中剥离该空格，但将保留诸如“01/10/1993”这样的日期和诸如“TRUE”这样的布尔值，从而阻止它们转换为excel的内部数据类型。

它也停止双引号被zapped在读进去，所以一个简单的方法，使文本在csv中保持不变的excel即使是一些文本，如“3.1415”是用双引号包围它，并在整个字符串前加上一个空格，即(使用单引号来显示你会键入什么)“3.1415”。然后在excel中，你总是有原始的字符串，除了它被双引号包围并以空格开头，所以你需要在任何公式中考虑这些。

None of the solutions offered here is a good solution. It may work for individual cases, but only if you're in control of the final display. Take my example: my work produces list of products they sell to retail. This is in CSV format and contain part-codes, some of them start with zero's, set by manufacturers (not under our control). Take away the leading zeroes and you may actually match another product. Retail customers want the list in CSV format because of back-end processing programs, that are also out of our control and different per customer, so we cannot change the format of the CSV files. No prefixed'=', nor added tabs. The data in the raw CSV files is correct; it's when customers open those files in Excel the problems start. And many customers are not really computer savvy. They can just about open and save an email attachment. We are thinking of providing the data in two slightly different formats: one as Excel Friendly (using the options suggested above by adding a TAB, the other one as the 'master'. But this may be wishful thinking as some customers will not understand why we need to do this. Meanwhile we continue to keep explaining why they sometimes see 'wrong' data in their spreadsheets. Until Microsoft makes a proper change I see no proper resolution to this, as long as one has no control over how end-users use the files.

根据Jarod的解决方案和Jeffiekins提出的问题，你可以进行修改

"May 16, 2011"

to

"=""May 16, 2011"""

警告:Excel '07(至少)有一个(另一个)错误:如果字段的内容中有逗号，它不会正确解析="field, contents"，而是将逗号后的所有内容放入下面的字段中，而不管引号是什么。

我发现唯一有效的解决方法是当字段内容包含逗号时消除=。

这可能意味着有些字段不可能在Excel中完全“正确”地表示，但到目前为止，我相信没有人会感到太惊讶。

在双引号中添加空格前缀解决了这个问题!!

我在csv文件的一个列中有“7/8”这样的数据，MS-Excel将其转换为“07-Aug”。但是使用“LibreOffice Calc”就没有问题了。

为了解决这个问题，我只是给空格字符加上前缀(在7之前添加空格)，比如“7/8”，这对我来说很有效。这是为Excel-2007测试的。

CSV -用逗号分隔的值。只需通过文本编辑器创建/编辑，而不是xls/xlsx/exel。 在编辑时，您可以设置所需的格式的日期，它必须保持完整。 这是假设同样的文件将被以编程方式处理。