What is csv file? What is it for? How useful is it?

Question

Thanks a lot for answering my questions.

Answer 1

A CSV ( Comma Seperated Value ) file is a text file which contains some tabular data which is seperated by commas.

eg.

Name, Age, Salary
"abc",21,2000
"xyz",44,3000


In the above example there are three fields ie. Name , Age and the Salary

The first value which is the name is enclosed double quotes "abc". Where as the numbers are not enclosed in double quotes. But all the values have comma as the delimiter or seperator.


These type of files are used to export or import data from the databases.

These files have the extension .CSV
These files can be easily opened in MS Excel ( however if they are very very larges then all the rows can not be seen, I think the MS Excel has a limitation that it can not show more than 64,000 rows.

But you can still open these files in notepad or wordpad.

Answer 2

The comma-separated values (or CSV) file format is a delimited data format that has fields separated by the comma character and records separated by newlines. Fields which contain a comma, newline, or double quote character or which start or end with whitespace, must be enclosed in double quotes. Furthermore, if a line contains a single entry which is the empty string, it must be enclosed in double quotes. If a field's value contains a double quote character it is escaped by placing another double quote character next to it. The CSV file format does not require a specific character encoding, byte order, or line terminator format.

Answer 3

FileMaker professional helps CSV. CSV is a format that would want to correctly be used to flow files between 2 software whose interior reach files format aren't any further properly matched. The CSV files has also been used to flow files between diverse sort of computer using diverse inner note sizes, files formatting needs, and so citadel. that is why the CSV format is common on many platform. My own journey with CSV record has confirmed they they don't seem as transportable as one might want to imagine. The programmer has to address distinction in how the right of line is coded and with the version in encoding. the version in encoding is flagrant even as non English letters which consists of é,ê and ù are used. CSV has the great element about being human readable, a function lacked through the binary files of a database.

Answer 4

A common text file format that contains comma-delimited values. In the case of Performance Monitor, these values describe devices and their attributes.

Answer 5

CSV = Comma Seperated/Saved Value (a.k.a. spread sheet) You can use something like it to mass list items on ebay by putting in the information of each item in each square for each part of the auction

Answer 6

I THINK this is a database file format. EXCEL can open it into a spreadsheet so you can work with it and save it as an .xls file. I don't know what its usefullness is, but I suppose it acts like a "universal" file for spreadsheets and database engines.