If you then save the file as “.CSV” then it will open in Excel when you click on it! ... For example, if you want to write a .Doc file in Python, you’ll come unstuck!

This post will show you how to open CSV files in Python using the CSV module. ... You can do this in Excel by creating a simple spreadsheet and then choosing to save it as a CSV file.

When run it produces: $ python csv1.py A : 1 B : 2 C D : 3 4 A : 5 B : 6 C D : 7 In addition, the csv module provides writer objects for writing CSV files. The following Python program converts our ...