How to create csv file in python

CSV stands for Comma Separated Values where the data lives in a simple text file that is split up by commas. You’ll know you’re dealing with CSV files if the file extension is .csv like myData.csv (this also depends on if you have your OS settings so that you can see what the file type is) or if you open the file in a text editor and notice that the data is separated by a comma.

If you use Excel long enough, working with CSV files is inevitable.

Here’s a simple example of what a CSV file looks like if you open it with a text editor (preferably Sublime Text, the best text editor ever).

When you open this file in Excel, the data gets transferred to the cells and it is split by the comma, which would look something like this:

This is the basic gist of CSV files, but there’s more to it than this, which we’ll cover shortly.

Working with CSV Files

Working with CSV files is pretty straightforward.

However, depending on your workflow, there might be some caveats that you may want to watch out for.

Openi

how to save csv file in excel

how to format csv file in excel