Enter into csv file

By using our site, you agree to our cookie policy. Cookie Settings. Learn why people trust wikiHow. Download Article Explore this Article methods. Related Articles. Article Summary. Method 1. If you want to convert an existing spreadsheet to CSV format, skip to step 4. Type each of your headers, or field names into the cells located in row 1 at the top of the spreadsheet. Enter your data into the spreadsheet under each column as needed. Method 2. Launch Notepad and type your field names separated by commas onto the first line.

Type your data onto the second line, using the same format as your field names on the first line. 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. These files are usually read by programs that use it as data. Not Helpful 0 Helpful Include your email address to get a message when this question is answered. June 28, Was this article helpful?

Vladimir Kaplarevic. He has more than 7 years of experience in implementing e-commerce and online payment solutions with various global IT services providers. His articles aim to instill a passion for innovative technologies in others by providing practical advice and using an engaging writing style. Next you should read. SysAdmin Web Servers. It can be In these examples, " CRLF " is used to represent a carriage return and a linefeed which together constitute a newline.

For example, below is the data contained in our example Excel worksheet:. Once open, click File and choose Save As. After you save the file, you are free to open it up in a text editor to view it or edit it manually. Its contents resemble the following:. The last row begins with two commas because the first two fields of that row were empty in our spreadsheet. Don't delete them — the two commas are required so that the fields correspond from row to row.

They cannot be omitted. For example, below is the data contained in our example Calc worksheet. If you were to open the CSV file in a text editor, such as Notepad, it would resemble the example below.

As in our Excel example, the two commas at the beginning of the last line make sure the fields correspond from row to row. Do not remove them!