最近一段時(shí)間的學(xué)習(xí)中發(fā)現(xiàn)，Python基本和中文字符杠上了。如果能把各種編碼問(wèn)題解決了，基本上也算對(duì)Python比較熟悉了。

For UTF-8 encoding, Excel requires BOM (byte order mark) codepoint written at the start of the file or it will assume ANSI encoding, which is locale-dependent.
對(duì)于UTF-8編碼，Excel要求BOM(字節(jié)順序標(biāo)記)寫(xiě)在文件的開(kāi)始，否則它會(huì)假設(shè)這是ANSI編碼，這個(gè)就是與locale有依賴(lài)性了。

#!python2
#coding:utf8
import csv

data = [[u'American',u'美國(guó)人'],
        [u'Chinese',u'中國(guó)人']]

with open('results.csv','wb') as f:
    f.write(u'\ufeff'.encode('utf8'))
    w = csv.writer(f)
    for row in data:
        w.writerow([item.encode('utf8') for item in row])

考慮到兼容性，Python3的處理方法就比較簡(jiǎn)單了。

#!python3
#coding:utf8
import csv

data = [[u'American',u'美國(guó)人'],
        [u'Chinese',u'中國(guó)人']]

with open('results.csv','w',newline='',encoding='utf-8-sig') as f:
    w = csv.writer(f)
    w.writerows(data)

或者你可以使用個(gè)第三方模塊unicodecsv

#!python2
#coding:utf8
import unicodecsv

data = [[u'American',u'美國(guó)人'],
        [u'Chinese',u'中國(guó)人']]

with open('results.csv','wb') as f:
    w = unicodecsv.writer(f,encoding='utf-8-sig')
    w.writerows(data)

筆者在Python2.7下親測(cè)可用，這樣在以后爬取中文網(wǎng)站到CSV，比如豆瓣或者鏈家的數(shù)據(jù)，就可以很方便的寫(xiě)入Excel或CSV文件了。