How to Create a CSV File

By Oxana Fox

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.

Things You'll Need

  • Microsoft Office

With Microsoft Excel

Step 1

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

Step 2

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

Step 3

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 1

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

Step 2

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

Step 3

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

Step 4

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

Step 5

Repeat Steps 3 and 4 for the rest of records.

Step 6

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

References & Resources