How to Create a CSV File
A CSV file, which is a 'comma separated values' file, allows you to save your data in a table-structured format, which is useful when you need to manage a large database. CSV files can be created using Microsoft Excel, OpenOffice Calc,...
Method 1 of 2:
Microsoft Excel, OpenOffice Calc, and Google Spreadsheets
-
How to Create a CSV File Picture 1
Open a new spreadsheet in Microsoft Excel, OpenOffice Calc, or Google Spreadsheets.- If you want to convert an existing spreadsheet to CSV format, skip to step #4.
-
How to Create a CSV File Picture 2
Type each of your headers, or field names into the cells located in row 1 at the top of the spreadsheet. 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.[1] -
How to Create a CSV File Picture 3
Enter your data into the spreadsheet under each column as needed. 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. -
How to Create a CSV File Picture 4
Click on 'File' and select 'Save As' after you've entered all data into the spreadsheet. If using Google Spreadsheets, this option will read as 'File > Download as.'[2] -
How to Create a CSV File Picture 5
Select 'CSV' under the 'Save as type' dropdown menu. -
How to Create a CSV File Picture 6
Type a name for your CSV file, then select 'Save.' You have now created a CSV file, and commas will automatically be added to the file to separate each field.[3]
Method 2 of 2:
Notepad
-
How to Create a CSV File Picture 7
Launch Notepad and type your field names separated by commas onto the first line. For example, if entering data for items you're selling, type the following onto the first line: 'name,price,description.' There must be no spaces between items. -
How to Create a CSV File Picture 8
Type your data onto the second line, using the same format as your field names on the first line. Using the example outlined in step #1, write the actual item name, followed by the item's price and description. For example, if selling baseballs, write 'baseball,5.99,sports.' -
How to Create a CSV File Picture 9
Continue typing your data for each individual item onto each subsequent line. If leaving any fields empty, make sure you include the comma, or the remaining fields will be off by one. -
How to Create a CSV File Picture 10
Click on 'File' and select 'Save.' -
How to Create a CSV File Picture 11
Type a name for your file and select '.csv' from the file extension dropdown menu. -
How to Create a CSV File Picture 12
Click on 'Save.' You have now created a CSV file in Notepad.[4]
4 ★ | 25 Vote
You should read it
- How to delete items from the New Item menu in File Explorer
- Work with the library item in Adobe Dreamweaver CS6
- How to create a filter in an Excel cell
- Open the file, open the folder with a mouse click
- How to add items to the 'Create New' context menu in Windows 10
- How to Open a PayPal Dispute
- What is a .DAT file and how to open a .DAT file?
- Stem cell therapy can help reverse diabetes
- Fix 'Could Not Find This Item…' error in Windows 10
- How to Make a New File in Windows
- How to Subtract in Excel
- CELL function to look up information of a cell in Excel