Selecting multiple sheets at once-Power query navigator

[Gal1234]

Hello,

I have one excel workbook with multiple sheets in it.

i want to import all the sheets into power query, but the problem is that in power query navigator it won't let me choose all
the sheets at once, and i forced to choose them one by one (picture for example):

How can I select all the sheets at once if, for example, I will have an excel workbook with 200 sheets in it? (I know this can be inefficient in terms of Time complexity, i just say this as an example).

I do not want to combine/merge/append/etc the sheets, I  just want them to be uploaded separately like in the picture below:

And if I can't select all of them at once, I would appreciate it if you could explain to me why.

Thank you very much in advance for the help, I searched a lot on the Internet for an answer to this question and could not find it.

[AbbasG]

@Gal1234 found this video from Radacad but again if you don't want to append them it might not work 🤔.

https://youtu.be/gQo5coD9c4M
Until then!

[AbbasG]

@Gal1234 Hi, I was simply able to select them all and import them as your desired outcome.

Below are screenshots for your reference.

Hope it helps.

[Gal1234]

Thanks for the reply but that's not what I meant.

in your example, you import 3 sheets that you needed to choose one by one.

But imagine that you have 200 sheets that you need to import, you don't want to waste 1 hour picking them one by one right?

What I asked if there a way to choose all the sheets at once, without choose them one by one in the Power query navigator like you did.