CSV (Comma Separated Values File)
The CSV Spreadsheet file format
CSV (Comma-separated values or character-separated values) files are flat files which store tabular data through numbers and text in a plain-text form. It is used to collect data from tables to be transported as input to other table-oriented applications. Microsoft Excel, for example, can read these files. CSV files are used by various spreadsheet programs though. Its simplicity and high support levels allow consumers, businesses, and scientific applications to utilize this file extension. This style of data entry predates PC’s by over 10 years and is capable of increased correctness of data, especially when used alongside the punched cards systems of data entry.
Technical details of CSV files
Different values are separated in tables through a series of ASCII (American Standard Code for Information Interchange) text lines. From there, they can be organized to where each column value is separated from other columns by a comma (or other separator character). New rows are created by starting a new line. CSV represents one style of delimited text files, meaning they use commas (or other defined character) to separate values. Some such separators include commas, back slash, or forward slash. It does, however, differ from other related programs in which it used a double quote character surrounding fields which contain reserved characters. This allows data to be transferred between applications easily.
More information about the CSV file format
File extension | .csv |
File category | Spreadsheet |
Example file |
Download example.csv file (0.79 KiB) |
Associated programs | Microsoft Excel Microsoft Works Corel Quattro Pro Apache OpenOffice LibreOffice Microsoft Notepad Libre Office MobiSystems OfficeSuite Pro 7 |
Useful links | More information on CSV |
Developer | Microsoft |