Export spreadsheet to Microsoft Excel

You can export a spreadsheet to Microsoft® Excel.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.

  2. Activate the Data tab bar.

  3. Click Export Excel export.

The spreadsheet is exported to Excel. The spreadsheet can be saved as XLS or XLSX file.

If the spreadsheet conntains formulas, such as =ANALYSIS_ITEM_LOCKED_BY_USER(<CELL_REFERENCE>) or =QUERY_LOCKED_BY_USER(<CELL_REFERENCE>), the value is exported as string. If you selected the Generate comments for unsupported formulas, the formula is stored like a comment in the cell.