Export list of file names from Windows Explorer folder tree to Microsoft Excel

Рет қаралды 366,430

Күн бұрын

Video explaining how to export a list of file names contained in folders and subfolders on a Windows computer to Microsoft Excel. This can be useful, for example, if you have a library of documents in a folder tree in Windows file explorer and you want to list all of the documents on a List of Documents to be provided to opposing parties in civil litigation.
If your library of documents contains various types of files and not just pdf files, to search for all files search for just a period i.e. "." (without the quotation marks), and that will bring up a list of all documents in the folder tree and then you can copy the paths of all of those documents to the clipboard using Shift + Right Click and then selecting "Copy as Path"..
If you want to export more detailed metadata see the video at: • Export detailed metada...

Пікірлер: 305

@erikwafler7069 3 жыл бұрын

Great, but does not work if you have mixed file types, not only pdfs, in the folders...

@MichaelDewTechTips 3 жыл бұрын

Search for just a period, that will bring up all items in the folder and its subfolders.

@scottrettelle9862 4 жыл бұрын

Dude! This is EXACTLY what I was looking for! As a writer, I've been wondering how to do this for years. I have so many files that I didn't know how to keep track of them. This is wonderful. Thank you so much for posting.

@sreenivasaraoh 3 жыл бұрын

Shift+Right Click gives Copy as Path...... Simply Superb, Thanks a Lot Michael Dew

@danlewis8044 5 жыл бұрын

This is the simple and elegant solution I've been searching for for over 3 years. Thank you!!

@ghostchanter333 5 жыл бұрын

The first two minutes of your video explained exactly what I was trying to do. Thank you for posting.

@melvoid 5 жыл бұрын

I searched a whole pile of instructions to do this. Probably tried 6 or 7. Yours is the first one that actually worked. Nice job.

@christy4051 6 жыл бұрын

I am shook...all I have ever previously found was how to do this through DIR commands. This is so much simpler. Thank you!

@AS-rj5qt 6 жыл бұрын

Christy K same here. Lol

@BrickWoodOvens 4 жыл бұрын

You just EASILY saved me a MINIMUM of 4 - 5 hrs of work. Thank you for posting this great video!

@Salman.khan786 4 жыл бұрын

I have been trying to find a video or anything about this topic for over a year bro a year! I believe this is the only thing on the whole internet that shows you how to do it. It should be preserved!

@Dane-lp7ur 4 жыл бұрын

I VERY rarely comment on anything, but this seriously just saved me days and days of work. Thank you so much!

@joannegaribay4802 5 жыл бұрын

This link helped tremendously - saving me hours - thank you very much JMG

@nabeelkareem 3 жыл бұрын

God bless you Michael. Excellent and so simple. I have no idea how come some users chose a thumbs down for this excellent video clip.

@nanstee25 2 жыл бұрын

This is one of the greatest videos i have ever seen. I was wondering if this could be done and you have done it. Well done that man.

@tomatovamp 4 жыл бұрын

Wow, amazing and neat! Was searching for a way to export a list of folder names, but came upon this gem. Definitely would use this way of organizing in the future. Thank you!

@structure7 6 жыл бұрын

I am very glad that people like you exist. Thank you!

@PeteJohnsMusic 3 жыл бұрын

"Copy as path" saved me big time here. Thanks very much.

@charoberts4986 5 жыл бұрын

Thank you for this tutorial. I didn't have "copy as path" but read a comment from another person on how to do it. Very helpful.

@tinasingh1087 5 жыл бұрын

How do u get it??

@dimitriospapapavlou9539 4 жыл бұрын

Awesome ! Instant subscription for Michael ! There is a bunch of supposedly "perfect" mini seminars about this procedure but all failed. Happy i came across your channel.

@maximiliansmith4821 4 жыл бұрын

OMG thank you. I can't even tell you how much time this just saved me, but we're talking HOURS, at least.

@yugandharkota8618 4 жыл бұрын

It helped me a lot instead of doing it separately and will consume more time and main thing is Hyper Link, it is superb. Thank you Dear Michael.

@canadude6401 5 жыл бұрын

That was brilliant! Thanks for posting! You just saved me hours of work by this little trick!

@rashimahindra 5 жыл бұрын

This worked like a charm. Thanks so much!

@mwKanj 5 жыл бұрын

Wow, you are genius. Thank you so much for sharing this. Extremely helpful!

