(CRLF), double quotes, and commas should be enclosed in double-quotes. For example: Red, “,”, Blue CRLF # comma itself is a field value.so it is enclosed with double quotes Red, Blue , Green . If double-quotes are used to enclose fields, then a double-quote appearing inside a field must be preceded with another double quote. For example: ““Red””, ““Blue””, ““Green”” CRLF # since double quotes is a field value it is enclosed with another double quotes , , White The last row in the above example (, , White ) begins with two commas because the first two fields of that row were empty in our spreadsheet.
Don't delete them — the two commas are required so that the fields correspond from row to row. They cannot be omitted. Note Create A CSV File Using Microsoft Excel . To create a CSV file using Microsoft Excel, launch Excel and then open the file you want to save in CSV format.
For example, below is the data contained in our sample Excel worksheet: 12th Computer Chapter - - Python and CSV Files Item Name Keyboard 10400 13552 Total Profit Cost - Rs Quantity Profit Fig . Sample Worksheet Data Once the data is entered in the worksheet, select File → Save As option, and for the “Save as type option”, select CSV (Comma delimited) or type the file name along with extension .csv. Saving excel file as CSV Fig . Save As dialog box After you save the file, you are free to open it up in a text editor to view it or to edit it manually.
Its contents will resemble the following: Monitor Mouse 12th Computer Chapter - - Item Name, Cost-Rs, Quantity, Profit Keyboard, , , Monitor, , , 10400 Mouse, , , ,,Total Profit =,13552 . . Microsoft Excel to open a CSV file If Microsoft Excel has been installed on the computer, by default CSV files should open automatically in Excel when the file is double-clicked. If you are