CSV, Comma Separated Values File (.csv)

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
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
Advertisement