How are CSV files generally formatted?

How are CSV files generally formatted?

CSV files should follow a standard format:

• Fields/columns are separated by a single character delimiter, typically a comma or semicolon.
• Each record/row is terminated by a new line.
• All records/rows have the same number of fields/columns in the same order.
• The first record/row may be a header that contains the field/column names of each field/column.
• Data within each field is interpreted as a sequence of characters or plain text.
• Any field may be quoted within double-quote characters.
• A field should be quoted when it contains one or more special characters. Here is our complete list of special characters.
• Leading and trailing spaces are considered part of the data in a field.