{"id":10,"date":"2026-01-22T18:25:59","date_gmt":"2026-01-22T10:25:59","guid":{"rendered":"https:\/\/openpyxl.com\/blog\/?p=10"},"modified":"2026-01-16T05:54:20","modified_gmt":"2026-01-16T05:54:20","slug":"how-to-add-rows-in-a-worksheet-using-openpyxl","status":"publish","type":"post","link":"https:\/\/openpyxl.com\/blog\/how-to-add-rows-in-a-worksheet-using-openpyxl.html","title":{"rendered":"How To Add Rows In a Worksheet Using OpenPyXL?"},"content":{"rendered":"
Method<\/h2>\n
To add a new row of data at the bottom of the current worksheet, use the `append` method:<\/p>\n
ws.append(iterable)<\/p>\n
Where `iterable` is a list, tuple, dictionary, range, or generator. For a list, the elements are added to the row\u2019s cells in order. If it\u2019s a dictionary, the corresponding keys will add their values.<\/p>\n
Sample Code<\/h2>\n\n\n
#Adding Rows\n\n#Import load_workbook function\nfrom openpyxl import Workbook\n\n#Create a new workbook\nwb=Workbook()\n#Get the active worksheet\nws=wb.active\n\n#Add two rows of list data\nws.append([10, 8, 21])\nws.append(['John', 39, 65])\n\n#Add two rows of dictionary data\nws.append({'A':'Jane', 'B':90, 'C':87})\nws.append({1:'Smith', 2:83, 3:79})\n\n#Use a for loop to continuously add row data\nfor row in range(1, 10):\n ws.append(range(10,20))\n\nwb.save('test.xlsx')\nwb.close()<\/code><\/pre>\n\n\n\n<\/figure>\n","protected":false},"excerpt":{"rendered":"
![\"Add](\"https:\/\/openpyxl.com\/blog\/wp-content\/uploads\/2026\/01\/4.png\")
<\/figure>\n","protected":false},"excerpt":{"rendered":"