CSV files contain data which are stored in the so-called Comma Seperated Values Format, ie comma separated values format. The CSV format is mainly used to exchange data between different databases or spreadsheets.
Each line of a CSV file stands for a record, while the values for each field (database) or cell (spreadsheet) are separated by commas in this line. Cell titles (eg for Excel) can also be specified, but there may also be problems with the exchange.
Especially when importing a CSV file into an already existing database or table, the order of the values should be agreed, as otherwise the values may be written to the wrong cells or data fields.
CSV files can be opened and edited with any text editor. In addition, CSV files can be imported from Microsoft Excel, OpenOffice Calc and also many database programs such as Mysql or Oracle and also exported. For some programs you can also specify the delimiter when importing or exporting (eg semicolon, dot)