正确打开方式应该加上encoding='utf-8-sig'
encoding='utf-8-sig'
代码
import csv data = [['American','美国人'], ['Chinese','中国人']] with open('results.csv','w',newline='',encoding='utf-8-sig') as f: w = csv.writer(f) w.writerows(data)