How to Get a List of all Files in a Folder and Subfolders into Excel

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

Thank a lot. Really helpful for cataloguing.

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

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.

Dear Sir,
Heartily Thank You So Much Sir.

Basavaraj From India.

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

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

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.

excellent

This method didn’t work for me because the length of the folder and file names exceeded the maximum (and bogged down because Excel was trying to pull names from a network file share). Disappointed!

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'

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

thanks so much

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

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

thanks too much for your effort :)

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

This is excellent and short way

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

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

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 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!

well tanx

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.

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?

Thank you

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.

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?

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

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?

that's flarkin awesome maan!

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!

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.

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

Beautiful!
Thank you very much!!!

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

Thank you thank you!

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

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

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

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

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?

Love it, you save my day from work!

Saved me hours, thank you!

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

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

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!!!

Superb Chester thanks for that. Subscribed

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