The comma-separated values (CSV) file format is a tabular data format that has fields separated by the comma character and quoted by the double quote character. If a field's value contains a double quote character it is escaped with a pair of double quote characters.

The CSV file format does not require a specific character encoding, byte order or line terminator format.

It is often not required by software to have fields quoted unless they contain a comma character.

Example:

"Chicane", "Love on the Run", "Knight Rider", "This field contains a comma, but it doesn't matter as the field is quoted" "Charles Barber", "Adagio for Strings", "Classical", "This field contains a double quote character, "", but it doesn't matter as it is escaped"

Link:

Microsoft Office Online