Search Results

Creating a new analysis from a local file

You can create new analyses from files that are saved locally on your computer.

This topic describes how to create an analysis based on a Microsoft Excel Workbook, but you load data from other file formats in a similar way.

You can create new analyses from locally saved files of the following file formats: Microsoft Excel Workbooks (.xlsx, .xls), Microsoft Excel Binary Workbooks (.xlsb), Microsoft Excel Macro-Enabled Workbooks (.xlsm), comma separated values files (.csv), text files (.txt), logfiles (.log), TIBCO Spotfire Text Data Format files (.stdf), TIBCO Spotfire Binary Data Format files (.sbdf). You can also open locally saved TIBCO Spotfire analysis files (.dxp), but then you will not create a new analysis, instead an existing analysis will be opened.

Tip: To interpret the Excel worksheet correctly, you may need to make some data preparation before loading it.

Procedure

  1. In the library, click New analysis.
  2. Click Local file, and navigate to the file of interest.
  3. Select the file, and then click Open.

    If your Excel Workbook contains more than one worksheet, the Select worksheet dialog is displayed. In the dialog, select which worksheet to load, and then click OK. Only one worksheet can be loaded at a time.
    Select worksheet

    A new analysis with the selected data is opened.

Dragging a file to the library

Alternatively, you can create a new analysis by dragging a file to the library.

If the file is an Excel Workbook with more than one worksheet, select the wanted worksheet as described above.

What to do next

The loaded data can be visualized either using Recommended visualizations, or you can create your own visualizations.