PYTHON AND CSV FILES 12th Computer Chapter - - Python and CSV Files Files saved in excel cannot be opened or edited by text editors. Purpose Of CSV File . CSV is a simple file format used to store tabular data, such as a spreadsheet or database. Since they're plain text, they're easier to import into a spreadsheet or another storage database, regardless of the specific software you're using.
You can open CSV files in a spreadsheet program like Microsoft Excel or in a text editor or through a database which make them easier to read. CSV File cannot store charts or graphs. It stores data but does not contain formatting, formulas, macros, etc. Note A CSV file is also known as a Flat File.
Files in the CSV format can be imported to and exported from programs that store data in tables, such as Microsoft Excel or OpenOfficeCalc Creating a CSV file using Notepad (or any text editor) . A CSV file is a text file, so it can be created and edited using any text editor, But more frequently a CSV file is created by exporting a spreadsheet or database in the program that created it. . .
Creating CSV Normal File To create a CSV file in Notepad, First open a new file using File → New or ctrl +N. Then enter the data you want the file to contain, separating each value with a comma and each row with a new line. For example consider the following details Topic1,Topic2,Topic3 one,two,three Example1,Example2,Example3 Save this content in a file with the extension .csv . You can then open the same using Microsoft Excel or any other spreadsheet program.
Here we have opened using Microsoft Excel. It would create a table of data similar to the following: 12th Computer Chapter - - Topic1 one Example1 Example2 Example3 two three Topic3 Topic2 Fig. . .
CSV file when opened in MS-Excel In the above CSV file, you can observe the fields of data were separated by commas. But what happens if the data itself