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!
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?
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 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!
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'
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"?
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?)
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.
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?
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.
@@ChesterTugwell Great tutorial, Chester! It was very clear and helpful. I successfully retrieved the list of files and their sizes into Excel. However, I'm also looking to get the Comments and Tags. Could you please provide some guidance on how to achieve this? Thanks in advance!
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.
This looks like a good, useful feature that I need, but unfortunately this function is missing from the 2019 stand-alone version of Excel for Mac. To perform this task on my Mac computer, using Excel, I would need to buy a Windows computer + Win version of Excel and network that to my Mac to search it to create an Excel file of my Mac files and folders. No fault of the author here, but shame on Microsoft for making the Mac versions of their Office products so weak.
So simple, so clear. Excellent.
Mannnnnnnnnnnnnnnnnnnnnnnn I swear everything you want to know is online... This right here saved me so much 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!!!
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!
Same here! Thank you and Happy new Year! 🥰
omg you are a life saver! i wish a could give a million views and likes 👍🏻
All that in a 3-min video! Wonderful! Thanks.
Thank you so much! Exactly what I was trying to accomplish, yet even better than I expected!
This is excellent! I have one question, is it possible to attach a hyperlink to these files and folders?
Love it, you save my day from work!
Perfect video to do exactly what I needed. Thank you for the informative video!
I’ve always wondered and hoped there was a way to do this. This is so helpful, thanks!!
Just a big WOW! What a power of your learning and Power Query! Thanks a lot for this Goody! ❤🙏❤
Thank you so much, exactly what I was looking for and straight to the point.
that's flarkin awesome maan!
Amazing Mr., thank you so much. Kind regards from Costa Rica.
Thank a lot. Really helpful for cataloguing.
Dear Sir,
Heartily Thank You So Much Sir.
Basavaraj From India.
Fine method! Thank you for this Power Query video.
Superb Chester thanks for that. Subscribed
Thank you, this was very helpful!
Thanks Chest .. it helped ..appreciate it ..
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?
Thank you - this is fantastic! Giving one thumb's up isn't nearly enough!
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!
Beautiful!
Thank you very much!!!
this is best video on internet
Wow! Thank you Sir, for sharing this knowledge it really save a lot of time for my end. Kudos to you Sir! Thanks.
thanks too much for your effort :)
Thank you so much for this advice
This is excellent and short way
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 so much. Very helpful and save me a lot of time! ;-)
Thank you thank you!
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?
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 this possible to do on numbers? I am trying on a Mac with excel but there is no Get Data from file voice.
Very useful.... Should we delete the col Binary?
Can you do this just for folder names (i.e not the files and contents)?
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?
Excellent. Thanks
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?
thank you, it's very usefull
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!
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'
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"?
Will this work for mp3 files also? And all of the metadata embedded in the file?
Very fine, how we can add the file creator names in this method?, the name of the user who created this file ?
Thank you sooooooooooooooo much :DD
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?)
but in mac , i dont find this options.. can u help?
excellent
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.
Thank you.
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?
Is there a macro where it links the files?
The parent folder itself is not being added to the query list. How can you do that ?
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.
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.
Thank you
thanks so much
You're welcome!
@@ChesterTugwell Great tutorial, Chester! It was very clear and helpful. I successfully retrieved the list of files and their sizes into Excel. However, I'm also looking to get the Comments and Tags. Could you please provide some guidance on how to achieve this? Thanks in advance!
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.
How can I get Descriptions to be included in a column
well tanx
i want the exact opposite of same thing you did
Anyone can help me please?
I wonder why I get "Limit of 1000 values reached"...
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.
This looks like a good, useful feature that I need, but unfortunately this function is missing from the 2019 stand-alone version of Excel for Mac. To perform this task on my Mac computer, using Excel, I would need to buy a Windows computer + Win version of Excel and network that to my Mac to search it to create an Excel file of my Mac files and folders. No fault of the author here, but shame on Microsoft for making the Mac versions of their Office products so weak.
Thank you