comma separated values

(redirected from Comma-separated values)
Also found in: Acronyms, Wikipedia.

comma separated values

(file format)
(CSV) A file format used as a portable representation of a database. Each line is one entry or record and the fields in a record are separated by commas. Commas may be followed by arbitrary space and/or tab characters which are ignored. If field includes a comma, the whole field must be surrounded with double quotes.

CSV

(1) See computer system validation and software validation.

(2) (Comma Separated Values) Also called "comma delimited," CSV is a text-based data record format that separates fields with a comma and ends with a line break (although a few implementations support line breaks within the record). Widely used as a data exchange format, spreadsheets as well as many other business applications can read and write comma delimited files. The text may be surrounded with quotes as follows:

  Pat Smith,Bath,PA,18014
  "Pat Smith","Bath","PA","18014"

  Ken Salazar,New York,NY,10001
  "Ken Salazar","New York","NY","10001"


Commas and Double Quotes
If the data contain commas, those fields must be quoted. If the data contain double quotes, the field must be quoted and two double quotes must be used:

text:  the "Black Friday" discount  CSV:  "the ""Black Friday"" discount"


Decimal Commas
Europe, Russia, Central and South America and some African countries use a comma for a decimal point, in which case, the CSV format would use a tab character or semicolon instead of the comma.

  Pat Smith;Bath,PA;18014
  Ken Salazar;New York;NY;10001
References in periodicals archive ?
• The new Delimited - Microsoft Excel Format output type outputs to a comma-separated values (CSV) file but uses Excel formatting so things like leading zeros are preserved when the file is opened in Excel.
--Export a list of documents as hypertext markup language or as a Microsoft Excel spreadsheet in comma-separated values format.
Millennium allows reports to be exported as comma-separated values (.csv), which can be saved anywhere and are easily imported into a spreadsheet program.
Finally actual image and temperature distribution can be hold a saved as a CSV (comma-separated values) file on standard CF memory card for further evaluation in the computer.
The most likely transfer mechanism would be comma-separated values (CSV) files.