You can export data from Spotfire and save as a text file, a CSV file (comma-separated or semicolon-separated), a 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.
If data is exported from a visualization, rather than the whole data table, you will get the aggregated values for the visualization items, when applicable. When exporting from a visualization, the only format available is a tab-separated text file, for all visualization types other than the table visualization and the Details-on-Demand.
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: When exporting a tabular visualization, that is, table, cross table, graphical table, or summary table, you can use File > Export > Visualization to Microsoft Excel to preserve styling, layout, and formatting in the resulting Excel file.
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 table and the cross table, you must mark the items of interest before opening the Export Data dialog, to make the option available.
To export data from a visualization:
On the menu bar, 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 what data 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.
Select file format.
Click OK.
Specify a file name and a location for the file.
Click Save.
To export data from a data table:
On the menu bar, select File > Export > Data to file.
Click the Data table radio button.
Comment: Note that this option is not available for external (in-db) data.
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.
Select file format.
Click OK.
Specify a file name and location for the file.
Click Save.
The 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 Spotfire.
The 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 Spotfire. If you select the Spotfire Text Data Format (*.stdf) you will be able to open the file in older versions of Spotfire, but you might not get all functionality of the Spotfire Text Data Format.
See also: