I needed to automate this process on my Mac. I originally tried using catdoc/xls2csv as suggested by mpowered, but xls2csv had trouble detecting the original encoding of the document and not all documents were the same. What I ended up doing was setting the default webpage output encoding to be UTF-8 and then providing the files to Apple's Automator, applying the Convert Format of Excel Files action to convert to Web Page (HTML). Then using PHP, DOMDocument and XPath, I queried the documents and formatted them to CSV.

这是PHP脚本(process.php):

<?php
$pi = pathinfo($argv[1]);
$file = $pi['dirname'] . '/' . $pi['filename'] . '.csv';
$fp = fopen($file,'w+');
$doc = new DOMDocument;
$doc->loadHTMLFile($argv[1]);
$xpath = new DOMXPath($doc);
$table = [];
foreach($xpath->query('//tr') as $row){
    $_r = [];
    foreach($xpath->query('td',$row) as $col){
        $_r[] = trim($col->textContent);
    }
    fputcsv($fp,$_r);
}
fclose($fp);
?>

这是我用来将HTML文档转换为csv的shell命令:

find . -name '*.htm' | xargs -I{} php ./process.php {}

这是一种非常非常迂回的方法，但这是我发现的最可靠的方法。

“nevets1219”的第二个选项是在notepad++中打开CSV文件并将其转换为ANSI。

在顶部菜单中选择: Encoding ->转换为Ansi

Encoding -> Convert to Ansi将其编码为Ansi /UNICODE。Utf8是Unicode的一个子集。也许在ANSI中会正确编码，但在这里我们谈论的是UTF8， @SequenceDigitale。

还有更快的方法，比如导出为csv(逗号分隔)，然后用notepad++(免费)打开csv，然后Encoding > Convert to UTF8。但前提是每个文件必须执行一次。如果你需要经常更改和导出，那么最好是LibreOffice或GDocs解决方案。

简单的方法: 不需要Open office和谷歌文档

Save your file as "Unicode text file"; now you have an unicode text file open it with "notepad" and "Save as" it with selecting "utf-8" or other code page that you want rename file extension from "txt" to "csv". This will result in a tab-delimited UTF-8 csv file. If you want a comma-delimited file, open the csv file you just renamed and replace all tabs with commas. To do this in Notepad on Win 10, simply select one tab field then click Ctrl+H. In the window that opens, type a comma , in the "Replace with" field then click "Replace All". Save your file. The result will be a comma-delimited UTF-8 csv file.

不管怎样，不要用ms office打开它!! 现在您有了一个以制表符分隔的CSV文件。 或者，如果应用步骤5，则使用逗号分隔。

(在Mac上:)从Excel保存为CSV文件。在TextWrangler中打开CSV文件(它是免费的)，并使用“另存为”。在保存对话框中选择Unicode (UTF-8)。完成

(我猜你也可以用TextEdit做到这一点-如果你玩打开和保存设置。尝试打开文件:自动，保存文件:UTF-8)

您可以将excel保存为unicode文本，它是制表符分隔的。