As part of Microsoft's 2007 Office suite of products another open XML document type was introduced. This time in the Excel sphere, Excel is known world wide. It is a powerful tool you can use to create and format spreadsheets, graphs, do complex maths and much more. You are able to create diverse spreadsheets with multiple workbooks, formulae, and various data sources. Files can be saved in the XLSX format, which is based on the Open XML format and uses ZIP compression for smaller file sizes.
XLSX improves file and data management and data recovery. XLSX extends what is possible with the binary files of earlier versions. Any application that supports XML can access and work with data in the new file format. The application does not need to be a Microsoft product it can be any application. Users can also use standard transformations to extract or repurpose the data. In addition, security concerns are drastically reduced because the information is stored in XML, which is essentially plain text. Thus, the data can pass through corporate firewalls without hindrance.
Microsoft Excel 2007 OpenOffice OxygenOffice Progessional (Linux)
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