The .xlr file extension relates to spreadsheets created by Microsoft Works suite. Microsoft Works provided a less expensive and more simplistic spreadsheet program than Microsoft Excel. Often bundled with new PCs, the suite of products was discontinued in 2008. The file type was particularly unpopular due to a lack of compatability with other programs, including Microsoft Excel.
An .xlr file allows rows and columns to be defined in a file within Microsoft Works. Other features commonly found in other spreadsheet applications are also found in .wks files including formulas, charts and graphs. Although Excel 2003 supports .wks files, Excel 2007 does not support them.
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)