What Is The Full Form Of CSV?
The Full Form Of CSV is Comma Separated Value
CSV (Comma Separated Values) stores tabular data. Each line of files is a record and CSV uses a comma to separate the values. CSV stores tabular data in such a way where each line has the same number of fields. The CSV files are not completely standardized. The fields separated by commas in CSV are the base, the commas between the data should be specially handled. CSV allows transferring large files between multiple programs.
Advantages of CSV
- CSV files are easy to create and read.
- CSV files can be edited in the editor like notepad.
- CSV is safe, and it does not make changes or manipulate the data. The numeric and text values are differentiated in CSV.
- In CSV you need to write the column header only once.
- It is very easy to import CSV files and it consumes less memory.
Disadvantages of CSV
- It is difficult to move complex configurations in CSV. CSV allows moving most basic data.
- The CSV doesn’t contain any standards to represent binary data.
- It is difficult to use a special character in CSV as the support is poor.
- There is no distinction between NULL and Quotes, thus there is always a problem with importing CSV into SQL.
Characteristics of CSV
- If the entered record is large it consumes multiple lines as the new data is always entered in a new line.
- The CSV files do not allow the space characters next to built-in commas.
- The set of double quotes contains only those fields which contain a comma.
- In CSV files the data fields are always separated by commas.