English
Home   /   File format   /   csv

CSV file format

File extension
.csv
File category
Description
CSV – is a unique text format. The data inside of which are separated by commas—developed in the early 70-ies of the XX century to import various table information and transfer bulk information between databases in text format. Each line of the file acts as one row of the database. Using the spreadsheet application, CSV files can be organized into cells and added to the appropriate database. Commas separate the parameters of each column. If there are reserved symbols (for example, a semicolon or a new line), double quotes play the separator role. This allows you to transfer information between different programs freely. CSV, in some cases, are сalled flat files. They can be opened by most editors able to work with tables and texts, including both authentic Excel and open source utilities like Apache Open Office and Libre Office.
Technical details
On personal computers, the CSV extension includes many values represented as ASCII tables. In this case, the text strings are clearly organized, so all values are separated by commas or double quotes (if there are reserved symbols). The use of different delimiters allows the availability of unequal encoding.
Programs
Microsoft Excel
Microsoft Works
Corel Quattro Pro
Apache OpenOffice
LibreOffice
Microsoft Notepad
Libre Office
MobiSystems OfficeSuite Pro 7
Developer
Microsoft
MIME type
text/comma-separated-values