
Anonymous
Not applicable
2020-11-14
12:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Load multiple sheets from Excel Files
hi
how can i load multiple excel sheets with different sheet names but same columns heading into Qlik sense, any script?
thanks
2,160 Views
2 Replies

Specialist
2020-11-14
02:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 . . .
2,134 Views

MVP
2020-11-15
09:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Please close the thread by marking correct answer & give likes if you like the post.
2,087 Views
