How to create a csv fileLevel of difficulty: Easy
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.
Windows system maintenance:
You are currently viewing How to create a csv file on Uniblue's how to archive.
Browse more how to's
- How to create a csv file
- How to create a desktop icon
- How to create a favicon
- How to create a personal website
- How to create a program
- How to create a proxy server
- How to create a pst file
- How to create a virtual drive
- How to create a web page using html
- How to create a website in dreamweaver
- How to create a zip file
- How to create an xml file
- How to create batch file
- How to create flash website
- How to create htaccess file
- How to create html email
- How to create icons
- How to create macro in excel
- How to create macros
- How to create pdf files