How to write a string to a column in csv file using Python

Question

I'm trying to write into a string to csv file using csv modules. The string is getting printed in the excel sheet as single characters in different rows and not in one field.

with open('test.csv', 'w',newline='') as f:
    writer=csv.writer(f)
    writer.writerow("hello")
    writer.writerow("bye")

The output is like

 h     e     l      l     o         
 b     y     e

What I simply want is

hello

bye

Also how do I write in a different column? there is no writecolumn() for it like writerow()

it treats the argument passed to it as an iterable so wrap your words in brackets to signify you want it as one column — gold_cy
– gold_cy, Commented Jun 12, 2019 at 11:23
writerow takes a sequence of elements, each written in its own column. — Michael Butscher
– Michael Butscher, Commented Jun 12, 2019 at 11:23
OK now I understand. I made a list of the strings and now they are properly displayed and also thanks for the column idea. — HAH
– HAH, Commented Jun 12, 2019 at 11:32

DEEPAK S.V. · Accepted Answer · 2021-12-07 14:26:59Z

2

Adding to the previous answer,

If you want to do the same with csv.writerows() function:

rows = ["apple", "banana", "mango", "orange"]

with open('test.csv', 'w',newline='') as f:
    writer=csv.writer(f)
    writer.writerows([[row] for row in rows])

That should print all the rows, in 1 column per row.

answered Dec 7, 2021 at 14:26

DEEPAK S.V.

14511 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

decuser · Accepted Answer · 2021-06-23 15:38:33Z

1

In order to output in two rows:

writer.writerow(["hello"])
writer.writerow(["bye"])

In order to output in two cols:

 writer.writerow(["hello","bye"])

answered Jun 23, 2021 at 15:38

decuser

2626 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to write a string to a column in csv file using Python

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related