Editing Comma-separated values (section)

==Example==
{| class="wikitable"
|-
!Year||Make||Model||Description||Price
|-
|1997||Ford||E350||ac, abs, moon||3000.00
|-
|1999||Chevy||Venture "Extended Edition"|| ||4900.00
|-
|1999||Chevy||Venture "Extended Edition, Very Large"|| ||5000.00
|-
|1996||Jeep||Grand Cherokee||MUST SELL!<br>air, moon roof, loaded||4799.00
|}

The above table of data may be represented in CSV format as follows:

 Year,Make,Model,Description,Price
 1997,Ford,E350,"ac, abs, moon",3000.00
 1999,Chevy,"Venture ""Extended Edition""","",4900.00
 1999,Chevy,"Venture ""Extended Edition, Very Large""","",5000.00
 1996,Jeep,Grand Cherokee,"MUST SELL!
 air, moon roof, loaded",4799.00

Example of a USA/UK CSV file (where the decimal separator is a period/full stop and the value separator is a comma):

 Year,Make,Model,Length
 1997,Ford,E350,2.35
 2000,Mercury,Cougar,2.38

Example of an analogous European CSV/[[delimiter-separated values|DSV]] file (where the decimal separator is a comma and the value separator is a semicolon):

 Year;Make;Model;Length
 1997;Ford;E350;2,35
 2000;Mercury;Cougar;2,38

The latter format is not RFC 4180 compliant.<ref>{{harvtxt|Shafranovich|2005}} states, "Within the header and each record, there may be one or more fields, separated by commas."</ref> Compliance could be achieved by the use of a comma instead of a semicolon as a separator and by quoting all numbers that have a decimal mark.