CSV is a Comma Separated Value file that holds plain text files including numbers and letters only. These files are used to exchange data between various applications. CSV is also known as Character Separated Values or Comma Delimited files. These files can be viewed with a text editor like Notepad or a spreadsheet program like Microsoft Excel.
The file extension is basically used to export and import data from the apps holding data in tables like MS Excel.
It is a highly compatible file extension, capable to read in every program, especially those that viewed through a spreadsheet program like MS Excel. It is popular to transfer data between databases. It is supported by a huge number of business, scientific and personal apps. The file extension is also useful to export data saved in proprietary format. For example, you are allowed to export all necessary contacts from an email client to CSV. The transferred data can now easily be shared or import to another email client or an address organizer.