How to Convert a Python List into an Excel Column: Two Simple Methods

Introduction

Hello, I am a Python enthusiast. Recently a follower asked how to convert a Python list containing many elements into the first column of an Excel spreadsheet. Below is a detailed answer for everyone to learn together.

Solution Process

Two experts provided answers, offering two different methods.

dcpeng's Answer

Method 1 – using openpyxl:

import openpyxl

excel_file = openpyxl.Workbook()
worksheet = excel_file.active
list1 = ['麦当', 'dcpeng', '月神', '王子', '冯诚', '亮哥', '沈复']
for i in range(len(list1)):
    worksheet.cell(i+1, 1, list1[i])
excel_file.save('result.xlsx')

Method 2 – using pandas for higher efficiency:

import pandas as pd
list1 = ['麦当', 'dcpeng', '月神', '王子', '冯诚', '亮哥']
df = pd.DataFrame(list1)
df.to_excel('666.xlsx')

瑜亮's Answer

Additional pandas operations, including printing, transposing, and column manipulation:

import pandas as pd

lst = list(range(10))
print(lst)
df = pd.DataFrame(lst)
print(df)
# df.to_excel('list.xlsx')  # save as column

df2 = df.T
print(df2)
# df2.to_excel('list2.xlsx')  # save as row

new1 = [9,8,7,6,5,4,3,2,1,0]
new2 = [1,1,1,1,1,2,2,2,2,2]
new3 = [3,3,3,3,3,4,4,4,4,4]
df[0] = new1
df["新"] = new2
col_names = df.columns.tolist()
col_names.insert(0, '新列1')
df3 = df.reindex(columns=col_names, fill_value=0)
print(df3)

df3.insert(0, '新列2', new3)
print(df3)

Conclusion

This article, based on a follower's question, demonstrates two concrete ways to convert a Python list into the first column of an Excel file, helping readers solve the problem efficiently. Readers are encouraged to share any additional methods they discover.