Quotation marks are used as text qualifiers
Quotation marks appear in CSV files as text qualifiers
. This means, they function to wrap together text that should be kept as one value, versus what are distinct values that should be separated out.
This is particularly relevant when you take data from a CSV - which maintains its simple structure by commas - and open that data in a spreadsheet program or import it into a database, and other such scenarios. The program or database needs to know which commas are true delimiters and which commas are just part of the text within your file.
Remember our CSV to Excel conversion article
, in step 2, Excel requires that you specify what you are using as your text qualifier. It needs this information so that when you open your file, your data is accurately parsed out into the columns and rows as you intended.