CSV
E35620
CSV (Comma-Separated Values) is a simple, text-based file format commonly used to store and exchange tabular data between different software applications and systems.
Observed surface forms (1)
| Surface form | Occurrences |
|---|---|
| Comma-Separated Values | 1 |
Statements (56)
| Predicate | Object |
|---|---|
| instanceOf |
file format
ⓘ
tabular data format ⓘ text-based format ⓘ |
| advantage |
simplicity
ⓘ
small file size ⓘ wide compatibility ⓘ |
| alternativeDelimiters |
pipe
ⓘ
semicolon ⓘ tab ⓘ |
| columnSeparator | comma ⓘ |
| commonlyUsedBy |
databases
ⓘ
programming languages ⓘ spreadsheets ⓘ statistical software ⓘ |
| commonlyUsedIn |
APIs for bulk data download
ⓘ
ETL processes ⓘ data pipelines ⓘ |
| dataStructure | table ⓘ |
| definedIn | RFC 4180 ⓘ |
| doesNotSupport |
binary data without encoding
ⓘ
explicit data types ⓘ nested structures ⓘ |
| encoding |
commonly ASCII
ⓘ
commonly UTF-8 ⓘ |
| fileExtension | .csv ⓘ |
| fullName |
CSV
self-linksurface differs
ⓘ
surface form:
Comma-Separated Values
|
| humanReadable | true ⓘ |
| introducedYear | 1970s ⓘ |
| limitation |
ambiguous data types
ⓘ
lack of schema ⓘ locale-dependent formatting ⓘ no standard for metadata ⓘ |
| mediaType | text/csv ⓘ |
| openedBy |
Google Sheets
ⓘ
LibreOffice Calc ⓘ Excel ⓘ
surface form:
Microsoft Excel
text editors ⓘ |
| parsingComplexity | simple ⓘ |
| relatedFormat |
JSON
ⓘ
TSV ⓘ XML ⓘ |
| rowSeparator | newline ⓘ |
| standardizedBy |
Internet Engineering Task Force
ⓘ
surface form:
IETF
|
| stores |
columns
ⓘ
rows ⓘ tabular data ⓘ |
| supports |
empty fields
ⓘ
escaped quotes ⓘ header row ⓘ quoted fields ⓘ variable-length rows ⓘ |
| supportsDelimiterVariation | true ⓘ |
| usedFor |
data exchange
ⓘ
data export ⓘ data import ⓘ simple data storage ⓘ |