Opening an Excel File


Microsoft Excel files (XLSX or XLS) stored using Microsoft Office Excel 2000 or later can be opened in Spotfire.

  1. Click on the Open button on the toolbar, or select File > Open....

  2. Browse to the Excel file of interest and click Open.

  3. Select the Worksheet to import.

    Comment: If you cannot see all worksheets available in the file at this step, try saving and closing the file in Excel before you open it in Spotfire.

  4. Look at the Data preview and make sure that the format of your data looks OK.

  5. If necessary, change any settings required to obtain the desired result.

    Comment: For detailed information about the various settings, see Excel Import.

  6. Click on Refresh.

    Response: The Data preview field is updated.

  7. When you are satisfied, click OK.

    Comment: For information about adding more data tables to the analysis, see How to Insert Multiple Data Tables to the Analysis.

See also:

Opening an Analysis File

Opening a Text File

Opening a SAS File

Opening Files from the Library

Opening an Information Link

Opening Data from a Database