Comma-separated Values - Usage


CSV is a common, relatively simple file 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 proprietary and/or undocumented) formats. This works because so many programs support some variation of CSV at least as an alternative import/export format.

For example, a user may need to transfer information from a database program that stores data in a proprietary format, to a spreadsheet that uses a completely different format. The database program most likely can export its data as "CSV"; the exported CSV file can then be imported by the spreadsheet program.

"CSV" is not a single, well-defined format (although see RFC 4180 for one definition that is commonly used). Rather, in practice the term "CSV" refers to any file that:

  1. is plain text using a character set such as ASCII, Unicode, EBCDIC, or Shift JIS,
  2. consists of records (typically one record per line),
  3. with the records divided into fields separated by delimiters (typically a single reserved character such as comma, semicolon, or tab; sometimes the delimiter may include optional spaces),
  4. where every record has the same sequence of fields.

Within these general constraints, many variations are in use. Therefore "CSV" files are not entirely portable. Nevertheless, the variations are fairly small, and many implementations allow users to glance at the file (which is feasible because it is plain text), and then specify the delimiter character(s), quoting rules, etc. If a particular CSV file's variations fall outside what a particular receiving program supports, it is often feasible to examine and edit the file by hand or via simple programming to fix the problem. Thus CSV files are, in practice, quite portable.

Read more about this topic:  Comma-separated Values

Other articles related to "usage":

Hyphen - Usage in English
... For Wikipedia's own standards for hyphen usage, see WikipediaManual of Style#Hyphens Hyphens are mostly used to break single words into parts, or to join ordinarily separate words ... different manuals of style prescribe different usage guidelines ...
Usage - History
... According to Jeremy Butterfield, "The first person we know of who made usage refer to language was Daniel Defoe, at the end of the seventeenth century" ...
Nancy Mitford - Biography - U and Non-U
... to popularise the "U", or upper-class, and "non-U" classification of linguistic usage and behaviour (see U and non-U English) — although this is something she saw as a tease and she certainly ... have frequently portrayed her as the snobbish inventor and main preserver of this usage ... as an example of upper-class linguistic usage ...
Gong - Other Uses
... In older Javanese usage and in modern Balinese usage, gong is used to identify an ensemble of instruments ... In contemporary central Javanese usage, the term gamelan is preferred and the term gong is reserved for the gong ageng, the largest instrument of the type, or for surrogate instruments such ... In Balinese usage, gong refers to Gamelan Gong Kebyar ...

Famous quotes containing the word usage:

    Pythagoras, Locke, Socrates—but pages
    Might be filled up, as vainly as before,
    With the sad usage of all sorts of sages,
    Who in his life-time, each was deemed a bore!
    The loftiest minds outrun their tardy ages.
    George Gordon Noel Byron (1788–1824)

    I am using it [the word ‘perceive’] here in such a way that to say of an object that it is perceived does not entail saying that it exists in any sense at all. And this is a perfectly correct and familiar usage of the word.
    —A.J. (Alfred Jules)

    ...Often the accurate answer to a usage question begins, “It depends.” And what it depends on most often is where you are, who you are, who your listeners or readers are, and what your purpose in speaking or writing is.
    Kenneth G. Wilson (b. 1923)