The CSV format is a physical representation of a relation (table).
Tabular formats are more space-efficient than JSON, which can improve loading times for large datasets.
While there are various specifications and implementations for the CSV format, there is no formal specification in existence, which allows for a wide variety of interpretations of CSV files.
Summary:
The text qualifier or better known the double quote character is used to enclose text values in the exported data.
This is required when some cell has values that include:
Within the header and each record, there may be one or more fields, separated by a delimiter character (generally commas).
The escape character for the text qualifier character is by default the double quote: “
Example:
You are "top"
in csv becomes:
"You are ""top"""
The newline in CSV follows this rules:
Example:
"You are ""top""" CRLF
"You are CRLF
top" CRLF
Extended CSV format add metadata to the data (such as data type,…)
By order of preference:
Tool;