A CSV file is a way to collect the data from any table so that it can be conveyed as input to another table-oriented application such as a relational database application. Microsoft Excel, a leading spreadsheet or relational database application, can read CSV files. A CSV file is sometimes referred to as a flat file.
In computers, a CSV file contains the different values in a table as a series of ASCII (American Standard Code for Information Interchange) text lines which are then organised so that each column value is separated by a comma from the next columns value and each row starts a new line. CSV is one example of a delimited text file, which uses a comma to separate values (many other implementations of CSV allow different seperators such as back or forward slash to be used). However CSV differs from other delimiter separated file formats in using a double quote character around fields that contain reserved characters (such as commas or newlines). The benefit of this approach is that it allows the transfer of data across different applications.
The CSV file format is very simple and supported by almost all spreadsheets and database management systems
ODS was a format developed by Sun Microsystems and is used by the OpenOffice and StarOffice suites. The ODS file extension is given to files that are created with the calc program - a spreadsheet application which is XML based but contains spreadsheets, charts and other graphical elements held in rows and columns much like Microsoft Excel.
The OpenDocument Format (ODF) is an XML-based file format for representing electronic documents such as spreadsheets, charts, presentations and word processing documents. The standard was developed by the OASIS (Organization for the Advancement of Structured Information Standards), and it is free and open format. OpenDocument format supports document representation: A single XML document and as a collection of several subdocuments within a package.
Microsoft Office 2007 Microsoft Office 2010 OpenOffice Calc