You are viewing the article How to Create a CSV File at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, volunteer authors have edited and improved the article over time.
This article has been viewed 1,694 times.
The CSV (“comma-separated value”) format allows users to save data as a table. This format is very useful in case you need to manage large databases. CSV files can be created with Microsoft Excel, OpenOffice Calc, Google Sheets (or Google Sheets), and Notepad.
Steps
On Microsoft Excel, OpenOffice Calc and Google Sheets
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/81/Create-a-CSV-File-Step-1.jpg/v4-728px-Create-a-CSV-File- Step-1.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/81/Create-a-CSV-File-Step-1.jpg/v4-728px-Create- a-CSV-File-Step-1.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Open a new spreadsheet in Microsoft Excel, OpenOffice Calc, or Google Sheets.
- If you want to convert the existing spreadsheet to CSV format, continue to step #4.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c0/Create-a-CSV-File-Step-2.jpg/v4-728px-Create-a-CSV-File- Step-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c0/Create-a-CSV-File-Step-2.jpg/v4-728px-Create- a-CSV-File-Step-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Type each title or field name in the cells in row 1 at the top of the spreadsheet. For example, for the items you are selling, enter “Item Name” in cell A1, “Item Price” in cell B1, “Item Description” in cell C1, and so on. [1] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ea/Create-a-CSV-File-Step-3.jpg/v4-728px-Create-a-CSV-File- Step-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ea/Create-a-CSV-File-Step-3.jpg/v4-728px-Create- a-CSV-File-Step-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Enter data into the spreadsheet below each column if necessary. Following the example above in step #2, enter the item names in cell A2, the sale price in cell B2, and the description of those items in cell C2.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a3/Create-a-CSV-File-Step-4.jpg/v4-728px-Create-a-CSV-File- Step-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a3/Create-a-CSV-File-Step-4.jpg/v4-728px-Create- a-CSV-File-Step-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Click “File” and select “Save As” after you have entered all the data into the spreadsheet. On Google Sheets, this option will be “File > Download as” [2] X Research Source
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d4/Create-a-CSV-File-Step-5.jpg/v4-728px-Create-a-CSV-File- Step-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d4/Create-a-CSV-File-Step-5.jpg/v4-728px-Create- a-CSV-File-Step-5.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser -output”></div>”}
Select “CSV” below the “Save as type” drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c9/Create-a-CSV-File-Step-6.jpg/v4-728px-Create-a-CSV-File- Step-6.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c9/Create-a-CSV-File-Step-6.jpg/v4-728px-Create- a-CSV-File-Step-6.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser -output”></div>”}
Enter a name for the CSV file and then select “Save”. So you have created the CSV file, from now on commas will automatically be added to the file to separate each field. [3] X Research Sources
On Notepad
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/59/Create-a-CSV-File-Step-7.jpg/v4-728px-Create-a-CSV-File- Step-7.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/59/Create-a-CSV-File-Step-7.jpg/v4-728px-Create- a-CSV-File-Step-7.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser -output”></div>”}
Launch Notepad and enter the field names separated by commas in the first line. For example, when entering data about the items you are selling, enter the following in the first line: “ten,gia,mota”. Note: no spaces between entries.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5e/Create-a-CSV-File-Step-8.jpg/v4-728px-Create-a-CSV-File- Step-8.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5e/Create-a-CSV-File-Step-8.jpg/v4-728px-Create- a-CSV-File-Step-8.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser -output”></div>”}
Enter data in the second line in the same format as the field names in the first line. Following the example described in step #1, enter the actual item name, followed by the item’s price along with the description. For example, if you sell baseball, the content to enter is “bongchay,10000,thethao”.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/17/Create-a-CSV-File-Step-9.jpg/v4-728px-Create-a-CSV-File- Step-9.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/17/Create-a-CSV-File-Step-9.jpg/v4-728px-Create- a-CSV-File-Step-9.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”<div class=”mw-parser -output”></div>”}
Continue to enter the data of the items in each subsequent line. If you leave any fields blank, don’t forget to include a comma so that the remaining fields don’t lose data.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/72/Create-a-CSV-File-Step-10.jpg/v4-728px-Create-a-CSV-File- Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/72/Create-a-CSV-File-Step-10.jpg/v4-728px-Create- a-CSV-File-Step-10.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:548,”licensing”:”<div class=”mw-parser -output”></div>”}
Click “File” and select “Save. “
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/46/Create-a-CSV-File-Step-11.jpg/v4-728px-Create-a-CSV-File- Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/46/Create-a-CSV-File-Step-11.jpg/v4-728px-Create- a-CSV-File-Step-11.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Enter a name for the file and select “.csv” from the format drop-down menu.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fb/Create-a-CSV-File-Step-12.jpg/v4-728px-Create-a-CSV-File- Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fb/Create-a-CSV-File-Step-12.jpg/v4-728px-Create- a-CSV-File-Step-12.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser -output”></div>”}
Click “Save”. So you have finished creating the CSV file on Notepad. [4] X Research Sources
X
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, volunteer authors have edited and improved the article over time.
This article has been viewed 1,694 times.
The CSV (“comma-separated value”) format allows users to save data as a table. This format is very useful in case you need to manage large databases. CSV files can be created with Microsoft Excel, OpenOffice Calc, Google Sheets (or Google Sheets), and Notepad.
Thank you for reading this post How to Create a CSV File at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: