List of filenames from folder and subfolders into Excel

[@Hybe123]

Why don't I have the "Get Data from File/Folder" option in excel 2016?

[@denisereynolds2610]

This was an amazing recording. Clear and to the point. Thank you.

[@ArifBudimanPage]

what is the unit of file size which is shown in power query?

[@jorccarangan6518]

Gold!

[@A-broken-clay-jar]

Wow. I never know you can do something like this. Very clear instruction.

[@denisebreard5355]

Thank you for your excellent instructions. I was unfamiliar with Power Query and this completely resolved my issue. Cheers!

[@moesadr3342]

Is there any way that the folder name/path can be changed whenever needed? Like a drop down box or data entry cell to introduce other folder's name/path ( of course one folder at a time?)

[@hhbadarin]

You're awesome!

[@hanaict3768]

Thank you so much. It's straightforward and well-structured. You save me a day!

[@plor1261]

Took me forever to find this tutorial. Thank you!

[@Ngovandan]

Thank you for this. Excellent tutorial!

[@denisereynolds2610]

I meant to say excellent. Thanks!

[@AqleemAbbas]

Great Madam