How to create a CSV file: 12 steps (with pictures)

How to create a CSV file: 12 steps (with pictures)
How to create a CSV file: 12 steps (with pictures)
Anonim

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

Create a CSV File Step 1

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

Create a CSV File Step 2

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.

Create a CSV File Step 3

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.

Create a CSV File Step 4

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.

Create a CSV File Step 5

Step 5. Select CSV from the Type drop-down menu

Create a CSV File Step 6

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

Create a CSV File Step 7

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.

Create a CSV File Step 8

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.

Create a CSV File Step 9

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.

Create a CSV File Step 10

Step 4. Click File, then Save As

Create a CSV File Step 11

Step 5. Rename the file

Type a name for the file followed by the extension .csv.

Create a CSV File Step 12

Step 6. Click Save

You have just created a CSV file with Notepad.

Popular by topic