This tip explains how to create a list of files that are in a folder.
Пікірлер: 415
@thejekill99075 күн бұрын
8 years later and your video just saved my day. Struggling with a solution fot this a week now! Thank you
@johnvukelic16022 жыл бұрын
Six years later and this still works. Bravo! Helped me a lot.
@marcborgan57027 жыл бұрын
This is the easiest of all the solutions (many very convoluted!) on KZbin. Thanks, Matt!
@StephenHarristnt7 жыл бұрын
I have been trying several methods noted online to do this and I must say that this is by FAR the best way and the best-explained way I've found - EXCELLENT! Thank you so much for sharing.
@JennyDinVa4 жыл бұрын
This is THE best tutorial I ever saw. I can't thank you enough! I had thousands of files I needed to list and this way was the easiest, the fastest, and the best I've ever tried. A million Thanks!
@deb61566 жыл бұрын
I watched other videos before I found yours. Yours was short and sweet! I totally understood everything and was able to use it right away. Thanks SO much!
@Astreving4 жыл бұрын
You have no idea for how long I have been looking for something like that! :D Thanks!
@pirajacinto43 жыл бұрын
Still is literally the best tutorial ever. SO easy, so quick to figure out. And changes everything. Thanks for making this video :)
@mnrd3411 ай бұрын
I am absolutely thrilled that you made this tut ... appreciate it to the end and back!
@maddien1933 жыл бұрын
Thank you so much, Matt, for solving my problem of printing genealogy file names (most are photo's or scans.) I couldn't figure out how to print the list without the images. This is by far the easiest answer I have found.....and it works!! Thank you again!!
@leevc46315 жыл бұрын
This is the best solution to this problem I've ever seen. Thank you.
@gosia304 жыл бұрын
YOU HAVE SAVED ME MORE THAN ONCE WITH THIS VIDEO MAN, MASSIVE THANK YOU!!!
@michaelwalker69072 жыл бұрын
Thank you very much! I have already created lists for two 250 item folders. This has saved me so much time!
@garymills68067 жыл бұрын
Thanks Matt, for taking the time to make this video. It was very helpful.
@tonytawa90657 жыл бұрын
Thank you Matt - tried following instructions in other videos; yours was the only one that was useful and informative, and most importantly understandable - extremely helpful. You did a great job.
@elixirmedicalsltd72438 ай бұрын
Great tip Matt, Just some additions Quick tip-1: Instead splitting the data into columns, copy the filepath from the Windows Explorer and use replace in Excel for the list of file paths and simply replace using Ctrl+H (replace) and you will save a little more time sorting the data. Quick tip-2: You may as well use simply Shift + right click on your mouse to access "Copy as path" option. Quick tip-3: you can create a renamer.xls excel file for yourselves with REN Dos script Or can create a DOS script batch file that can change file names as it has been run each time. Scripts are available on internet for better automation. I often rename 100+ files weekly during my research and work Thank you so much
@sharathnarayanan5 ай бұрын
How to use ren dos command?
@magdageor78983 жыл бұрын
God bless you! I was trying for so long to find a way to do that. You made two people me and my friend happy today.Thank you!!
@wheredidileavemycell7 жыл бұрын
instead of going to data, you could just copy everything on the path except the file name, select the column ctrl+f to replace the path with nothing & it will erase the extra stuff in the column except the file name. may be faster for you.
@kevintate57695 жыл бұрын
Thank you both. The ctrl+f idea was must faster for larger separate folders.
@Keith95344 жыл бұрын
How can you copy everything on the path except the filename for multiple files? Have I missed something?
@Keith95344 жыл бұрын
Thanks...I worked it out
@TotalRookie_LV8 ай бұрын
Thank you! Really needed this, as I had an Excel list of 104 positions, yet only 102 files to cut out detail layouts. So I could either go through the list checking each position to find those two missing numbers or... Worked perfectly!
@Deb.-on9ep5 жыл бұрын
Awesome Matt. You made it quick and simple. Don't get that too often!!!! Thanks....
@MotiviqueStudio3 жыл бұрын
Thanks for this. So many videos going into the command prompt, this is so much simpler.
@lindadunn2031 Жыл бұрын
Great been looking for this for years. Crazy it took so long to find.
@13Danb136 жыл бұрын
Matt, that is awesome. I have tried several instructions, some quite complex without the results I was shooting for. THANKS
@worcestersorcerer6 жыл бұрын
Great, many thanks! I have a lot of folder names to organise, this makes my day a lot easier!
@lynnrichardson46984 жыл бұрын
This was absolutely the BEST! Thanks for all the help.
@flotationisgroovy6 жыл бұрын
Nicely done and you don't waste any time getting to the information. Thanks!
@almoore81323 жыл бұрын
Great tip Matt! Exactly what I wanted too do.
@larryhawkins27647 жыл бұрын
I want to thank you so much for your help and direction on this project. I really appreciate it.
@CHARCHICHI7 жыл бұрын
You just made my job easy! Tutorial after tutorial, command prompt after command prompt! This was so simple! Thanks!
@pamelawile87382 ай бұрын
Thank you so much. All the other instructions were complicated and I couldn't get the paths right. This one worked like a charm.
@colinjenkins88254 жыл бұрын
Absolutely brilliant, thank you so much Matt
@squirtmph5 жыл бұрын
thank you very much for clean explanation how to do these, I have being looking for these tutorial for hours in the web! Thank you
@gsau30003 жыл бұрын
Great tip. Easier than other tutorials that show how to use cmd. Holding shift on its own works too.
@quackedup49694 жыл бұрын
Great tip. Thank you for posting it. You totally saved me some frustration!
@evanchurch35495 ай бұрын
I appreciate this! I tried for a while using command prompts but could never figure it out. This way worked perfectly for me.
@johnbarsby83824 жыл бұрын
Just brilliant. Exactly what I was looking for.
@francinelopacinski67059 ай бұрын
Exactly what I needed and quickly. Super easy! Thank you!
@bucket0094 жыл бұрын
Thank you Matt! I’ve been struggling to do this for a long time. Your explanation was perfect 👌🏾
@harryrayeroux23454 жыл бұрын
You are a Gem, best tip i have come across on this subject. Thank you
@3bearsgayming4 жыл бұрын
thanks so much for this, it's such a specific thing to need but a huge time saver!
@amityjones81003 жыл бұрын
Thank you for the easy to follow tutorial😊 I can now make my recipe book a nice table of contents. Keep up the great work!
@Allen750004 жыл бұрын
Straight to the point, thanks Matt!
@conanliquid3 жыл бұрын
Nice one man. You saved me a day of typing up a list of Wav and MP3 files.
@petejameson37352 жыл бұрын
Absolutely fantastic! Thank you so much! I've been trying to figure out a way to do this for a loooooooong time. Excellent!!!
@daveemery122 жыл бұрын
Love the Alt-Shift-Rt Click tip. Thank you.
@indivdiff3 жыл бұрын
Wow, thank you for this. Massively appreciated
@ipassnotes3 жыл бұрын
I had almost 500 file names to copy......Dude, I owe you a solid !!!!
@Tuggadgurka4 жыл бұрын
Wow....just wow. This is so great, thanks a million for showing this tip!!!
@dermontbud27984 жыл бұрын
Amazing! I was desperate trying to do that. Matt Lanham, you saved my week. 👏 👏 👏
@scotthooper81044 жыл бұрын
Awesome! Great tip Matt! Thanks!
@avantgarde79563 жыл бұрын
Excellent tip! Saved me hours! Thanks!
@NicksNKnacks Жыл бұрын
OH MY GOD!! THANK YOU!!! Life saver. I was worried I would spend half of my day either copying or deleting text.
@krystalgilliam644110 ай бұрын
This was EXTREMELY helpful! I didn't know about the secret menu... TYSM
@anthonymiles23024 жыл бұрын
This is a great tip. Just what I was looking for.
@MandyFoxMathsTutor Жыл бұрын
Thank you so much for this video! You have saved me HOURS of work!
@michaelzhuhovitsky38892 жыл бұрын
Seriously. Bless you. just saved me about 5 hours of work.
@jgparmele4 жыл бұрын
Thanks so much for this! Exactly what I needed.
@derekjaydjchinatown3 жыл бұрын
I've been looking for something like this for ages, thanks for the assistance
@kevinmoore87804 жыл бұрын
Thank you. This was much faster and easier than other options and even some software that I downloaded.
@michaeldenton20964 жыл бұрын
This was an awesome video of a lesson. Well done.
@hkn19822 жыл бұрын
Dear Matt, a very useful method and thank you...
@lindaclarkson9679 Жыл бұрын
Thank you, thank you, thank you. That was so easy to follow and you've saved me hours of work.
@thomreynolds56517 жыл бұрын
YOU THE MAAAAAAAAN!!!! SAVED ME A BUNCH OF WORK!!!!
@discipleswrath054 жыл бұрын
Thanks for the tip Matt, you saved me hours of typing.
@devonmccauley53326 жыл бұрын
You just blew my mind!! Thanks!!
@briantully91714 жыл бұрын
Cheers Matt. Worked a treat
@radhakrishnamurthygummadi47135 жыл бұрын
Thank you.... Very Much Matt Lanham.... This tip was useful to me work. Once again thank you Matt.
@addipoom Жыл бұрын
Thanks, mate, for a solution, for not selling us some software, for being a good person
@papalegba4449 Жыл бұрын
Bruh... no registry or cmd rubbish, this was so easy. Thank you!
@ryzeonline9 ай бұрын
Absolutely brilliant. I don't even know what to say. Thank you.
@reubenha17 жыл бұрын
SUPER COOL! This is soooo useful! Million thanks!
@ez_does_it8 ай бұрын
Thanks! Very helpful. Wished I had searched for it sooner!
@missycj996 жыл бұрын
Thank you so very much. I have been trying to do this for years.
@sejembalm5 жыл бұрын
This works with Notepad as well. Sort files (by name, type, size, etc.), select file, hit Ctrl A to select all files, hold Alt + Shift & right-click file, click copy as path, open Notepad, paste, then click Edit then Replace and tidy up the list by replacing the file location data (such as C:\Videos\) with a blank replacement.
@gerryohara84972 жыл бұрын
Yes, exactly what I did but in Word. I imagine this technique would work in almost all word processing programs available.
@OutsidersJourney Жыл бұрын
thanks
@TheOnibar7 ай бұрын
Thanks dude...
@adelhunt34992 жыл бұрын
"Copy as path" was the tip I needed. My only suggestion for improvement would be to use "Replace" afterwards to simple remove the extra folder location details. It's much faster if you're just wanting the file names and can be done in Excel or Word.
@666cowboy692 жыл бұрын
same copy as path is what i needed i dont have excel or word installed.
@michaelstrom69819 ай бұрын
was going to write the same. find/replace to blank is much easier then messing with text to columns.
@splashdoggy6 жыл бұрын
Thank you! Easy to follow, clear instructions.
@Jaota826 жыл бұрын
Thank you sir. This save me many hours of work!
@vipulagarwal73208 ай бұрын
Super Amazing! Thanks for explaining the process. I had a requirement like this just today and Voila!
@harpersneil3 жыл бұрын
Massively useful video - thank you!
@dawynn93626 жыл бұрын
Top result in Google searches for "copy name of file to excel" is a video of how to do it using CMD, which worked. But this is a LOT quicker; Ctrl+a then alt+shift then copy. Your video was auto played after the last one. Thanks!
@Deut33277 жыл бұрын
This was so easy to understand, and really helpful! Thank you!
@cesarvargas.5493 Жыл бұрын
You rock man! sometimes the best solution is so simple!
@gillianshaw17112 жыл бұрын
Thanks Heaps! Saved me so much time!
@SchnaizenTNT4 жыл бұрын
This is better. (This mode save folders and subfolders) 1. Open CMD 2. Go to the folder you want to save. 3. write dir /a /s /b > File_Name.CSV /a Show all files /s Include all subfolders. /b Bare format
@brendasexton60383 жыл бұрын
This is awesome! So easy to follow - thank you!
@matthewsjc14 жыл бұрын
Thank you!!! This will be incredibly helpful at work!
@gringomalo333 жыл бұрын
You saved me hours of work. Thank you!!!
@RobVaughan19847 жыл бұрын
i have been trying to do this for years, trying to find a program to do it... thank you so much!!
@mattschoular88446 жыл бұрын
Use power query. It's built into excel. Worth learning. See excelisfun on youtube. Mike girvin is a guru
@harrywiersum58754 жыл бұрын
Great, this is where I was searching for
@mikeprivate2003 Жыл бұрын
Thank you, Matt!
@ameervip2003 Жыл бұрын
Thanks for this. Helped me today.
@mailtovikas6 жыл бұрын
THANKS MAN ,THAT'S MORE EASY WAY THAN USING COMMAND PROMPT, YOU SAVED MY TIME .
@thumpingbasscreation43395 жыл бұрын
Wow really wow. I don't have words. Thank you very much sir.
@annethompson60213 жыл бұрын
Brilliant tip, been trying to do that for ages, Matt taaught me how in 3 minutes
@emac36283 жыл бұрын
just open cmd pointed at the directory (just type cmd into the bar that has the path at top of explorer) then type the below expression, changing list.txt to whichever name and format you want. type this---> dir /b >list.txt
@eiggjohn7 жыл бұрын
This was great! He's a good teacher.
@mrm26895 жыл бұрын
Dear Matt Many thanks for this video. It was very helpful.