Shulou(Shulou.com)06/02 Report--

This article mainly introduces csv refers to what format file, the article introduces in great detail, has a certain reference value, interested friends must read it!

Csv is a general, relatively simple comma-separated values file format, which is a plain text file used to store data; plain text means that an CSV file is a sequence of characters that does not contain data that must be interpreted like binary numbers.

CSV (comma separated values file format)

Comma-separated values (Comma-Separated Values,CSV, sometimes referred to as character-separated values, because delimiters can also be non-commas) whose files store table data (numbers and text) in plain text. Plain text means that the file is a sequence of characters and does not contain data that must be interpreted like binary numbers. An CSV file consists of any number of records, separated by some kind of newline character; each record consists of fields, the delimiters between the fields are other characters or strings, the most common being commas or tabs. Typically, all records have exactly the same field sequence. They are usually plain text files. It is recommended to use WORDPAD or notepad to open it, and then save the new file and then open it with EXCEL, which is also one of the ways.

There is no general standard for CSV file format, but there is a basic description in RFC 4180. The character encoding used is also not specified, but bitASCII is the most basic universal encoding.

CSV is a general and relatively simple file format, which is widely used by users, business, and science. The most widely used is to transfer tabular data between programs, which themselves operate on incompatible formats (often proprietary and / or irregular formats). Because many programs support some kind of CSV variant, at least as an alternative input / output format.

For example, a user may need to exchange information, from a database program that stores data in a private format to a spreadsheet with a completely different data format. Most likely, the database program can export the data as "CSV", and then the exported CSV file can be imported by the spreadsheet program.

"CSV" is not a single, well-defined format (although RFC 4180 has a commonly used definition). Therefore, in practice, the term "CSV" generally refers to any file that has the following characteristics:

Plain text, using a character set such as ASCII, Unicode, EBCDIC, or GB2312

Consists of records (typically one record per row)

Each record is separated into fields by a delimiter (typical delimiters have commas, semicolons, or tabs; sometimes delimiters can include optional spaces)

Each record has the same sequence of fields.

Under these conventional constraints, there are many CSV variants, so CSV files are not completely interoperable. However, these variations are very small, and there are many applications that allow users to preview the file (which is feasible because it is plain text), and then specify delimiters, escape rules, and so on. If the variation of a particular CSV file is too large to be supported by a particular receiver, it is often feasible to check and edit the file manually, or to fix the problem through a simple program. Therefore, in practice, the CSV file is still very convenient.

The above is all the contents of the article "what format file does csv refer to". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.