20 Contributors: 2 Tuesday, July 25, 2017
Licensed under: CC-BY-SA
Not affiliated with Stack Overflow
Rip Tutorial:
Roadmap: roadmap

Writing to CSV from String or List


Writing to a .csv file is not unlike writing to a regular file in most regards, and is fairly straightforward. I will, to the best of my ability, cover the easiest, and most efficient approach to the problem.


open ("/path/", "mode")Specify the path to your CSV file
open (path, "mode")Specify mode to open file in (read, write, etc.)
csv.writer(file, delimiter)Pass opened CSV file here
csv.writer(file, delimiter=' ')Specify delimiter character or pattern


open( path, "wb")

"wb" - Write mode.

The b parameter in "wb" we have used, is necessary only if you want to open it in binary mode, which is needed only in some operating systems like Windows.

csv.writer ( csv_file, delimiter=',' )

Here the delimiter we have used, is ,, because we want each cell of data in a row, to contain the first name, last name, and age respectively. Since our list is split along the , too, it proves rather convenient for us.

Related Examples