Comma-separated values

Comma-separated values
Filename extension.csv
Internet media typetext/csv[1]
Uniform Type Identifier (UTI)public.comma-separated-values-text[2]
UTI conformationpublic.delimited-values-text[2]
Type of formatmulti-platform, serial data streams
Container fordatabase information organized as field separated lists
StandardRFC 4180

Comma-separated values (CSV) is a text data format that uses commas to separate delimiter-separated values, and newlines to separate records. CSV data stores tabular data (numbers and text) in plain text, where each line typically represents one data record. Each record consists of the same number of fields, and these are separated by commas. If the field delimiter itself may appear within a field, fields can be surrounded with quotation marks.[3]

CSV is widespread in data applications and is widely supported by a variety of software, including common spreadsheet applications such as Microsoft Excel.[4] Benefits cited in favor of CSV include human readability and the simplicity of the format.[5]

The CSV file format was formalized in the 2005 technical standard RFC 4180, which defines the MIME type "text/csv" for the handling of text-based fields.

  1. ^ Cite error: The named reference rfc4180 was invoked but never defined (see the help page).
  2. ^ a b "commaSeparatedText". Apple Developer Documentation: Uniform Type Identifiers. Apple Inc. Archived from the original on 2023-05-22. Retrieved 2023-05-22.
  3. ^ "CSV Comma Separated Value File Format - How To - Creativyst - Explored,Designed,Delivered.(sm)". Creativyst Software. Archived from the original on 1 April 2021. Retrieved 22 August 2023.
  4. ^ "Import or export text (.txt or .csv) files". Microsoft Support. Retrieved 2023-08-16.
  5. ^ "What is a CSV file: A comprehensive guide". flatfile.com. Retrieved 2024-10-28.
This article is issued from Wikipedia. The text is available under Creative Commons Attribution-Share Alike 4.0 unless otherwise noted. Additional terms may apply for the media files.