import  pandas as pd
import pymongo
client = pymongo.MongoClient(‘localhost‘,27017)
excel = client[‘CMC‘]
sheet1 = excel[‘CMC1‘]
import json

data = http://www.mamicode.com/pd.DataFrame(list(sheet1.find())[:])
del data[‘-id‘]
data.to_excel(io)

mongo 通过pandas 导出csv 不会有乱码