Exporting Your View as an External File

Overview of Exporting Your View

You can save a data view to an external file that you can read in Microsoft Excel, Microsoft Word, and other software. You can export the entire data view (including the page banner, table viewers, and graph viewers), or you can export the data from a single table viewer.

Export the Entire Data View

To export the entire data view, select File

Export To Excel from the main menu bar. A new Excel file is created in HTML format, and a dialog box appears, which enables you to select where to save the file.

Note: The Excel file is delivered within a zip archive.

Export the Data for a Specific Table Viewer

To export the data for a specific table viewer:

Right-click a hierarchy level (OLAP data) or column heading (relational data), and then select Export or Save As.
In the Export or Save As dialog box, specify values for the following fields:

Rows

specifies which rows from the table viewer are included. Select one of the following:

All rows

selects all of the rows in the table viewer.

Rows

selects a subset of rows. Specify the first row that you want to include in the From field. Specify the last row that you want to include in the To field.

For example, to include the first five rows, specify 1 in the From field and 5 in the To field.

Columns (relational data only)

selects the columns to include. To include all of the columns in the current query, select All columns. To select a subset of columns, select Selected columns and then select the box beside each column that you want to include.

Formatted Data (OLAP data only)

specifies whether to export formatting information with that data. To include formatting information, select the check box.

For example, a value that appears in Visual Data Explorer as $1,934.50 will be unchanged after exporting with the Formatted Data option, but the value will be changed to 1934.5 if you export without the Formatted Data option.

Note: If you select Word or Excel as your output file format, then this option is always selected.

Repeat row labels if expanded (OLAP data only)

specifies whether row labels are repeated when hierarchies on the vertical axis are expanded. To repeat row labels, select the check box. To include each row label once, clear the check box.

Note: If you select Word or Excel as your output file format, then this option is always selected.

Export to

specifies a Microsoft output file format. Select Excel to create a Microsoft Excel spreadsheet. Select Word to create a Microsoft Word document.

Save as

specifies a text output format. Select Tab separated values (.tsv) file to create an output file with tab-separated values. Select Comma separated values (.csv) file to create an output file with comma-separated values.
When you have finished choosing options, click OK.

Note: In Microsoft Excel, if a column is too narrow to show the data, the value is displayed as ###. To see the values, increase the width of the column.