Exporting to Microsoft Excel

You can export any tabular visualization, that is, the table, cross table, graphical table, or summary table visualizations, to an Excel file.

In general, the data is exported with the same data type and formatting as in Spotfire. However, in some cases, there is no direct mapping between the data type in Spotfire and the number format in Excel. Based on the data type, the data is then mapped to a default format, which is one of the predefined formats in Excel, for example General, Number, Date, or Time. This may cause the values to be displayed slightly differently depending on the culture set. To learn more about the predefined number formats in Excel, see Microsoft's official documentation.

If it is not possible to map a data type exactly or the formatting differs significantly in the export, you will see a notification in Spotfire.

Binary data, except for images, cannot be exported. Also, zebra striping in table visualizations is not applied in the resulting Excel file.

Before you begin

You must have access to the Export Data license feature (under the Spotfire Enterprise Player license).

Procedure

Click the visualization you want to export.
On the menu bar, select File > Export > Visualization to Microsoft Excel.

Tip: Alternatively, right-click the visualization, and select Export > Visualization to Microsoft Excel.

Note: In the web client, you can select the option Export table to export all data in the visualization and to remove all layout and styling, such as font or colors, in the resulting .csv file. Select the option Export table (without value formatting) to also remove value formatting, such as Currency or Percentage.
If you are using the installed client, specify a file name and location for the Excel file, then click Save. If you are using the web client, the file either downloads to your computer, or you are prompted to open or save it, depending on your web browser settings.