import xlrd
from xlrd import open_workbook
book = open_workbook('random.xls')
sheet1 = book.sheet_by_index(0)
data = []
for i in range(sheet1.nrows):
    data.append(sheet1.cell(i, 1).value)
Экспорт списка Python в Excel