Note – This procedure applies to both pivot and List View tables.

Use this procedure to export an STA table to a file that can be viewed and edited with Microsoft Excel or a compatible spreadsheet application. Prior to performing this procedure you need to set up the table so it includes all the data you want to export. The exported data includes all resources and attributes included in the table, as follows:

The file is saved to your local computer. The data is saved in HTML format, but the file is given a .xls extension so you can easily open it in Microsoft Excel. See “Display an Exported Spreadsheet” for options on viewing and editing the file.

Note – This procedure uses a List View table, but you could also use a pivot table.

A filter is applied in this example.

The file is downloaded to your computer according to your browser settings. See your browser documentation for details. Following is an example of a dialog box you might see on a computer running Windows. Note that the file will be saved with a .xls extension.