This tutorial shows how to load an Excel file into Qlik Sense as a data source for reporting and analysis.
Note:
Supported formats include .xlsx and .xls. If your Excel file has multiple sheets, Qlik Sense lets you select which sheet to load.
- Login and open your Qlik Sense app, and click Data manager from the top menu.
- Click Add data and select File and other sources from the list of source types.
- Browse your local folders and select the Excel file you want to load.
- Select the sheet you want to use from the sheet selector in the preview panel.
- Confirm that Qlik Sense has correctly identified the header row and field names in the preview table.
- Click Next to load the file into your data model.
- Click Load data to run the script and make the data available across your app.
