Making a .CSV file- using notepad

What is a CSV file and what is its purpose?

CSV stands for Comma-Separated-Value. It is used to store tabular data in plain text. As the name suggests each value is separated by a comma. This format is widely used to move data from one program to another.

Example please!

Let us consider the following Employee table.

ID Name Salary
1011 John 20000
1012 Smith 30000

This data can be stored in a file with .csv extension using simple notepad.

Steps to represent above employee table data in a .csv file using notepad:

  1. Open Notepad application.
  2. Type the following:

ID,Name,Salary

1011,John,20000

1012,Smith,30000

  1. Save it as a .csv file. (say demo.csv)
  2. Open this file with MS Excel to see the data in tabular form.

Note:

  1. First line should be the names of columns
  2. Table values should then follow.
  3. Each one of these have to be separated by comma.
Advertisements

One thought on “Making a .CSV file- using notepad

  1. Pingback: Making a .CSV file- using notepad | SutoCom Solutions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s