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.

Things You'll Need

• Microsoft Office

Instructions

With Microsoft Excel

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

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

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)

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

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

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

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

5. Repeat Steps 3 and 4 for the rest of records.

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

References

• File Extension CSV Details