Exporting Data to File

You can export data from TIBCO Spotfire and save as a text file, a TIBCO Spotfire Binary Data Format file (see below) or a Microsoft Excel file. The text file can be either a regular tab separated text file, or a Spotfire Text Data Format file. The Excel file can be either an XLS file or an XLSX file. Data from a visualization can only be exported to an Excel file if the visualization is a table. Also note that when exporting to Excel it is always the values that are exported and not the formatting, except for date/time values where the current locale is being used.

Tip: You can use the Export Data from Visualization option when you want to export from in-db data tables. Note that for all visualizations other than the cross table you need to mark the items of interest before opening the Export Data dialog.

Note: When analyses are exported, they are rendered with the default light theme, even if the dark theme is applied.

To export data from a visualization:

Select File > Export > Data to File....
Click the Visualization radio button.
Select the visualization to base the new data file on from the drop-down list.

Comment: You can export all or marked data from a table, cross table or a summary table, or the marked data from any other visualization. You can also select to export the data currently shown in the Details-on-Demand.
If both options are available for the selected visualization, select whether to export:
Data for all items - the rows remaining after the current filtering.
Data for marked items - the currently marked rows. Note that all marked rows will be exported, even if they are filtered out.

Comment: The Data for all items option is only available if you have selected a table, a cross table, a summary table, or the Details-on-Demand in the Visualization drop-down list. Data for marked items is only available if there are marked items in the analysis.
Click OK.
Specify a file name and a location for the file in the Save As dialog.
Click Save.

Comment: You can export the data to a text file, to an Excel file, to a TIBCO Spotfire Text Data Format file (*.stdf) or to a TIBCO Spotfire Binary Data Format file (*.sbdf). See below for more information.

To export data from a data table:

Select File > Export > Data to File....
Click the Data table radio button.
In the drop-down list, select which data table to export data from.
Select what data to export:
All rows - the entire data table regardless of all filtering.
Filtered rows - the rows remaining after the current filtering by the specified filtering scheme.
Marked rows - the rows marked in the visualizations using the specified marking. Note that all marked rows will be exported, even if they are filtered out.
Click OK.
Specify a file name and a location for the data file in the Save As dialog.
Click Save.

Comment: You can export the data to a text file, to an Excel file, to a TIBCO Spotfire Text Data Format file (*.stdf) or to a TIBCO Spotfire Binary Data Format file (*.sbdf). See below for more information.

The TIBCO Spotfire Binary Data Format stores the data and metadata from your analysis in binary form. It can be used to greatly increase the performance when working with linked data in TIBCO Spotfire.

The TIBCO Spotfire Text Data Format also includes metadata. For example, the data types of the columns are saved, so you do not need to specify any import settings when opening files of this data format in TIBCO Spotfire. If you select the TIBCO Spotfire Text Data Format (*.txt) you will be able to open the file in older versions of TIBCO Spotfire (before 3.1) and in TIBCO Spotfire DecisionSite, but you will not get all functionality of the Spotfire Text Data Format.