CSV

• A CSV file contains a number of rows, each containing a number of columns, usually separated by commas.

Why use CSV?

The file format .csv is not meant to be one in which people store data long-term; rather, it is meant to be a way to move data from one program to another.

CSV File Format Standards?

1. Each record is located on a separate line, delimited by a line break (CRLF).     For example: aaa,bbb,ccc CRLF zzz,yyy,xxx CRLF

2. The last record in the file may or may not have an ending line break. 
     For example: aaa,bbb,ccc CRLF zzz,yyy,xxx

3. Each record is one line - Line separator may be LF (0x0A) or CRLF (0x0D0A), a line separator may also be embedded in the data (making a record more than one line but still acceptable).

4.Fields are separated with commas.

5. Always Delimiting, Fields may always be delimited with double quotes, the delimiters will be parsed and discarded by the reading applications.

• CSV format is the most common import and export format for spreadsheets and databases.

Examples:

1. Importing a CSV file into Excel work space:

2. Exporting a Excel file into CSV file: