Insert Rows & Columns into Excel in Python
from ironxl import *

# Load existing spreadsheet
workbook = WorkBook.Load("sample.xlsx")
worksheet = workbook.DefaultWorkSheet

# Add a row before row 1
worksheet.InsertRow(0)

# Insert multiple rows before row 4
worksheet.InsertRows(3, 3)

# Add a column before column A
worksheet.InsertColumn(0)

# Insert multiple columns before column F
worksheet.InsertColumns(5, 2)

# Save changes with added rows and columns
workbook.SaveAs("addRowAndColumn.xlsx")
pip install ironxl
Insert Rows & Columns into Excel in Python

Insert Rows & Columns into Excel in Python

IronXL for Python provides the ability to insert individual or multiple rows and columns programmatically, without requiring Office Interop.

Insert Row

The InsertRow and InsertRows methods add new rows to the worksheet. Rows are inserted before the specified index position.

Insert Column

Use the InsertColumn and InsertColumns methods to add one or more columns before the specified index position.

All index positions use zero-based indexing.

Learn How to Add Rows and Columns in Excel with Python

Ready to Get Started?

Version:2026.11just released

Free pip Download