How to Create CSV File in Python?

Hi Artisan,

This detailed guide will cover how to create csv file in python. I am going to show you about python create csv file example. I would like to share with you python writing csv file example. This article will give you a simple example of python output to csv file example. Alright, let us dive into the details.

In this example, we will create demo.csv file with ID, Name and Email fields. we will use open(), writer(), writerow(), writerows() and close() functions to create csv file. we will use functions for the following reasons.

open(): it will create csv file if not exist.

writer(): it will create csv file object for write new rows.

writerow(): it will write single row with heading.

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

close(): it will close created new csv file object.

Now, you can see below simple code and output:

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

Example:

main.py

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', 'hardik@gmail.com'],
	[2, 'Vimal Kashiyani', 'vimal@gmail.com'],
	[3, 'Harshad Pathak', 'harshad@gmail.com'],
]
  
# write the header
writer.writerow(header)
  
# write a row to the csv file
writer.writerows(data)
  
# close the file
f.close()

Output:

You can see csv file layout:

I hope it can help you...