 Hello everyone there, my name is Krishanaj Rana and I would like to welcome you to this new course Essential Secrets of CSV here at Bitescout. Alright a CSV or a comma separated value is a file format which is one of the common way of storing records in a portable and simple format. It looks a lot like a plain text file which holds data in table format. The information is organized with one record on each line or you can say each line is like a row in a table and columns are separated by a comma. In short it is a delimited text file that uses a comma to separate values and hence the name comma separated value. Okay so now without go much into the theory let's write one CSV file and try to understand it. Let's assume that we need to create a sample CSV file which will represent a patient information and we'll need to import it into one application. So let's jump into it. Alright so here in the left pen you can see that the extension of the comma separated file is .csv and by the way it is not necessary that the comma separated file extension is always .csv. It can also be the .txt file and this is the sample text file which contains the patient information like patient ID, patient name, chart number and who is the primary care physician and so on and so forth. Now let's write the CSV file for this information. Okay so as I said a CSV file holds record in a table format. So here in this import patient .csv file let's define the column name as header separated by comma. So as per this text file first column is the patient ID followed by patient name. So let's start by defining this column in this file comma patient name comma gender comma and then in the next line we have subsequent rows containing records separated by a comma. So as per this .txt file 1010 is our first patient ID. So let's write down the same in this CSV file patient ID and then comma followed by patient name then we have a gender then we have a chart number. Now same way let's define the another row for the next patient and then for the last patient now let me save the file. So our CSV file is ready now one of the big advantages of CSV file is that it can be easily managed via Microsoft Excel or some similar softwares. So let me go to the file location of this file by right clicking on this and select this option. So now when I double click on this file it is opening in Microsoft Excel and it looks something like this and you can see that how beautifully our data are displayed in this Excel sheet.