Comma-separated values

A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A CSV file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields.

Comment: enA comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A CSV file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields.
ContainerFor: endatabase information organized as field separated lists
Depiction
Genre: enmulti-platform, serial data streams
Has abstract: enA comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A CSV file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields. The CSV file format is not fully standardized. Separating fields with commas is the foundation, but commas in the data or embedded line breaks have to be handled specially. Some implementations disallow such content while others surround the field with quotation marks, which yet again creates the need for escaping if quotation marks are present in the data. The term "CSV" also denotes several closely-related delimiter-separated formats that use other field delimiters such as semicolons. These include tab-separated values and space-separated values. A delimiter guaranteed not to be part of the data greatly simplifies parsing. Alternative delimiter-separated files are often given a ".csv" extension despite the use of a non-comma field separator. This loose terminology can cause problems in data exchange. Many applications that accept CSV files have options to select the delimiter character and the quotation character. Semicolons are often used instead of commas in many European locales in order to use the comma as the decimal separator and, possibly, the period as a decimal grouping character.
Icon: enCsvDelimited001.svg
Is primary topic of: Comma-separated values
Label: enComma-separated values
Link from a Wikipage to an external page: web.archive.org/web/20161213014111/https:/www.columbia.edu/sec/acis/db2/db2d0/db2d053.htm; www.columbia.edu/sec/acis/db2/db2d0/db2d053.htm
Link from a Wikipage to another Wikipage: 360; Apache Hive; Apache OpenOffice; ASCII; AWK; Backslash; Byte order; Byte order mark; Caret (punctuation); Category:Delimiter-separated format; Category:Open formats; Category:Spreadsheet file formats; Character (computing); Character encoding; Character set; Comma; Comma (punctuation); Comparison of data-serialization formats; CudaText; Cut (Unix); Database; Data exchange; Decimal mark; Decimal separator; De facto; De jure; Delimited; Delimiter; Delimiter collision; Delimiter-separated values; Demographic and Health Survey; Documents; Double quote; EBCDIC; Emacs; Endianness; Escape character; Field (computer science); File format; Filename extension; Flat-file database; Foreign key; Fortran; FORTRAN 77; General Punctuation; Grapheme; Gzip; Hierarchical; HTML; IBM; IETF; IntelliJ; Internet Assigned Numbers Authority; Interoperability; Join (Unix); LibreOffice Calc; Locale (computer software); Metadata; Microsoft Excel; MIME content type; MIME type; Native and foreign format; Newline; Notepad++; Null character; Numbers (spreadsheet); Object-oriented; Open Knowledge Foundation; Osborne Computer Corporation; Parsing; Paste (Unix); Personal computer; Plain text; PostgreSQL; Programming language; Proprietary format; Punched card; Quotation mark; Record (computer science); Relation (database); Relational database; Relational databases; Row (database); Semantic Web; Shift JIS; Simple Data Format; Sort (Unix); Specification (technical standard); Spreadsheet; SQL; Statistical analysis; Substitute character; SuperCalc; Sybase; Table (information); Tab-separated values; TextEdit; Text file; Unicode; Uniq; Unix; URI fragment; UTF-16; UTF-8; Vim (text editor); Visual Studio Code; W3C; WordPad; Word size; World Wide Web Consortium; XML
Name: enComma-separated values
Noextcode: enon
Nomimecode: enon
SameAs: .csv (Dateiformat); 55Paz; Comma Separated Values; Comma-separated values; Comma-separated values; Comma-separated values; Comma-separated values; Comma-separated values; Comma-separated values; Comma-separated values; Comma-separated values; Comma-separated values; Comma-Separated Values; CSV; CSV; CSV; CSV; CSV; CSV; CSV; CSV; CSV; CSV; CSV (Dateiformat); CSV (format pliku); CSV (파일 형식); Kommagescheiden bestand; m.02hznc; Q935809; Valores separados por comas; قيم مفصولة بفواصل; مقادیر جداشده با ویرگول; அணித்தரவுக்கோப்பு; 逗号分隔值
Standard: enRFC 4180
Subject: Category:Delimiter-separated format; Category:Open formats; Category:Spreadsheet file formats
Thumbnail
WasDerivedFrom: Comma-separated values?oldid=1119335446&ns=0
WikiPageLength: 29082
Wikipage page ID: 501906
Wikipage revision ID: 1119335446
WikiPageUsesTemplate: Template:As of; Template:Citation needed; Template:Cite web; Template:Code; Template:Data Exchange; Template:Essay-like; Template:IETF RFC; Template:Infobox file format; Template:Lead too short; Template:More citations needed; Template:Multiple issues; Template:Reflist; Template:Short description; Template:Which
Wordnet_type: synset-format-noun-1

Comma-separated values

Backlinks

About

Resources

Support

Follow us