@dimasgomez 3 жыл бұрын

Nice explanation. There are a number of ways to do this, and you managed to do it very efficiently. Thanks for your contribution!

@sarojabadiger7483 2 жыл бұрын

Thank you. The select all and shift key with "copy as path" worked for me.

@jimwarrick8814 4 жыл бұрын

You have solved a problem I've been working on for a while. Thank you SO much!!

@dfxdfx5368 6 жыл бұрын

Finally! I even downloaded a software to do that, and it got stucked after the first use. Thanks a lot.

@mrjoetypepersonthing 4 жыл бұрын

Perfect. Exactly what I was looking for, thank you very much!

@reddlief 8 ай бұрын

I've been using search and replace, but your keyboard shortcuts will save me time and make my end product more accurate! I'm checking this 6 yrs from original and will try on Windows 11 and MS Office 365 to see if it's still current. I've saved and will thank you later!

@wingame52 2 жыл бұрын

teaches so much excel possibilities in a single video. thanks!

@kas6345 4 жыл бұрын

saves me time, EVERYTIME i need it!!! I will remember it one day, but dont use it often enough

@HyeBrownIz 4 жыл бұрын

Excellent!! Wondered how to do this for years. Thank you!

@kayleenswartz6624 3 жыл бұрын

Thank you so much! I did a week's work in just 10 minutes!!! I had to put 2 years' PO's into a spreadsheet. Can you imagine how I would have struggled?

@pecoda679 4 жыл бұрын

Thank you. Exactly what I needed! This will save me a ton of time.

@nabilas6123 4 жыл бұрын

Thank you! This is the best & simplest solution! Saved me hours of work

@evenessa 4 жыл бұрын

This was not the video i was looking for. But the video I needed !

@guillermovargas3135 4 жыл бұрын

This saved me the hassle of programming it. Thank you!!!

@xmanxmansyr3147 4 жыл бұрын

YOU JUST SAVED MY LIFE Thank You!!!

@simonweston7960 3 жыл бұрын

This was so clear, thank you and useful. On some of your videos you have a link to a written set of instructions to accompany the video and that would be truly helpful. Thank you.

@SuperGoodgye 4 жыл бұрын

Super Helpful!!! This was exactly what I was trying to do! Thank you!

@alisoncarter767 5 жыл бұрын

Exactly what I needed and more that I hadn't even thought I needed

@winterbells1025 3 жыл бұрын

Thank you! So concise and simple- it helped a ton!

@JohnJohnson-ok4gf 4 жыл бұрын

You deserve a medal just for the 0:00-2:00 part. Thanks!

@lycian123 3 жыл бұрын

Huge amount of time saved. Thank you.

@DarinShreves 4 жыл бұрын

This was extremely helpful. Thank you.

@MrYepz 3 жыл бұрын

HOLE LEE SH*T, I'm stupid, it's okay, I've known this for some time, but I did it, thank you so much! I thought I had to take every individual PDF title and insert manually into an excel sector - omg it worked! Thank you, some really intelligent sounding Indian guy made a vid so far over my head, I was consigned to transfer all the names manually!

@GeminiRift 4 жыл бұрын

This saved me so much time. Thanks for posting.

@berthabarreiro7095 4 жыл бұрын

Exactly what I was looking for, and more. Thanks.

@vibhavarideshpande1193 4 жыл бұрын

Thank u Michael.... It has saved my time like anything. I was looking for it from many days. This will help me in Mail merge

@coolcatr 5 жыл бұрын

You're my idol/hero; thanks boss!

@Arfiess 2 жыл бұрын

This is such a big brain Excel move, thank you so much.

@swatts0813 4 жыл бұрын

Thanks!!! Saved me about 5 hours of tedious work!!!

@milkauhash958 5 жыл бұрын

Michael Dew, you are AWESOME!!!

@3rg3 3 жыл бұрын

Perfectly explained tutorial. Just great!

@slimchick2689 4 жыл бұрын

This helped soooooo much. You my guy are Awesome!!!

@fredrikboltes2072 4 жыл бұрын

WOW. Best video ever. Saved me like a weeks work

@cassandrapersaud8165 3 жыл бұрын

Excellent video. Very helpful!

@alansaunders2177 5 жыл бұрын

This was perfect, thank you!

@angelherraiz5381 5 жыл бұрын

superclever!!! you've helped me a lot and saved me many hours of work. Many thanks

