Details on Export Data


Tip: Use the Export data from Visualization option when you want to export from in-database data tables. See Working With In-Database Data for more information.

Note: For all visualizations other than tables, cross tables and summary tables you need to mark the items of interest to be able to export from the visualization.

  1. Select File > Export > Data....

export_data_d.png

Option

Description

Export data from

Allows you to select whether to export data based on a visualization or on a data table.

   Visualization
   

Select this option to export data based on one of the visualizations in the active page, including the Details-on-Demand (if visible).

Note: Data from a visualization can only be exported to an Excel file if the visualization is a table.

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.

      Data for all items
     

Only available for tables, cross tables and summary tables. Exports all data in the selected visualization, the way it looks right now. This means that only the data remaining after the current filtering will be exported.

      Data for marked items
     

Exports data for the marked items in the selected visualization. Note that all marked rows will be exported, even if they are filtered out.

   Data table
  

Select this option to export data based on one of the data tables in the document.

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.

      All rows
     

Exports all rows available in the entire data table, regardless of filtering.

      Filtered rows
     

Exports the rows remaining after the current filtering (using the filtering scheme on the active page) only.

      Marked rows, defined by
     

Exports the rows marked in the visualizations (using the specified marking) only, regardless of filtering.

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.

See also:

Exporting Data

Saving an Analysis File

Saving an Analysis File in the Library