720:, not as a sequence of bits or bytes (see RFC 2046, section 4.1). For example, the numeric quantity 65535 may be represented as the 5 ASCII characters "65535" (or perhaps other forms such as "0xFFFF", "000065535.000E+00", etc.); but not as a sequence of 2 bytes intended to be treated as a single binary integer rather than as two characters (e.g. the numbers 11264–11519 have a comma as their high order byte:
625:(OKF) and various partners created a data protocols working group, which later evolved into the Frictionless Data initiative. One of the main formats they released was the Tabular Data Package. Tabular Data package was heavily based on CSV, using it as the main data transport format and adding basic type and schema metadata (CSV lacks any type information to distinguish the string "1" from the number 1).
473:) as with ASCII (although particular programs that support CSV may have their own limitations). CSV files normally will even survive naïve translation from one character set to another (unlike nearly all proprietary data formats). CSV does not, however, provide any way to indicate what character set is in use, so that must be communicated separately, or determined at the receiving end (if possible).
27:
36:
640:"CSV on the Web" working group began to specify technologies providing higher interoperability for web applications using CSV or similar formats. The working group completed its work in February 2016 and is officially closed in March 2016 with the release of a set of documents and W3C recommendations for modeling "Tabular Data", and enhancing CSV with
828:
According to RFC 4180, spaces outside quotes in a field are not allowed; however, the RFC also says that "Spaces are considered part of a field and should not be ignored." and "Implementers should 'be conservative in what you do, be liberal in what you accept from others' (RFC 793, section 2.10) when
546:
Other implementation differences include the handling of more commonplace field separators (such as space or semicolon) and newline characters inside text fields. One more subtlety is the interpretation of a blank line: it can equally be the result of writing a record of zero fields, or a record of
280:
Within these general constraints, many variations are in use. Therefore, without additional information (such as whether RFC 4180 is honored), a file claimed simply to be in "CSV" format is not fully specified. As a result, some applications supporting CSV files have text import wizards that allow
538:
The name "CSV" indicates the use of the comma to separate data fields. Nevertheless, the term "CSV" is widely used to refer to a large family of formats that differ in many ways. Some implementations allow or require single or double quotation marks around some or all fields; and some reserve the
175:
The lack of adherence to the CSV standard RFC 4180 necessitates the support for a variety of CSV formats in data input software. Despite this drawback, CSV remains widespread in data applications and is widely supported by a variety of software, including common spreadsheet applications such as
514:
systems often include utilities that can "rotate" such data; for example, a "parent" record that includes information about five children can be split into five separate records, each containing (a) the information on one child, and (b) a copy of all the non-child-specific information. CSV can
211:
include the option to export data to CSV for long-term storage. Benefits of CSV for data storage include the simplicity of CSV makes parsing and creating CSV files easy to implement and fast compared to other data formats, human readability making editing or fixing data simpler, and high
847:
The first record may be a "header", which contains column names in each of the fields (there is no reliable way to tell whether a file does this or not; however, it is uncommon to use characters other than letters, digits, and underscores in such column names).
953:
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
768:). If this "plain text" convention is not followed, then the CSV file no longer contains sufficient information to interpret it correctly, the CSV file will not likely survive transmission across differing computer architectures, and will not conform to the
442:) characters around values that contain reserved characters (such as commas, double quotes, or less commonly, newlines). Embedded double quote characters may then be represented by a pair of consecutive double quotes, or by prefixing a double quote with an
559:"text/csv" for the handling of text-based fields. However, the interpretation of the text of each field is still application-specific. Files that follow the RFC 4180 standard can simplify CSV exchange and should be widely portable. Among its requirements:
418:
The format dates back to the early days of business computing and is widely used to pass data between computers with different internal word sizes, data formatting needs, and so forth. For this reason, CSV files are common on all computer platforms.
212:
compressibility leading to smaller data files. Alternatively, CSV does not support more complex data relations and makes no distinction between null and empty values, and in applications where these features are needed other formats are preferred.
1019:
also supports a dialect of CSV with restrictions in comparison to other spreadsheet software (e.g., as of 2019 Excel still cannot export CSV files in the commonly used UTF-8 character encoding, and separator is not enforced to be the comma).
438:"^" to be the separator instead of comma ","). Simple CSV implementations may prohibit field values that contain a comma or other special characters such as newlines. More sophisticated CSV implementations permit them, often by requiring " (
709:
A record ends at a line terminator. However, line terminators can be embedded as data within fields, so software must recognize quoted line-separators (see below) in order to correctly assemble an entire record from perhaps multiple
821:
In some CSV implementations, leading and trailing spaces and tabs are trimmed (ignored). Such trimming is forbidden by RFC 4180, which states "Spaces are considered part of a field and should not be ignored."
329:
Comma separated files are used for the interchange of database information between machines of two different architectures. The plain-text character of CSV files largely avoids incompatibilities such as
628:
The
Frictionless Data Initiative has also provided a standard CSV Dialect Description Format for describing different dialects of CSV, for example specifying the field separator or quoting rules.
319:
spreadsheet, documents the CSV quoting convention that allows strings to contain embedded commas, but the manual does not specify a convention for embedding quotation marks within quoted strings.
192:
format that is widely supported by consumer, business, and scientific applications. Among its most common uses is moving tabular data between programs that natively operate on incompatible (often
543:(BOM) to enforce Unicode interpretation (sometimes even a UTF-8 BOM). Files that use the tab character instead of comma can be more precisely referred to as "TSV" for tab-separated values.
522:(such as an ID number or name for the parent). In markup languages such as XML, such groups are typically enclosed within a parent element and repeated as necessary (for example, multiple
973:
The latter format is not RFC 4180 compliant. 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.
430:
to separate values (many implementations of CSV import/export tools allow other separators to be used; for example, the use of a "Sep=^" row as the first row in the *.csv file will cause
1688:
518:
In a relational database, similar issues are readily handled by creating a separate relation for each such group, and connecting "child" records to the related "parent" records using a
204:
can export data as CSV. Most spreadsheet programs can read CSV data, allowing CSV to be used as an intermediate format when transferring data from a database to a spreadsheet.
1619:
1120:) can split files on a comma delimiter, and can therefore process simple CSV files. However, this method does not correctly handle commas or new lines within quoted strings.
841:
Double quote processing need only apply if the field starts with a double quote. Note, however, that double quotes are not allowed in unquoted fields according to RFC 4180.
172:
even when the field separator is not a comma. Many applications or libraries that consume or produce CSV files have options to specify an alternative delimiter.
1436:
157:, and these are separated by commas in the CSV file. If the field delimiter itself may appear within a field, fields can be surrounded with quotation marks.
326:) than fixed-column-aligned data, and they were less prone to producing incorrect results if a value was punched one column off from its intended location.
1458:
506:
in various fields often have a generally relation-like structure, but with some repeatable groups of fields. For example, health databases such as the
407:
CSV formats are best used to represent sets or sequences of records in which each record has an identical list of fields. This corresponds to a single
1209:
Programs that work with CSV may have limits on the maximum number of rows CSV files can have. Below is a list of common software and its limitations:
196:
or undocumented) formats. For example, a user may need to transfer information from a database program that stores data in a proprietary format, to a
2334:
2092:(Has file descriptions of delimited ASCII (.DEL) (including comma- and semicolon-separated) and non-delimited ASCII (.ASC) files for data transfer.)
1258:
2117:
775:
Adjacent fields must be separated by a single comma. However, "CSV" formats vary greatly in this choice of separator character. In particular, in
308:, approved in 1978. List-directed input used commas or spaces for delimiters, so unquoted character strings could not contain commas or spaces.
1024:
CSV importer is actually a more generic delimited text importer, supporting multiple separators at the same time as well as field trimming.
539:
first record as a header containing a list of field names. The character set being used is undefined: some applications require a
Unicode
2353:
2233:
665:
1667:
228:
2080:
1360:
2363:
338:. The files are largely human-readable, so it is easier to deal with them in the absence of perfect documentation or communication.
1390:
380:
to CSV documents. RFC 7111 specifies how row, column, and cell ranges can be selected from a CSV document using position indexes.
281:
users to preview the first few lines of the file and then specify the delimiter character(s), quoting rules, and field trimming.
1326:
273:(typically a single reserved character such as comma, semicolon, or tab; sometimes the delimiter may include optional spaces),
2185:
2135:
1128:, but differ from interchange format ("export/import only") because it is not necessary to create a copy in another format:
231:
for the CSV format; however, actual practice often does not follow the RFC and the term "CSV" might refer to any file that:
996:
As a data interchange format: the CSV file format is supported by almost all spreadsheets and database management systems,
835:
In CSV implementations that do trim leading or trailing spaces, fields with such spaces as meaningful data must be quoted.
507:
815:
Fields with embedded line breaks must be quoted (however, many CSV implementations do not support embedded line breaks).
2313:
312:
488:
data. This is because every CSV record is expected to have the same structure. CSV is therefore rarely appropriate for
2110:
957:
Example of a USA/UK CSV file (where the decimal separator is a period/full stop and the value separator is a comma):
566:
An optional header record (there is no sure way to detect whether it is present, so care is required when importing).
510:
typically repeat some questions for each child of a given parent (perhaps up to a fixed maximum number of children).
1637:
For users familiar with the predecessor FORTRAN IV G and H processors, these are the major new language capabilities
1263:
964:
776:
423:
161:
83:
1572:
1428:
1910:
1125:
637:
622:
150:
681:
609:
programs may confuse the optional header with data or interpret the first data line as an optional header, and
266:
154:
98:
1523:
70:
2103:
111:
2358:
2223:
1004:
717:
809:
Each of the embedded double-quote characters must be represented by a pair of double-quote characters.
779:
where the comma is used as a decimal separator, a semicolon, TAB, or other character is used instead.
1800:
1747:
1340:
1283:
1253:
1194:
1028:
511:
503:
165:
1649:
311:
The term "comma-separated value" and the "CSV" abbreviation were in use by 1983. The manual for the
2163:
1291:
1268:
685:
477:
435:
427:
412:
408:
142:
1957:
states, "Within the header and each record, there may be one or more fields, separated by commas."
2173:
1710:
1278:
1273:
699:
193:
169:
46:
1547:
1383:"CSV Comma Separated Value File Format - How To - Creativyst - Explored,Designed,Delivered.(sm)"
2048:
1237:
1198:
1012:
601:
The format can be processed by most programs that claim to read CSV files. The exceptions are
362:
290:
208:
180:. Benefits cited in favor of CSV include human readability and the simplicity of the format.
2297:
1988:
1790:
1737:
1330:
1137:
1021:
1008:
986:
843:
Los
Angeles,34°03′N,118°15′W New York City,40°42′46″N,74°00′21″W Paris,48°51′24″N,2°21′03″E
443:
354:
220:
2143:
2072:
1870:
1412:
1382:
1016:
671:
Rules typical of these and other "CSV" specifications and implementations are as follows:
540:
485:
431:
177:
1774:, the first W3C recommendation scoped in CSV and filling some of RFC 4180's deficiencies.
2009:
1967:
365:. Later, in 2013, some of RFC 4180's deficiencies were tackled by a W3C recommendation.
2272:
2168:
1847:
1621:
IBM FORTRAN Program
Products for OS and the CMS Component of VM/370 General Information
1320:
1287:
692:
1825:"Model for Tabular Data and Metadata on the Web – W3C Recommendation 17 December 2015"
967:
file (where the decimal separator is a comma and the value separator is a semicolon):
587:
be quoted. (If they are not, the file will likely be impossible to process correctly.)
2347:
2302:
2292:
2180:
2126:
982:
458:
189:
555:
The 2005 technical standard RFC 4180 formalizes the CSV file format and defines the
1101:
706:, or line terminator format (some software do not support all line-end variations).
645:
481:
480:
cannot be exported as a single CSV file. Similarly, CSV cannot naturally represent
439:
388:
377:
323:
1888:
1771:
563:
MS-DOS-style lines that end with (CR/LF) characters (optional for the last line).
2287:
2282:
2240:
2215:
1803:
1784:
1750:
1731:
1343:
1175:
1133:
1109:
1105:
1000:
519:
373:
358:
224:
197:
304:
supported CSV in 1972. List-directed ("free form") input/output was defined in
35:
2318:
1097:
1032:
703:
331:
305:
236:
146:
58:
26:
1597:
1824:
1733:
RFC 4180: Common Format and MIME Type for Comma-Separated Values (CSV) Files
1482:
1368:
677:
661:
556:
489:
447:
335:
316:
270:
256:
130:
1942:
1039:
command, which allows for both saving and loading data to and from a file.
168:, space, and semicolon. Delimiter-separated files are often given a ".csv"
1502:
2030:
1233:
688:
641:
593:
double-quotes are used to enclose fields, then a double-quote in a field
343:
201:
103:
2095:
1906:
2255:
2153:
1229:
803:
Fields with embedded commas or double-quote characters must be quoted.
462:
349:
297:
244:
138:
2073:"IBM DB2 Administration Guide - LOAD, IMPORT, and EXPORT File Formats"
1222:
Google Sheets: 5,000,000 cell limit (the product of columns and rows);
793:(that is, enclosed within double-quote characters), while some fields
40:
A simple CSV file listing three people and the companies they work for
2307:
2265:
2250:
2245:
1795:
1742:
1335:
950:
The above table of data may be represented in CSV format as follows:
713:
All records should have the same number of fields, in the same order.
470:
451:
301:
252:
207:
CSV is also used for storing data. Common data science tools such as
970:
Year;Make;Model;Length 1997;Ford;E350;2,35 2000;Mercury;Cougar;2,38
960:
Year,Make,Model,Length 1997,Ford,E350,2.35 2000,Mercury,Cougar,2.38
613:
double-quotes in a field may not be parsed correctly automatically.
1140:
offers this option, without enforcing user to adopt another format.
515:
represent either the "vertical" or "horizontal" form of such data.
2228:
2190:
1186:
660:
RFC 4180 (summarized above) defines the format for the "text/csv"
530:
node). With CSV there is no widely accepted single-file solution.
466:
248:
240:
134:
415:, or to data (though not calculations) in a typical spreadsheet.
322:
Comma-separated value lists are easier to type (for example into
2323:
2277:
2260:
2205:
2195:
2158:
1179:
1113:
1093:
657:
493:
369:
2099:
2200:
2076:
1930:
1786:
RFC 7111: URI Fragment
Identifiers for the text/csv Media Type
1117:
497:
384:
294:
1548:"CSV Format: History, Advantages and Why It Is Still Popular"
1201:, character encoding, quoting conventions, date format, etc.
797:
be quoted, as specified in the following rules and examples:
1216:
Microsoft PowerShell, no row or cell limit. (Memory
Limited)
149:, where each line of the file typically represents one data
656:
Many informal documents exist that describe "CSV" formats.
605:
programs may not support line-breaks within quoted fields,
1143:
Some relational databases, when using standard SQL, offer
547:
one field of zero length; thus decoding it is ambiguous.
1197:. Most provide some way to specify the field delimiter,
1193:
CSV format is supported by libraries available for many
1365:
Apple
Developer Documentation: Uniform Type Identifiers
1243:
Databases (COPY command and FDW): no row or cell limit.
583:
Fields containing a line-break, double-quote or commas
1524:"pandas.DataFrame.to_csv — pandas 2.0.3 documentation"
1124:
As (main or optional) internal representation. Can be
289:
Comma-separated values is a data format that predates
1627:(first ed.), July 1972, p. 17, GC28-6884-0
989:, exporting and importing CSV. Others use CSV as an
817:
1997,Ford,E350,"Go get one now they are going fast"
262:
consists of records (typically one record per line),
2214:
2134:
1849:
How To: The Comma
Separated Value (CSV) File Format
1598:"Comma Separated Values (CSV) Standard File Format"
1189:
editor can operate on CSV files using csv-nav mode.
1160:
1148:
1040:
850:Year,Make,Model 1997,Ford,E350 2000,Mercury,Cougar
721:
716:Data within fields is interpreted as a sequence of
500:, or other markup or word-processing technologies.
276:
where every record has the same sequence of fields.
110:
97:
89:
79:
69:
57:
51:
45:
1573:"Comparison of different file formats in Big Data"
573:contain the same number of comma-separated fields.
341:The main standardization initiative—transforming "
1225:OpenOffice and LibreOffice: 1,048,576 row limit;
164:. Delimiters frequently used include the comma,
1668:"SuperCalc², spreadsheet package for IBM, CP/M"
1943:Model for Tabular Data and Metadata on the Web
597:be represented by two double-quote characters.
200:that uses a completely different format. Most
106:information organized as field separated lists
2111:
1689:"Comma-Separated-Value Format File Structure"
153:. Each record consists of the same number of
8:
1954:
1459:"Import or export text (.txt or .csv) files"
1031:support saving query results to a CSV file.
824:1997, Ford, E350 not same as 1997,Ford,E350
457:CSV formats are not limited to a particular
19:
811:1997,Ford,E350,"Super, ""luxurious"" truck"
395:for CSV metadata standards, which began as
2118:
2104:
2096:
1355:
1353:
1147:(FDW). For example, PostgreSQL offers the
347:fuzzy definition" into a more precise and
1794:
1741:
1334:
1322:Common Format and MIME Type for CSV Files
1314:
1312:
1310:
1308:
1306:
1171:commands to configure any variant of CSV.
2335:Comparison of data-serialization formats
1711:"CSV, Comma Separated Values (RFC 4180)"
1259:Comparison of data-serialization formats
860:
837:1997,Ford,E350," Super luxurious truck "
1989:"Documentation: 14: F.35. postgres_fdw"
1302:
805:1997,Ford,E350,"Super, luxurious truck"
698:A CSV file does not require a specific
141:to separate records. A CSV file stores
920:Venture "Extended Edition, Very Large"
315:Executive computer, which bundled the
18:
1213:Microsoft Excel: 1,048,576 row limit;
963:Example of an analogous European CSV/
617:OKF frictionless tabular data package
7:
387:, in an attempt to enhance CSV with
2010:"Documentation: 14: F.14. file_fdw"
1219:Apple Numbers: 1,000,000 row limit;
1178:offer the option to express CSV or
239:using a character encoding such as
160:The CSV file format is one type of
93:multi-platform, serial data streams
2049:"Understanding CSV and row limits"
1066:'/home/wikipedia/file.csv'
300:(level H extended) compiler under
75:public.comma-separated-values-text
71:Uniform Type Identifier (UTI)
14:
1439:from the original on 26 July 2023
1429:"Which are the available formats"
1393:from the original on 1 April 2021
1319:Shafranovich, Y. (October 2005).
476:Databases that include multiple
34:
25:
2083:from the original on 2016-12-13
981:Some applications use CSV as a
580:be quoted (with double quotes).
162:delimiter-separated file format
1907:"CSV on the Web Working Group"
1483:"CSV - Comma Separated Values"
1240:, etc.): no row or cell limit;
461:. They work just as well with
399:in December of the same year.
376:describing the application of
265:with the records divided into
16:File format used to store data
1:
1654:Fortran 77 Language Reference
1081:saves the content of a table
508:Demographic and Health Survey
1414:IBM DB2 Administration Guide
1182:as an internal table format.
84:public.delimited-values-text
551:RFC 4180 and MIME standards
434:to open the file expecting
293:by more than a decade: the
145:data (numbers and text) in
2380:
2354:Delimiter-separated format
1264:Delimiter-separated values
904:Venture "Extended Edition"
247:character encodings (e.g.
2332:
1968:"Documentation: 14: COPY"
1931:CSV on the Web Repository
1092:Many utility programs on
632:W3C tabular data standard
623:Open Knowledge Foundation
393:drafts of recommendations
33:
24:
2364:Spreadsheet file formats
2012:. PostgreSQL. 2022-02-10
1991:. PostgreSQL. 2022-02-10
1772:sparql11-results-csv-tsv
1096:-style systems (such as
1087:/home/wikipedia/file.csv
465:character sets (such as
137:to separate values, and
59:Internet media type
1893:Frictionless Data Specs
1875:Frictionless Data Specs
1205:Software and row limits
983:data interchange format
829:processing CSV files."
695:terminated by newlines.
391:, publicized the first
1871:"Tabular Data Package"
1292:invisible comma U+2063
1228:Text Editors (such as
941:air, moon roof, loaded
526:nodes within a single
426:text file that uses a
353:one—was in 2005, with
123:Comma-separated values
20:Comma-separated values
1195:programming languages
680:data format that has
504:Statistical databases
403:General functionality
80:UTI conformation
2031:"EmacsWiki: Csv Nav"
1945:(W3C Recommendation)
1361:"commaSeparatedText"
1284:Substitute character
1254:Tab-separated values
1145:foreign-data wrapper
1029:Relational databases
799:"1997","Ford","E350"
664:registered with the
512:Statistical analysis
361:, defining CSV as a
1955:Shafranovich (2005)
1846:Creativyst (2010),
1650:"List-Directed I/O"
1387:Creativyst Software
1269:Delimiter collision
977:Application support
413:relational database
372:published RFC
21:
1279:Simple Data Format
1274:Flat-file database
831:1997, "Ford" ,E350
700:character encoding
291:personal computers
99:Container for
47:Filename extension
2341:
2340:
2035:www.emacswiki.org
1528:pandas.pydata.org
1463:Microsoft Support
1199:decimal separator
1126:native or foreign
1085:to a file called
1013:Apache OpenOffice
948:
947:
684:separated by the
363:MIME Content Type
202:database programs
133:format that uses
120:
119:
2371:
2298:Protocol Buffers
2120:
2113:
2106:
2097:
2091:
2089:
2088:
2060:
2059:
2057:
2055:
2045:
2039:
2038:
2027:
2021:
2020:
2018:
2017:
2006:
2000:
1999:
1997:
1996:
1985:
1979:
1978:
1976:
1975:
1964:
1958:
1952:
1946:
1940:
1934:
1928:
1922:
1921:
1919:
1918:
1903:
1897:
1896:
1885:
1879:
1878:
1867:
1861:
1860:
1859:
1857:
1852:, creativyst.com
1842:
1836:
1835:
1833:
1831:
1821:
1815:
1814:
1812:
1810:
1798:
1796:10.17487/RFC7111
1781:
1775:
1768:
1762:
1761:
1759:
1757:
1745:
1743:10.17487/RFC4180
1728:
1722:
1721:
1719:
1717:
1707:
1701:
1700:
1698:
1696:
1685:
1679:
1678:
1676:
1674:
1664:
1658:
1657:
1646:
1640:
1639:
1634:
1632:
1626:
1616:
1610:
1609:
1607:
1605:
1594:
1588:
1587:
1585:
1584:
1569:
1563:
1562:
1560:
1559:
1544:
1538:
1537:
1535:
1534:
1520:
1514:
1513:
1511:
1509:
1499:
1493:
1492:
1490:
1489:
1479:
1473:
1472:
1470:
1469:
1455:
1449:
1448:
1446:
1444:
1425:
1419:
1418:
1409:
1403:
1402:
1400:
1398:
1379:
1373:
1372:
1357:
1348:
1347:
1338:
1336:10.17487/RFC4180
1316:
1170:
1169:
1166:
1163:
1158:
1157:
1154:
1151:
1138:LibreOffice Calc
1088:
1084:
1080:
1079:
1076:
1073:
1070:
1067:
1064:
1061:
1058:
1055:
1052:
1049:
1046:
1043:
1038:
1022:LibreOffice Calc
1009:LibreOffice Calc
1003:including Apple
987:interoperability
861:
767:
766:
763:
760:
757:
754:
751:
748:
745:
742:
739:
736:
733:
730:
727:
724:
529:
525:
450:(for example in
444:escape character
389:formal semantics
188:CSV is a common
65:
53:
38:
29:
22:
2379:
2378:
2374:
2373:
2372:
2370:
2369:
2368:
2344:
2343:
2342:
2337:
2328:
2210:
2130:
2124:
2086:
2084:
2071:
2068:
2066:Further reading
2063:
2053:
2051:
2047:
2046:
2042:
2029:
2028:
2024:
2015:
2013:
2008:
2007:
2003:
1994:
1992:
1987:
1986:
1982:
1973:
1971:
1966:
1965:
1961:
1953:
1949:
1941:
1937:
1929:
1925:
1916:
1914:
1905:
1904:
1900:
1887:
1886:
1882:
1869:
1868:
1864:
1855:
1853:
1845:
1843:
1839:
1829:
1827:
1823:
1822:
1818:
1808:
1806:
1783:
1782:
1778:
1769:
1765:
1755:
1753:
1730:
1729:
1725:
1715:
1713:
1709:
1708:
1704:
1694:
1692:
1687:
1686:
1682:
1672:
1670:
1666:
1665:
1661:
1648:
1647:
1643:
1630:
1628:
1624:
1618:
1617:
1613:
1603:
1601:
1596:
1595:
1591:
1582:
1580:
1577:www.adaltas.com
1571:
1570:
1566:
1557:
1555:
1546:
1545:
1541:
1532:
1530:
1522:
1521:
1517:
1507:
1505:
1501:
1500:
1496:
1487:
1485:
1481:
1480:
1476:
1467:
1465:
1457:
1456:
1452:
1442:
1440:
1427:
1426:
1422:
1411:
1410:
1406:
1396:
1394:
1381:
1380:
1376:
1359:
1358:
1351:
1318:
1317:
1304:
1300:
1250:
1207:
1174:Databases like
1167:
1164:
1161:
1155:
1152:
1149:
1086:
1082:
1077:
1074:
1071:
1068:
1065:
1062:
1059:
1056:
1053:
1050:
1047:
1044:
1041:
1036:
1017:Microsoft Excel
991:internal format
985:to enhance its
979:
971:
961:
955:
940:
859:
854:
851:
844:
838:
832:
825:
818:
812:
806:
800:
782:
764:
761:
758:
755:
752:
749:
746:
743:
740:
737:
734:
731:
728:
725:
722:
654:
634:
619:
553:
541:byte order mark
536:
534:Standardization
527:
523:
486:object-oriented
405:
397:recommendations
287:
218:
186:
178:Microsoft Excel
63:
41:
17:
12:
11:
5:
2377:
2375:
2367:
2366:
2361:
2356:
2346:
2345:
2339:
2338:
2333:
2330:
2329:
2327:
2326:
2321:
2316:
2311:
2305:
2300:
2295:
2290:
2285:
2280:
2275:
2270:
2269:
2268:
2258:
2253:
2248:
2243:
2238:
2237:
2236:
2226:
2220:
2218:
2212:
2211:
2209:
2208:
2203:
2198:
2193:
2188:
2183:
2178:
2177:
2176:
2171:
2166:
2164:Web Encryption
2156:
2151:
2146:
2140:
2138:
2136:Human readable
2132:
2131:
2125:
2123:
2122:
2115:
2108:
2100:
2094:
2093:
2067:
2064:
2062:
2061:
2040:
2022:
2001:
1980:
1959:
1947:
1935:
1923:
1898:
1880:
1862:
1837:
1816:
1776:
1763:
1723:
1702:
1680:
1659:
1641:
1611:
1589:
1564:
1539:
1515:
1494:
1474:
1450:
1420:
1404:
1374:
1349:
1301:
1299:
1296:
1295:
1294:
1288:Null character
1281:
1276:
1271:
1266:
1261:
1256:
1249:
1246:
1245:
1244:
1241:
1226:
1223:
1220:
1217:
1214:
1206:
1203:
1191:
1190:
1183:
1172:
1141:
1122:
1121:
1090:
1025:
978:
975:
969:
959:
952:
946:
945:
942:
937:
936:Grand Cherokee
934:
931:
927:
926:
923:
921:
918:
915:
911:
910:
907:
905:
902:
899:
895:
894:
891:
888:
885:
882:
878:
877:
874:
871:
868:
865:
858:
855:
853:
852:
849:
845:
842:
839:
836:
833:
830:
826:
823:
819:
816:
813:
810:
807:
804:
801:
798:
783:
781:1997,Ford,E350
780:
773:
714:
711:
707:
696:
682:fields/columns
673:
653:
650:
633:
630:
618:
615:
599:
598:
588:
581:
574:
567:
564:
552:
549:
535:
532:
528:<parent>
404:
401:
286:
283:
278:
277:
274:
263:
260:
217:
214:
185:
182:
118:
117:
114:
108:
107:
101:
95:
94:
91:
90:Type of format
87:
86:
81:
77:
76:
73:
67:
66:
61:
55:
54:
49:
43:
42:
39:
31:
30:
15:
13:
10:
9:
6:
4:
3:
2:
2376:
2365:
2362:
2360:
2357:
2355:
2352:
2351:
2349:
2336:
2331:
2325:
2322:
2320:
2317:
2315:
2312:
2309:
2306:
2304:
2301:
2299:
2296:
2294:
2293:Property list
2291:
2289:
2286:
2284:
2281:
2279:
2276:
2274:
2271:
2267:
2264:
2263:
2262:
2259:
2257:
2254:
2252:
2249:
2247:
2244:
2242:
2239:
2235:
2232:
2231:
2230:
2227:
2225:
2222:
2221:
2219:
2217:
2213:
2207:
2204:
2202:
2199:
2197:
2194:
2192:
2189:
2187:
2184:
2182:
2181:Property list
2179:
2175:
2174:Web Signature
2172:
2170:
2167:
2165:
2162:
2161:
2160:
2157:
2155:
2152:
2150:
2147:
2145:
2142:
2141:
2139:
2137:
2133:
2128:
2127:Data exchange
2121:
2116:
2114:
2109:
2107:
2102:
2101:
2098:
2082:
2078:
2074:
2070:
2069:
2065:
2050:
2044:
2041:
2036:
2032:
2026:
2023:
2011:
2005:
2002:
1990:
1984:
1981:
1969:
1963:
1960:
1956:
1951:
1948:
1944:
1939:
1936:
1932:
1927:
1924:
1912:
1908:
1902:
1899:
1894:
1890:
1889:"CSV Dialect"
1884:
1881:
1876:
1872:
1866:
1863:
1851:
1850:
1841:
1838:
1826:
1820:
1817:
1805:
1802:
1797:
1792:
1788:
1787:
1780:
1777:
1773:
1767:
1764:
1752:
1749:
1744:
1739:
1735:
1734:
1727:
1724:
1712:
1706:
1703:
1690:
1684:
1681:
1669:
1663:
1660:
1655:
1651:
1645:
1642:
1638:
1623:
1622:
1615:
1612:
1600:. Edoceo, Inc
1599:
1593:
1590:
1578:
1574:
1568:
1565:
1553:
1549:
1543:
1540:
1529:
1525:
1519:
1516:
1504:
1498:
1495:
1484:
1478:
1475:
1464:
1460:
1454:
1451:
1438:
1434:
1430:
1424:
1421:
1416:
1415:
1408:
1405:
1392:
1388:
1384:
1378:
1375:
1370:
1366:
1362:
1356:
1354:
1350:
1345:
1342:
1337:
1332:
1329:. p. 1.
1328:
1324:
1323:
1315:
1313:
1311:
1309:
1307:
1303:
1297:
1293:
1289:
1285:
1282:
1280:
1277:
1275:
1272:
1270:
1267:
1265:
1262:
1260:
1257:
1255:
1252:
1251:
1247:
1242:
1239:
1235:
1231:
1227:
1224:
1221:
1218:
1215:
1212:
1211:
1210:
1204:
1202:
1200:
1196:
1188:
1184:
1181:
1177:
1173:
1146:
1142:
1139:
1135:
1131:
1130:
1129:
1127:
1119:
1115:
1111:
1107:
1103:
1099:
1095:
1091:
1035:provides the
1034:
1030:
1026:
1023:
1018:
1014:
1010:
1006:
1002:
999:
998:
997:
994:
992:
988:
984:
976:
974:
968:
966:
958:
951:
943:
938:
935:
932:
929:
928:
924:
922:
919:
916:
913:
912:
908:
906:
903:
900:
897:
896:
892:
890:ac, abs, moon
889:
886:
883:
880:
879:
875:
872:
869:
866:
863:
862:
856:
846:
840:
834:
827:
820:
814:
808:
802:
796:
792:
788:
784:
778:
774:
771:
719:
715:
712:
708:
705:
701:
697:
694:
690:
687:
683:
679:
675:
674:
672:
669:
667:
663:
659:
651:
649:
647:
643:
639:
631:
629:
626:
624:
616:
614:
612:
608:
604:
596:
592:
589:
586:
582:
579:
575:
572:
568:
565:
562:
561:
560:
558:
550:
548:
544:
542:
533:
531:
524:<child>
521:
516:
513:
509:
505:
501:
499:
495:
492:created with
491:
487:
483:
479:
474:
472:
468:
464:
460:
459:character set
455:
453:
449:
445:
441:
437:
433:
429:
425:
420:
416:
414:
410:
402:
400:
398:
394:
390:
386:
381:
379:
378:URI fragments
375:
371:
366:
364:
360:
356:
352:
351:
346:
345:
339:
337:
333:
327:
325:
324:punched cards
320:
318:
314:
309:
307:
303:
299:
296:
292:
284:
282:
275:
272:
269:separated by
268:
264:
261:
258:
254:
250:
246:
242:
238:
234:
233:
232:
230:
229:specification
226:
222:
216:Specification
215:
213:
210:
205:
203:
199:
195:
191:
190:data exchange
183:
181:
179:
173:
171:
167:
163:
158:
156:
152:
148:
144:
140:
136:
132:
128:
124:
115:
113:
109:
105:
102:
100:
96:
92:
88:
85:
82:
78:
74:
72:
68:
62:
60:
56:
50:
48:
44:
37:
32:
28:
23:
2359:Open formats
2148:
2085:. Retrieved
2052:. Retrieved
2043:
2034:
2025:
2014:. Retrieved
2004:
1993:. Retrieved
1983:
1972:. Retrieved
1970:. PostgreSQL
1962:
1950:
1938:
1926:
1915:. Retrieved
1913:CSV WG. 2013
1901:
1892:
1883:
1874:
1865:
1854:, retrieved
1848:
1840:
1828:. Retrieved
1819:
1809:December 22,
1807:. Retrieved
1785:
1779:
1766:
1756:December 22,
1754:. Retrieved
1732:
1726:
1714:. Retrieved
1705:
1695:December 11,
1693:. Retrieved
1683:
1673:December 11,
1671:. Retrieved
1662:
1653:
1644:
1636:
1629:, retrieved
1620:
1614:
1602:. Retrieved
1592:
1581:. Retrieved
1579:. 2020-07-23
1576:
1567:
1556:. Retrieved
1554:. 2021-09-15
1551:
1542:
1531:. Retrieved
1527:
1518:
1506:. Retrieved
1497:
1486:. Retrieved
1477:
1466:. Retrieved
1462:
1453:
1441:. Retrieved
1432:
1423:
1413:
1407:
1395:. Retrieved
1386:
1377:
1364:
1321:
1208:
1192:
1144:
1134:Spreadsheets
1123:
1001:Spreadsheets
995:
990:
980:
972:
962:
956:
949:
794:
790:
786:
769:
693:records/rows
670:
655:
636:In 2013 the
635:
627:
620:
610:
606:
602:
600:
594:
590:
584:
577:
570:
569:Each record
554:
545:
537:
517:
502:
482:hierarchical
475:
456:
440:double quote
421:
417:
406:
396:
392:
382:
367:
348:
342:
340:
328:
321:
310:
288:
279:
219:
206:
187:
184:Applications
174:
159:
126:
122:
121:
2288:MessagePack
2283:FlatBuffers
2273:Cap'n Proto
1933:(on GitHub)
1631:February 5,
1503:"CSV Files"
1176:Apache Hive
873:Description
750:','
729:','
652:Basic rules
520:foreign key
227:proposes a
198:spreadsheet
194:proprietary
2348:Categories
2087:2016-12-12
2016:2022-03-04
1995:2022-03-04
1974:2024-05-12
1917:2015-04-22
1583:2023-08-16
1558:2023-08-16
1533:2023-08-16
1488:2017-12-02
1468:2023-08-16
1298:References
1136:including
1033:PostgreSQL
939:MUST SELL!
785:Any field
772:MIME type.
718:characters
704:byte order
576:Any field
454:Central).
446:such as a
332:byte-order
306:FORTRAN 77
271:delimiters
243:, various
237:plain text
147:plain text
2169:Web Token
1830:March 23,
1552:ByteScout
1443:22 August
1397:22 August
1369:Apple Inc
1165:EXTENSION
689:character
678:delimited
676:CSV is a
662:MIME type
646:semantics
557:MIME type
490:documents
478:relations
448:backslash
424:delimited
422:CSV is a
336:word size
317:SuperCalc
257:Shift JIS
170:extension
131:text file
2319:uuencode
2081:Archived
1656:, Oracle
1437:Archived
1433:Eurostat
1391:Archived
1248:See also
1234:TextEdit
1168:file_fdw
1083:articles
1057:articles
1027:Various
944:4799.00
925:5000.00
909:4900.00
893:3000.00
770:text/csv
642:metadata
621:In 2011
409:relation
383:In 2015
368:In 2014
344:de facto
139:newlines
116:RFC 4180
112:Standard
104:database
64:text/csv
2256:Bencode
2154:EDIFACT
2129:formats
2054:Feb 28,
1856:May 24,
1716:June 4,
1604:June 4,
1508:June 4,
1230:WordPad
1180:.csv.gz
1153:FOREIGN
1005:Numbers
857:Example
777:locales
463:Unicode
350:de jure
313:Osborne
298:Fortran
285:History
245:Unicode
143:tabular
129:) is a
2308:Cyphal
2303:Thrift
2266:UBJSON
2251:Base64
2246:Base32
2216:Binary
1691:. 1983
1417:. IBM.
1162:CREATE
1150:CREATE
1072:FORMAT
1048:SELECT
1015:Calc.
1011:, and
876:Price
791:quoted
710:lines.
585:should
571:should
471:UTF-16
452:Sybase
357:
302:OS/360
267:fields
253:EBCDIC
223:
209:Pandas
155:fields
151:record
135:commas
2229:ASN.1
2191:Rebol
1625:(PDF)
1187:emacs
1156:TABLE
1132:Some
1102:paste
917:Chevy
901:Chevy
870:Model
686:comma
467:UTF-8
436:caret
432:Excel
428:comma
411:in a
255:, or
249:UTF-8
241:ASCII
2324:yEnc
2310:DSDL
2278:CBOR
2261:BSON
2241:Avro
2206:YAML
2196:TOML
2159:JSON
2144:Atom
2056:2021
1858:2010
1832:2016
1811:2020
1804:7111
1770:See
1758:2020
1751:4180
1718:2014
1697:2017
1675:2017
1633:2016
1606:2014
1510:2014
1445:2023
1399:2023
1344:4180
1327:IETF
1185:The
1159:and
1114:uniq
1110:sort
1106:join
1094:Unix
1054:FROM
1042:COPY
1037:COPY
933:Jeep
930:1996
914:1999
898:1999
887:E350
884:Ford
881:1997
867:Make
864:Year
795:must
691:and
666:IANA
658:IETF
644:and
595:must
494:HTML
374:7111
370:IETF
359:4180
334:and
225:4180
52:.csv
2314:XDR
2234:SMI
2224:AMF
2201:XML
2186:RDF
2149:CSV
2077:IBM
1911:W3C
1801:RFC
1791:doi
1748:RFC
1738:doi
1341:RFC
1331:doi
1238:Vim
1118:awk
1098:cut
1075:csv
965:DSV
789:be
787:may
765:255
759:256
744:ord
738:256
723:ord
638:W3C
611:(c)
607:(b)
603:(a)
578:may
498:XML
484:or
469:or
385:W3C
355:RFC
295:IBM
251:),
235:is
221:RFC
166:tab
127:CSV
2350::
2079:.
2075:.
2033:.
1909:.
1891:.
1873:.
1799:.
1789:.
1746:.
1736:.
1652:,
1635:,
1575:.
1550:.
1526:.
1461:.
1435:.
1431:.
1389:.
1385:.
1367:.
1363:.
1352:^
1339:.
1325:.
1305:^
1290:,
1286:,
1236:,
1232:,
1116:,
1112:,
1108:,
1104:,
1100:,
1063:TO
1007:,
993:.
741:..
702:,
668:.
648:.
591:If
496:,
2119:e
2112:t
2105:v
2090:.
2058:.
2037:.
2019:.
1998:.
1977:.
1920:.
1895:.
1877:.
1844:*
1834:.
1813:.
1793::
1760:.
1740::
1720:.
1699:.
1677:.
1608:.
1586:.
1561:.
1536:.
1512:.
1491:.
1471:.
1447:.
1401:.
1371:.
1346:.
1333::
1089:.
1078:)
1069:(
1060:)
1051:*
1045:(
762:+
756:*
753:)
747:(
735:*
732:)
726:(
259:,
125:(
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.