Home  /  File formats  /  csv

CSV file format

Extension.csv
Categorydocuments
Programs
Microsoft Excel
Microsoft Works
Corel Quattro Pro
Apache OpenOffice
LibreOffice
Microsoft Notepad
Libre Office
MobiSystems OfficeSuite Pro 7
Description.csv The .csv (Comma-Separated Values) format is a plain text format used for representing tabular data. Each line in the file corresponds to a row in the table, and columns in a row are separated by commas. This format is widely supported by many applications, including spreadsheet and database software. It's commonly used for exchanging data between different programs and for exporting and importing large amounts of data due to its simplicity and wide compatibility.
Technical detailsThe `.csv` (Comma-Separated Values) format is a simple text format for tabular data, with each line representing a table row and fields separated by a delimiter, typically a comma, though alternatives like semicolons or tabs are also used. As a plain text format, it's universally compatible and easy to edit. The structure consists of delimited rows and fields without a standard schema, treating all data as strings, with interpretation dependent on the importing application. CSV files may include optional headers and support various text encodings like UTF-8 and ASCII. Special handling is needed for fields containing delimiters, usually by enclosing them in quotes and escaping internal quotation marks. Due to its simplicity and flexibility, CSV is favored for basic data exchange and import/export tasks across different programs, despite not being suitable for complex or relational data structures. Its broad compatibility with common software, including spreadsheet and database programs, maintains its popularity for straightforward data operations.
MIME type
text/comma-separated-values