A CSV file allows you to save your tabular data as comma separated values, which is convenient when you need to manage a large database. CSV files can be generated by programs such as Notepad, Google Spreadsheets, OpenOffice Calc, and Microsoft Excel.
Steps
Method 1 of 2: Use Google Spreadsheets, OpenOffice Calc, and Microsoft Excel
Step 1. Open a new workbook
To get started, open a new spreadsheet in Google Spreadsheets, OpenOffice Calc, or Microsoft Excel.
If you feel like converting old spreadsheet to CSV, skip to step four
Step 2. Complete the sheet
Try typing your titles in each of the cells in the first row at the top of the worksheet. If for example you want to enter the data of the items you are selling, write Product Name in cell A1, Product price in cell B1, Product Description in cell C1 and so on.
Step 3. Enter your data in each column as needed
Using the example in step two, write the product name in cell A2, its price in cell B2, and its description in cell C2.
Step 4. Click File and select Save As
Do this after entering all the data in the sheet. If you are using Google Spreadsheets, this option will look like this File> Download as.
Step 5. Select CSV from the Type drop-down menu
Step 6. Rename your CSV file, then click Save
You have just created a CSV file and the commas will be automatically added to the document to delimit each region.
Method 2 of 2: Use Notepad
Step 1. Open Notepad
Then type the names and separate them with commas on the first line. If for example you are entering data for the items you are selling, type these details on the first line: name, price, description. There should not be spaces between the entries.
Step 2. Enter data on the second line
Use the same format as the names you wrote on the first line. Using the example outlined in step one, write the actual name of the product, followed by its price and description. If you sell soccer balls, for example, write soccer 6 sport.
Step 3. Continue to enter your data
Make sure you type the details of each item on a new line. If you leave fields empty, be sure to include a comma otherwise the other fields will shift by one line.
Step 4. Click File, then Save As
Step 5. Rename the file
Type a name for the file followed by the extension .csv.
Step 6. Click Save
You have just created a CSV file with Notepad.
