The Comma Separated Value (CSV) file format is a common structuring strategy for text format files. In CSV flies, each line in the file represents a row of data and, within each line of the file, the different data fields are separated from one another using a comma. Gnumeric handles CSV files through the text importer and exporter but this format is given its own definition in this document because it is such a common format.
Gnumeric will automatically open CSV format files separating each row into columns based on the presence of comma characters in the file. If the automatic import leads to any errors, these can generally be corrected by using the "Text Import (configurable)" file format instead. Selecting that file format will launch the Text Import druid which allows the user to import CSV format files while specifying in greater detail the settings of the import configuration parameters. See the section on importing text files or the section on exporting text files for an explanation of how to open or save CSV files through the Text Import druid.
| Name: | Comma Separated Value, CSV |
| Extensions: | .csv, .txt |
| Compatible Programs: | Many |
| Open / Save: | Both |
The CSV file format is only useful for the exchange of cell data and cannot be used for sheet objects like graphical plots. This file format cannot save the formatting of cell contents, backgrounds or borders.
Supported by the core Gnumeric program.
CSV files are simple text files where each row of the text file represents one row in the spreadsheet and where the cells within a row are separated from each other by a comma.
CSV files can be processed using any tool which operates on text files. The CSV format is also common as a format which can be opened by applications.
See the section on Text Formats