What format is csv file?

csv is a comma-separated value file format, which can be opened with the computer's own Notepad or Excel. The csv file stores table data in the form of plain text. Plain text means that the file is a sequence of characters and does not contain necessary Data that is interpreted like binary numbers.

#The operating environment of this article: Windows 7 system, Dell G3 computer.

csv is a comma-separated value file format, which can be opened with the computer's own notepad or excel.

csv files store tabular data (numbers and text) in plain text. Plain text means that the file is a sequence of characters and contains no data that must be interpreted like a binary number.

SV files are composed of any number of records, separated by some kind of newline character; each record is composed of fields, and the separator between fields is other characters or strings, the most common ones are commas or commas. Symbol.

Normally, all records have exactly the same sequence of fields. Usually these are plain text files. It is recommended to use WORDPAD or Notepad to open it, and then save a new file first and then open it with EXCEL. This is also one of the methods.

Extended information

The most widespread application of CSV files is to transfer tabular data between programs that themselves operate on incompatible formats Operational (often in proprietary and/or unspecified formats). Because a large number of programs support some variant of CSV, at least as an optional input/output format.

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

If you want to learn more about programming, please pay attention to the php training column!

The above is the detailed content of What format is csv file?. For more information, please follow other related articles on the PHP Chinese website!