EASY solution for Mac Excel 2008: I struggled with this soo many times, but here was my easy fix: Open the .csv file in Textwrangler which should open your UTF-8 chars correctly. Now in the bottom status bar change the file format from "Unicode (UTF-8)" to "Western (ISO Latin 1)" and save the file. Now go to your Mac Excel 2008 and select File > Import > Select csv > Find your file > in File origin select "Windows (ANSI)" and voila the UTF-8 chars are showing correctly. At least it does for me...

我也有同样(或类似)的问题。

在我的情况下，如果我添加一个BOM输出，它工作:

header('Content-Encoding: UTF-8');
header('Content-type: text/csv; charset=UTF-8');
header('Content-Disposition: attachment; filename=Customers_Export.csv');
echo "\xEF\xBB\xBF"; // UTF-8 BOM

我相信这是一个非常丑陋的黑客，但它对我有效，至少对Excel 2007 Windows有效。不确定在Mac上能不能用。

当你把它保存为txt文件，他们用逗号作为分隔符在excel中打开它时，问题还会发生吗?

问题可能根本不是编码，可能只是文件不是一个完美的CSV根据excel标准。

下面是我怎么做的(这是提示浏览器下载csv文件):

header('Content-Description: File Transfer');
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename=file.csv');
header('Content-Transfer-Encoding: binary');
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
echo "\xEF\xBB\xBF"; // UTF-8 BOM
echo $csv_file_content;
exit();

唯一的一件事，它修复了UTF8编码问题在CSV预览当你在Mac上按空格键。但不是在Excel Mac 2008…不知道为什么

因为UTF8编码不适合Excel。可以使用iconv()将数据转换为另一种编码类型。

e.g.

iconv('UTF-8', 'ISO-8859-1//TRANSLIT', $value),

在我的情况下，以下工作非常好，使UTF-8字符的CSV文件在Excel中正确显示。

$out = fopen('php://output', 'w');
fprintf($out, chr(0xEF).chr(0xBB).chr(0xBF));
fputcsv($out, $some_csv_strings);

0xEF 0xBB 0xBF BOM头将让Excel知道正确的编码。