@chingzhu2149 Жыл бұрын

This is EXACTLY what I was looking for! Thank you so much, Michael! from your new subscriber.👍👍

@nyc1103 4 жыл бұрын

YOU JUST SAVED ME SOOOOOOOO much time!!! Thank You!!!

@xmanxmansyr3147 4 жыл бұрын

ME TOO

@mrjumpsuit 5 жыл бұрын

You, sir, are a bloody genius.

@valenzuelm 3 жыл бұрын

Excellent tutorial... Saved me hours of work.....

@Skans-Gustav 5 жыл бұрын

Extremely useful. Thank you.

@kayserchishti7303 Жыл бұрын

fab, easy way to copy broad list of files. You went a bit further to and split sorted etc.BRAVO

@touch7256 4 жыл бұрын

Thank you so much for this huge time saving task.

@gabrieltoriz211 4 жыл бұрын

Thanks Michael this was very useful for me.

@Dangkho8 3 жыл бұрын

Brilliant. Works very well for what I needed . Many thanks

@rachelvigil2092 4 жыл бұрын

This video is my new hero! Thank you!

@katiemorse39 4 жыл бұрын

Great application example. Thank you!

@jamesevins800 2 жыл бұрын

Developing a systematic protocol for labeling files in a consistent fashion is key to making this sort of list manipulation easy. Example: C:\Folder\genre\Last name\first name\project name\city\state\zip code\milage\ etc. etc. You can use dashes or underscores instead of back slash, but you get the point. As long as you keep the file label consistent this is massively useful.

@cy7632 4 жыл бұрын

This video helps me alot!!!!Thank you!

@daves9355 2 жыл бұрын

Excellent job. Thank you!

@carlb9009 3 жыл бұрын

Great explanation! Many thanks

@jazzyjeffred 5 жыл бұрын

Thank you for this simple solution.

@e11world 5 жыл бұрын

Great video. Now I will try to get all that done automatically every I add a new file/folder to update that excel sheet automatically.

@RJ-yv5gr 5 жыл бұрын

It's an easy and fastest method of copying files. Thank you

@mindwhacker 4 жыл бұрын

this is so helpful! I learned a new thing today! Thanks :)

@SunnyLeah 4 жыл бұрын

Very helpful video and exactly what I was looking for.

@JoeDaddy4321 4 жыл бұрын

Thanks, found what I needed in 1:20. Much appreciated.

@colleenwivell6234 4 жыл бұрын

Perfect: just what I needed, but couldn't figure out on my own.

@KevsGuide 6 жыл бұрын

BRILLIANT :) thank you my man

@emilycohan 5 жыл бұрын

Thanks for the video - fun to learn something new today :)

@BradPosey83 3 жыл бұрын

Thank you very much. Was able to set up my video files for easy access.

@pavan_bayini1283 4 жыл бұрын

This is very help full for maintaining files, Thank you for sharing

@AnshulDeorane 4 жыл бұрын

Thank you so much, saved me hours of time

@tarantulabandung487 5 жыл бұрын

thank you,.. exactly what i needed

@sabbumaharjan3 4 жыл бұрын

Thank you for this video!!

@guitarsonicsada3411 3 жыл бұрын

Thanks. Saved lot of time

@exampleforsurvey5980 4 жыл бұрын

Saved me hours. Thank you!

@staciedesalvo3810 2 жыл бұрын

Outstanding video tutorial. Thank you

@gloriaruiz13 5 жыл бұрын

You are my Hero...Thank you for the Tips

@mehdikrishanbutan 4 жыл бұрын

Hi dear trillions of thanks it solved my biggest problem even I was having multiple *.pdf in the Folder

@autotechchannel8774 4 жыл бұрын

Thank you so much..!! It works so nice.

@donaldbritz7406 3 жыл бұрын

Mooi! Michael, from one expat Saffer to another, this is just perfect! Thank you / Baie Dankie

@douglasbookless3761 4 жыл бұрын

Thanks Michael. I have been using dos and a .bat file; and freaked out my replacement. This is a whole lot easier! She Thanks You!

@aminfadaei419 4 жыл бұрын

it was really helpful. appreciate that.

@johnsonaci 4 жыл бұрын

Perfect, thank you very much for sharing this.

@jcartwrightsmith 4 жыл бұрын

Excellent! Thank you. Very clear.

@TheRainwalker47 4 жыл бұрын

This is what I need! Thanks a lot!