How to create a csv file
Level of difficulty:
CSV stands for “comma separated values”. It is a kind of file that transfers simple data from one program to another program. Every value is separated in the file by using a comma. When there is a comma in between a value, that means the program is getting ready to accept a new value. Every line in a CSV file is a separate record and these records have fields, which are double quoted, with a comma separating them. CSV stores database entries as a text file format. The files from different databases are transferred from one file to another with a CSV file. A CSV file can be exported on Microsoft Excel and with the use of the text editor, you can create this file manually. If the data is small, then only this method will apply. Other programs will accept CSV files if you are keen on using a different data oriented program. If you want to save your data in CSV files, then there are few steps that you will need to follow.
- Specialized software
Go to File menu and choose Save As. If you are on Excel 2007, then click on the Office button and Save As, a dialog box will come up.
In the dialog box list right at the bottom where you have clicked Save As, choose CSV option.
There will be other controls visible in the dialog box which will specify a name and location, click on Save.
Not all Excel features can support the format, which you have chosen, so a dialog box in Excel may display a message telling you that. Then click on Yes so that the information will be saved in CSV format.
Now that you have saved your worksheet in CSV format, it is a good idea to close up the workbook, don’t save it. The original Excel workbook is in Excel format and the CSV file is saved in CSV format.