mhysnm1...@gmail.com wrote: > Now I am > trying to export to a CSV file. There is no syntax or logical errors I can > see. The information is being exported to the CSV. But when I bring it > into Excel. I am getting a blank row between each row.
> with open ('books-list.csv', 'w') as wf: Try switching off newline conversion: with open('books-list.csv', 'w', newline="") as wf: ... The csv.writer() delimits records with "\r\n", and on Windows open() converts "\n" to "\r\n" by default. Therefore you probably (no Window handy to to confirm) end up with "\r\r\n" between the rows. See also <https://docs.python.org/dev/library/csv.html#id3>. > writer = csv.writer(wf) > writer.writerows(books) At this point the file is already closed by the context manager, no need for an extra > wf.close() _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: https://mail.python.org/mailman/listinfo/tutor