import os import sys from openpyxl import Workbook def main(): wb = Workbook() ws1 = wb.active ws1.title = "1st Hour" ws1['A1'] = 'worry' ws1['B1'] = 'worry' ws1['C1'] = 'worry' ws1.insert_cols( 2 ) data1 = ['a','b', 'c', 'd', 'e'] max = ws1.max_row for row, entry in enumerate(data1, start=0): ws1.cell(row=row+max, column=2, value=entry) wb.save('FileName.xlsx') main()