Open CSV File

Information, tips and instructions

Open CSV File

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:

  • Microsoft Excel (available on Windows and Mac OS)
  • Google Docs (available on any platform connected to the internet and capable of running Google Chrome internet browser or another compatible browser)
  • Microsoft Office Online (available on any platform connected to the internet and capable of running compatible browser)
  • EPS files are transferred over e-mail or internet using text/csv multipurpose internet mail extensions (MIME) type.

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.

Get more information about how to open CSV file.

Also check how to open SB2 file and open ODS file on Open File Database.

If you are not able to open file with certain file extension make sure to check if extension for the file is correct. It is possible that information in the file doesn't match file extension.

File Extension Info

CSV Quick Info
  Comma Separaed Values
MIME Type
  text/csv
Opens with
  Microsoft Excel
  Apple Numbers
  Google Docs
  Zip