How to Create a CSV File

Step-by-Step Guide

1. 1

   Step 1: Open a new spreadsheet in Microsoft Excel

   If you want to convert an existing spreadsheet to CSV format, skip to step #4.
2. 2

   Step 2: OpenOffice Calc

   For example, if entering data for items you’re selling, type “Item Name” into cell A1, “Item Price” into cell B1, “Item Description” into cell C1, and so on., Using the example outlined in step #2, write the item name in cell A2, the item’s price in cell B2, and the item’s description in cell C2. , If using Google Spreadsheets, this option will read as “File > Download as.”,,
3. 3

   Step 3: or Google Spreadsheets.

4. 4

   Step 4: Type each of your headers

5. 5

   Step 5: or field names into the cells located in row 1 at the top of the spreadsheet.

6. 6

   Step 6: Enter your data into the spreadsheet under each column as needed.

7. 7

   Step 7: Click on “File” and select “Save As” after you’ve entered all data into the spreadsheet.

8. 8

   Step 8: Select “CSV” under the “Save as type” dropdown menu.

9. 9

   Step 9: Type a name for your CSV file

10. 10

    Step 10: then select “Save.” You have now created a CSV file

11. 11

    Step 11: and commas will automatically be added to the file to separate each field.

Detailed Guide

About the Author