from openpyxl import load_workbook key_data = [] workbook = load_workbook('wallet.xlsx') sheet = workbook.active for row in sheet.iter_rows(values_only=True, min_row=2): print(row[0], row[1]) key_data.append(row) with open('key.txt', 'w') as f: for i, key in enumerate(key_data): if i == len(key_data) - 1: f.write(f'{key[1]}') else: f.write(f'{key[1]}\n')