Information about the .csv (csv) file type

This is one of two possibilities that we have on file for the .csv file extension, follow this link to view both possibilities.

Below is all the information we have available on file about the .csv (csv) file type.

Comma Separated Values file.

A .csv file is a text editable file, commonly referred to as a CSV file, that contains one record per line with field values for each record separated by commas. A common format for exchanging data between database or spreadsheet systems.

CSV files may have the first line in the file specifying the field names rather than data. However, this is not guaranteed and CSV files do not need to have field names in the first row - although field names must be in the first row if they are included at all.

Typically text fields are quoted, meaning that a text field is surrounded by double quotes. This allows a text field to contain a comma, which would otherwise be treated as a field separator. Be aware that text fields do not need to be quoted, although if they are not quoted then they cannot (or should not) contain a comma as the comma will be interpreted as a field separator.

Each row in the CSV file should contain the same number of fields.

Where this is available we would like to include file format information on .csv files, as well as information on how to view or open files of type .csv. If you know of any information which we have missed then please let us know.