Question: how to import excel file in qlikview?
Answer: Select the Excel file. Keep the main window of QlikView open and browse for the excel file you want to use.
Select a Data Source. On dropping the excel file into the main window, the File wizard appears. ... 
Load Script. ... 
Create Table Box. ... 
Table Box Data.