Load multiple sheets from Excel Files

[Anonymous]

hi

how can i load multiple excel sheets with different sheet names but same columns heading into Qlik sense, any script?

thanks

[GaryGiles]

If you know the sheet names and you want the data in one table, you could use:

Tablename:

LOAD
Column1,
Column2,
Column3
FROM [lib://Your Connection Name/Sample.xlsx]
(ooxml, embedded labels, table is Sheet1);

LOAD
Column1,
Column2,
Column3
FROM [lib://Your Connection Name/Sample.xlsx]
(ooxml, embedded labels, table is Sheet2);

and so on  . . .

[MayilVahanan]

Hi @Anonymous 

Please refer below link, hope it helps

https://community.qlik.com/t5/New-to-Qlik-Sense/Multiple-sheets-from-excel-in-Qliksense/td-p/95602