CSV file extension is used by files in comma separated values format. CSV files typically contain table information. First line of CSV file usually contains a table header and other lines contain table rows with data. Each line in CSV file consists of text strings delimited by commas. Each text string can contain any symbols except of the comma. If comma needs to be used inside the string, then string should be enclosed in quotes.
Simplicity of CSV format makes it great for cross platform data exchange. CSV file is frequently used on the internet by websites and web applications to export the data. When CSV file needs to be downloaded from the internet it is typically compressed using ZIP or GZIP application resulting in CSV.GZ or ZIP file. CSV file compression ratio is very high because it contains repeatable textual information.
Due to its simplicity you can open CSV file on any platform. CSV file are not binary thus it is possible to open them using any textual editor including Notepad on Windows, TextEdit on Mac OS and VIM on Unix/Linux. But viewing CSV file in text editor is not very efficient because this makes table information hard to read. To open CSV file it is much better to use specialized spreadsheet software including:
CSV files are frequently converted to the XLSX or XLS Microsoft Office file formats. XLSX format can contain significantly more spreadsheet related features but has limitation in software capability.
CSV Quick Info | |
---|---|
Comma Separaed Values | |
MIME Type | |
text/csv | |
Opens with | |
Microsoft Excel | |
Apple Numbers | |
Google Sheets | |
Microsoft Office Online |