Quickly creating a list of files in a folder

This tip explains how to create a list of files that are in a folder.

[johnvukelic]

Six years later and this still works. Bravo! Helped me a lot.

[marcborgan]

This is the easiest of all the solutions (many very convoluted!) on YouTube.
Thanks, Matt!

[elixirmedicalsltd]

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

[thejekill]

8 years later and your video just saved my day. Struggling with a solution fot this a week now! Thank you

[stephaneenglish]

Thanks for “copy as path”. The other option I’ve been using is Alt+D to go into the address bar, then type CMD to open the DOS command window, then type “dir /b >!files.txt”, which puts a full list of files (without path names) into a file called !files.txt.

[StephenHarristnt]

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.

[wheredidileavemycell]

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.

[JennyDinVa]

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!

[sejembalm]

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.

[TotalRookie_LV]

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!

[tonytawa]

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.

[SchnaizenTNT]

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

[pirajacinto]

Still is literally the best tutorial ever. SO easy, so quick to figure out. And changes everything. Thanks for making this video :)

[adelhunt]

"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.

[johnm]

This is brilliant - Straight to the point, clear with no waffle! Came across this after 30 mins or so searching this topic and getting no where

[deb]

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!

[michaelwalker]

Thank you very much! I have already created lists for two 250 item folders. This has saved me so much time!

[ralphboas]

great tips - here is a summary to make a list of files in a folder
1. Select all files
2. Alt shift right click copy as path
3. In Excel not google drive – click data, text to columns, be sure delimited is checked and put a backslash \ in “other” box, hit enter twice
4. Use ctl H to find and replace .docx or other file extension with nothing if you don't want the file extensions

[pamelawile]

Thank you so much. All the other instructions were complicated and I couldn't get the paths right. This one worked like a charm.

[BadgerFlatsGazette]

Finally, someone who can explain stuff clearly and quickly. Thank you so very Great job!