If the field delimiter itself may appear within a field, fields can be surrounded with quotation marks.
Each record consists of the same number of fields, and these are separated by commas in the CSV file. A CSV file stores tabular data (numbers and text) in plain text, where each line of the file typically represents one data record. A simple CSV file listing three people and the companies they work forĭatabase information organized as field separated listsĬomma-separated values ( CSV) is a text file format that uses commas to separate values.