for sheet in workbook.sheets():
    with open('{}.csv'.format(sheet.name), 'wb') as f:
        writer = csv.writer(f)
writer.writerows(sheet.row_values(row) for row in range(sheet.nrows))
How to extract sheet from *.xlsm and save it as *.csv in Python?