Load Excel with multiple tabs and use each tab name as a new column

[YC-Bisley]

Hi all,

Is there a way I can load all tabs in one Excel (with a number of tabs), with identical fields in each tab.

What I want is :

- to load data in each tab 

- for each tab loaded, add the tab name as a new column

- consolidate all tabs into one table 

My data input

My desired output

[marcus_sommer]

You need just to know how the tabs are named respectively having any logic to derive them, for example if they relate to existing periods or similar stuff. And then you may do something like this:

for each tab in 'tabA', 'tabB', 'tabC'
   t: load *, '$(tab)' as Source from Excel.xlsx (ooxml, embedded labels, table is [$(tab)]);
next