Importing Data Files

An alternate method of "querying" is to import data from a file. Interactive Reporting can import files in Microsoft Excel (.XLS), and in both comma (.CVS) and tab (.TXT) delimited text formats.

When you import data, the content of a file is delivered to the desktop data cache and displayed in the Results section. You can use imported data as you would the results of a query to build reports and perform data analysis.

  To import a data file:

  1. Select File, then Import Data File, and then Data File.

    The Import File dialog box is displayed.

  2. Navigate to the location of the file.

    On a Windows operating system, select the correct type of the import file type menu to make the file easier to find.

  3. Select the file and click OK.

    The data from the imported file is displayed in columnar Results Format.