Connecting to Microsoft Excel Using the ElastiCube Manager

Note: This topic describes how to import data through the desktop ElastiCube Manager. It is recommended that you import data through the online Sisense Web Application. For information, click here.

Sisenser enables easy and quick access to tables contained within Excel spreadsheets.

You can add multiple Excel files to your ElastiCube. A typical use case for importing multiple files is when you want to split a large file into multiple smaller files.

Note: Click here to see tips on how to prepare your Excel files before adding them to your schema in the ElastiCube.

To connect to Microsoft Excel:

  1. Click Add Data in the top menu of Sisense.
  2. Under the Files category select Microsoft Excel File.
  3. In the window that opens, locate the Excel file.
  4. Select the Excel file and click OK.
  5. In the window that opens, you have the following options:
  6. For a Static Range, enter two cells, each with a leading $ sign and a colon as a delimiter. Hit Enter to preview the selection. Selecting Static Range option enables you to select a specific range of data in the sheet. Data needs to be in a table structure, starting at the top left cell of the range, with field names as the first row.

    For a static range between cells A1 and E10, type in $A1:$E10

    Selecting whole sheet will import all data within the sheet. Data within the sheet needs to be in a table structure starting at the top left corner (cell A1) with the field names as the first row.

    Note: Make sure that all the files adhere to the same structure, including the presence or absence of headers in the first row. Files will be added to the table based on their file names in alphabetical order.

    Select the Select folder to import option. All the Excel files in the folder are added to the selected files list.

    Click OK.

  7. Click Add.