Saturday, June 09, 2012

How to create a CSV(Comma Seperated Value) file?



Friends, comma-separated values (CSV) file is any file containing text that is separated with a comma, but can also be a file separated with any other character. To create a CSV is as simple as creating any text file and can be created in any text editor, however, is often created in a spreadsheet program such as Microsoft Excel. Below are the steps on how to create a CSV file using a text editor such as Notepad.



To create a CSV file in a text editor open a new text editor program, such as Notepad. Once open write the text you wish the file to contain and separate each field or column of data with a comma and each row with a new line.



Title4,Title5,Title6
one,two,three
example1,example2,example3




As an example, if you were to create a text file with the above data, and save it as a CSV file, each column is created by each comma and each row is created by each new line. Therefore, the above data if opened in a spreadsheet program such as Microsoft Excel would create a table similar to the below example.



Title4Title5Title6
onetwothree
example1example2example3



                   Thanks Friends........

1 comment:

Please Give Me Your Views

Popular Posts