Skip to content

How to create a CSV file?

  • by
  • 3 min read

Creating a Comma-separated value (CSV) file is a straightforward process that allows you to store and exchange data in a format that is widely supported by various software applications.

Whether you need to organise data for analysis, import it into a database, or share it with others, knowing how to create a CSV file can be immensely useful. In this article, we will discuss how you can create a CSV file.

Create a CSV file by using a spreadsheet application

You can create a CSV file by using a spreadsheet application like Microsoft Excel or Google Sheets. Just follow the steps below to do so:

Step 1: Open a spreadsheet application like Excel and then open a spreadsheet file. We will take Excel as an example. In Excel, click on the File option at the top left.

Step 2: Now, click on Save As.

Step 3: Next, select the Browse option as shown in the screenshot above.

Step 4: Click on the Save as type option to open the drop-down menu. Here, select the CSV UTF 8 format and then click OK.

This is the first method of creating a CSV file. In other spreadsheet applications, you will find similar settings. Just remember to select the Save as option and then select the CSV format.

Also read: What is Monitor PNF? What does it do? Is it safe?

Create a CSV file by using a text editor application

You can also create a CSV file via text editor software like Notepad. Here’s how to do that:

Step 1: Open any text editor software and then enter the data. Remember to separate each cell by a comma. For example, if you are entering your monthly rent which is 1000, you will enter it like this — Rent,1000. If there are additional data, keep on adding them in front of 1000 separated by a comma. Once you are finished, go to File > Save as.

Step 2: Enter the file name that you want to give and add .csv after it. Confirm the process by clicking on Save.

Note: If your data contains a comma or a double quote, you can use double quotes for that data. For example, if you have the following data — Rent 1000 Make an offer, another time. You will enter it as follows — Rent,1000,”Make an offer, another time”. Now, you get the idea.

Also read: How to open VTT file?


Kumar Hemant

Deputy Editor at Candid.Technology. Hemant writes at the intersection of tech and culture and has a keen interest in science, social issues and international relations. You can contact him here: [email protected]