How to Write Multiple Rows in CSV using Python?

By Hardik Savani October 30, 2023 Category : Python


Hello, all! In this article, we will talk about how to write multiple rows in csv using python. you will learn python csv files multiple rows example. In this article, we will implement a python write multiple rows to csv file. In this article, we will implement a write multiple lines to csv file python. Follow the below tutorial step of python list to csv rows.

In this example, we will create demo.csv file with ID, Name and Email fields. we will create "data" list with values for write multiple rows to csv file. we will use open(), writer(), writerow(), writerows() and close() functions to create csv file from list.

writerows(): it will write multiple rows with list.

So, Without any further ado, let's see below code example:

You can use these examples with python3 (Python 3) version.


import csv
# open the file in the write mode
f = open('demo.csv', 'w')
# create the csv writer
writer = csv.writer(f)
header = ['ID', 'Name', 'Email']
data = [
	[1, 'Hardik Savani', ''],
	[2, 'Vimal Kashiyani', ''],
	[3, 'Harshad Pathak', ''],
# write the header
# write a row to the csv file
# close the file


You can see csv file layout:

I hope it can help you...

Tags :