TIBCO Cloud™ Spotfire® User Guide

Exporting to Microsoft Excel

You can export a tabular visualization (table, cross table, graphical table, and summary table) 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 might cause the values to be shown slightly differently depending on the culture set. To learn more about the predefined number formats in Excel, see the official documentation from Microsoft.

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.

Procedure

  1. Click the tabular visualization you want to export.
  2. 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.
  3. 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.