Literally, the data of more than 100 folders, gave results in above 37 THOUSAND rows, in just less than a minute. You rock on Sir !!!

I would call it a BOSS video sir, I have been writing macros and doing lengthy and time taken steps to get the list of sub folders. This video shorten my time from several hours to only a minute or two!!!

Been looking for a way to do this and this is WAY easier and more useful than the CMD option I kept on seeing. Thanks so much!!! Need to give this 2 thumbs up, or more!

Mannnnnnnnnnnnnnnnnnnnnnnn I swear everything you want to know is online... This right here saved me so much time.

Just a big WOW! What a power of your learning and Power Query! Thanks a lot for this Goody! ❤🙏❤

This is excellent! I have one question, is it possible to attach a hyperlink to these files and folders?

Perfect video to do exactly what I needed. Thank you for the informative video!

Thank you so much, exactly what I was looking for and straight to the point.

Fine method! Thank you for this Power Query video.

All that in a 3-min video! Wonderful! Thanks.

Amazing Mr., thank you so much. Kind regards from Costa Rica.

I’ve always wondered and hoped there was a way to do this. This is so helpful, thanks!!

Thank a lot. Really helpful for cataloguing.

Wow! Thank you Sir, for sharing this knowledge it really save a lot of time for my end. Kudos to you Sir! Thanks.

Beautiful! Thank you very much!!!

Best tutorial i've seen in a long time, clear and precise, thank you very much. At the risk of sounding greedy, is there anyway I can display the file size in mb or gb?

Great tutorial! Quick question: I tried using this option for multiple folders and subfolders (more than 1000) and it doesn't seem to work. Is there a size limit? What is an alternative option?

Love it, you save my day from work!

This is just plain AWESOME! Would you know of a way to create an index of folders in DropBox? Besides manually creating it.

Saved me hours, thank you!

Thank you so much for this advice

Superb Chester thanks for that. Subscribed

omg you are a life saver! i wish a could give a million views and likes 👍🏻

that's flarkin awesome maan!

This is great. If I add a text column for the purpose of adding tags, do you think this would work? I've been looking around for a solution to the limitations of the Windows limited tagging system as you can't tag all files.

Thank you so much. Very helpful and save me a lot of time! ;-)

Thank you - this is fantastic! Giving one thumb's up isn't nearly enough!

Thanks Chest .. it helped ..appreciate it ..

Hi Chester ! Thanks for this incredibly useful tool. I would like to add a column for comments by each file, however when I've done this and then refreshed the list, the comments stay in the same cells I originally entered in the values, and the dynamic range obviously moves and the comments to files become misaligned. Is there any way to do this so that the comments stay relative to the files I originally referred to please?

Thank you thank you!

Thank you, this was very helpful!

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?)

thank you, it's very usefull

This is excellent and short way

thanks too much for your effort :)

excellent

Excellent. Thanks

Dear Sir, Heartily Thank You So Much Sir. Basavaraj From India.

Thank you

Thanks. I was searching for a way to get a file listing, and was pleasantly surprised to run into this one. Now, I need to sort the list by largest files at top so that I can determine which files are hogging my C drive. I get Drive full errors Thanks Again.

This is genius!!! It there any way to get the author of the file listed as well? I could not find the option for that anywhere.

Thank you.

Very fine, how we can add the file creator names in this method?, the name of the user who created this file ?

thanks so much

Thank you for this! Can you get just folders, not files within folders. I'm trying to create a directory and assign permissions based on position within the company. I don't need each file, just a list of the folders. Thanks!

Is it possible to display the file name into the file path too? So I can just copy and paste the entire path of the file, with the file included?

I don't see an 'From folder' option under 'Get Data' in Excel for Mac, nor am I able to add a folder to the 'Connections', what should I do?

Very useful.... Should we delete the col Binary?

well tanx

Is this possible to do on numbers? I am trying on a Mac with excel but there is no Get Data from file voice.

Hi Chester When I tried this I got the following message and not sure how to overcome it. Can you advise? Many thanks David '... files are longer than the system defined maximum length'

You beautiful genius where have you been all my life. Sh*t this is very helpful. Thanks man ( I mean Much obliged in a cowboy voice) from Phoenix, Arizona 2024_5-24.

The parent folder itself is not being added to the query list. How can you do that ?

but in mac , i dont find this options.. can u help?

Will this work for mp3 files also? And all of the metadata embedded in the file?

I have folders of music & sound effects and would like to display the column "length" but that folder option doesn't appear as an option in the attributes column. Any ideas how to add that? Or other options like "genre" and "contributing artists"?

When I do the steps shown, I can't go to a folder which is on another network. How do I select folder from another network.

I've been trying to do this all day, but I can't get it to pull more than the first 100 rows, and it only has data in the first 33 rows.

Is there a macro where it links the files?

How can I get Descriptions to be included in a column

i want the exact opposite of same thing you did Anyone can help me please?

How does this work when you're dealing with thousands of lines of data? Does it handle projects well with hundreds of folders and possibly tens of thousands of files? Guess I should just test it.

Thank you