How to Create a CSV File

CSV is a text file format used to store database entries. In CSV files, each line is a separate record. Each record consists of fields that are double quoted and separated with a comma. For example, a valid CVS record is "AB2L," "54.4," "60.0," "56." CSV files are convenient for transferring records between different databases. Microsoft Excel allows you to export data as a CVS file. It is also possible to create such a file manually using a text editor, though this method is only feasible for a relatively small amount of data.

With Microsoft Excel

Step

Log in to a user account in Windows Vista/XP and open Microsoft Excel.

Step

Press "Ctrl-O." Browse your computer to the folder with the Excel database file. Double-click on the file to open it.

Step

Click the menu "File" and "Save As." Select the file type as "CSV (comma delimited)" using the drop-down listbox, and click "Save."

With Notepad (Text Editor)

Step

Log in to a user account in Windows Vista/XP. Click "Start." If you are using Windows XP, click "Run."

Step

Type "Notepad" and press "Enter" to open the text editor.

Step

Type the record number in the first field and add double quotes. Then type a comma.

Step

Repeat Step 3 to add the rest of the fields in the record. Press "Enter" after the record is completed.

Step

Repeat Steps 3 and 4 for the rest of records.

Step

Press "Ctrl-S." Type a desired file name followed by the extension ".csv." Click "Save."