About the Csv file format
- Name
- Comma Separated Values File
- Extension
- .csv
- Format
- Text
- Category
- Developer
- Developer
- Microsoft
- Description
- A CSV file is a comma separated values file commonly used by spreadsheet programs such as Microsoft Excel or OpenOffice Calc. It contains plain text data sets separated by commas with each new line in the CSV file representing a new database row and each database row consisting of one or more fields separated by a comma. CSV files are often opened by spreadsheet programs to be organized into cells or used for transferring data between databases.
- MIME Type
- text/csv
- Sample
- sample.csv
- Wikipedia
- .csv on Wikipedia
A Comma Separated Values (CSV) file is an established text file that separates values using a comma. All the lines in the CSV file serve as data record with fields which are separated by commas. The use of commas as field separators is the origin of the name Comma Separated Values File. The file stores tabular data in plain text with all lines having an equal number of fields. The CSV format file has not yet been fully developed.
Data that support the format allow users to have a preview of the first lines. However, there are file variations that differ with what a program supports, requiring you to edit or examine the file. Editing and examining files at this stage requires the use of text editor and scripting, respectively.
The plain text characters are not compatible with byte-order and word size. The CSV files human readable hence easily understood with no proper communication or documentation.
CSV files are best used in showing sequences of records that have similarities. The data uses unicode sets and comfortably translates from one character set to another. CSV files are used for information exchange in databases between machines of different caliber. They can be used with spreadsheets programs like Microsoft Excel and Google spreadsheets.
