Comma Separated Values (CSV) files a type of a plain text document in which tabular information is structured using a particular format. A CSV file is a bounded text format which uses a comma to separate values. The most common method to write data from a list to CSV file is the writerow() method of writer and DictWriter class. Example 1: Creating a CSV file and writing data row-wise into it using writer class.
Python3
import csv
data = [[ 'Geeks' ], [ 4 ], [ 'geeks !' ]]
file = open ( 'g4g.csv' , 'w+' , newline = '')
with file :
write = csv.writer( file )
write.writerows(data)
|
Output:
Example 2: Writing data row-wise into an existing CSV file using DictWriter class.
Python3
import csv
file = open ( 'g4g.csv' , 'w' , newline = '')
with file :
header = [ 'Organization' , 'Established' , 'CEO' ]
writer = csv.DictWriter( file , fieldnames = header)
writer.writeheader()
writer.writerow({ 'Organization' : 'Google' ,
'Established' : '1998' ,
'CEO' : 'Sundar Pichai' })
writer.writerow({ 'Organization' : 'Microsoft' ,
'Established' : '1975' ,
'CEO' : 'Satya Nadella' })
writer.writerow({ 'Organization' : 'Nokia' ,
'Established' : '1865' ,
'CEO' : 'Rajeev Suri' })
|
Output:
Example 3: Appending data row-wise into an existing CSV file using writer class.
Python3
import csv
data = [[ 'Geeks for Geeks' , '2008' , 'Sandeep Jain' ],
[ 'HackerRank' , '2009' , 'Vivek Ravisankar' ]]
file = open ( 'g4g.csv' , 'a+' , newline = '')
with file :
write = csv.writer( file )
write.writerows(data)
|
Output: 
Whether you're preparing for your first job interview or aiming to upskill in this ever-evolving tech landscape,
GeeksforGeeks Courses are your key to success. We provide top-quality content at affordable prices, all geared towards accelerating your growth in a time-bound manner. Join the millions we've already empowered, and we're here to do the same for you. Don't miss out -
check it out now!