To use IBM Cognos product documentation, you must enable JavaScript in your browser.

Microsoft Excel Formats

IBM® Cognos® Business Intelligence can produce reports in Microsoft Excel spreadsheet software format.

The following Excel format options are available:

Excel 2007 format renders report output in native Excel XML format, also known as XLSX, that provides a fast way to deliver native Excel spreadsheets to Microsoft Excel 2002, Microsoft Excel 2003, and Microsoft Excel 2007. Users of Microsoft Excel 2002 and Microsoft Excel 2003 must install the Microsoft Office Compatibility Pack, which provides file open and save capabilities for the new format. The output is similar to other Excel formats, with the following exceptions:

Excel 2002 format also offers the following benefits: