Hi Doug, Thanks for another great tip. Another work around (I think it is simpler): Copy the folder address into the web browser address bar and hit enter. You get a linked list of all the files. Copy & paste into excel. Remove the unnecessary data.
When I do this using IE11 all that happens is that another Windows Explorer window opens and I'm back to the same point that Doug started off at in his video.
@@DougHExcel Hey man - Oh cool nice to hear from you - I got it right with my updated file - I have 450 paintings I want to put in my spread sheet - big saver
how would you ommit the file format in the imported text (.txt , .mp3) or choose to only import a curtain file type? very helpful video by the way... THANKS
there is a faster method highlight the files and right click on one of them while pressing shift down this gives you the 'copy as path' option copy the paths and paste it in the spreadsheet use formula to extract file names
what about subfolders and their content? I have bunch of files inside several folders? I wanted to get their date info so I can easily sort it out in excel.
Excellent tutorial. Thanks a lot. But I have a slightly different issue to deal with. I have more than 1000 files in a single folder, they are all images transferred from my mobile phones. They are named image 1.jpg, image 2.jpg and so on. There is an intentional space in the names of these images/files. When I followed your tutorial everything went fine except the fact that while using delimiters I chose two Tab and Space and the final result was - all the filenames were divided into 2 separate columns, ie "image" (in one column) and "1.jpg" in another column. I want it to be one column only ie "image 1.jpg", I know that the intentional space within the filenames is causing this problem, but how do I deal with this? Thanks a lot.
to delete the extension, hit Ctrl+H. a window opens. enter 'extension' to "Find what", leave "Replace with" blank. you can use the Sort option to arrange by date.
You're Welcome! I'll have a video out later this month that covers how to do this but using a feature in Excel without going into CMD mode. Stay tuned!
use “dos dir” have Problem，if the file have “&” not use “dir”。 For example :APPLE &YE will error 。 use export.bat↓ c:/ CD/window/tee dir >test.txt or test.xls but d:/ cd/APPLE &YE dir >test.txt or test.xls must ERROR
But if you want to do it a quick way: Select files in win explorer, Home/Copy as Path, paste in Excel, Ctrl + H for Find & Replace, put *\ in find, Replace All = you have only the file names (with extensions, if your folder settings are such)
You can get rid of the redundant information by adding an option. The cmd command would look like this: dir *.* >contents.tx /b /on The /b option means "bare format", The /on option sorts the result, it means "order" "name" You can find all options by typing [dir /?] (without the square brackets). These options saves you a lot of manipulation of the data. You can open the text file and then copy paste the result, instead of importing and choosing the formatting, which I think is very annoying.
There are not enough likes in this video. This is SO helpful. I've had this video bookmarked for years.
Thanks so much for the kind words!
wow at last ,,,a clear concise easy to follow vid without silly background music..
why cant all how to vids be like this....brilliant
Thanks for the comment!
Hi Doug,
Thanks for another great tip.
Another work around (I think it is simpler): Copy the folder address into the web browser address bar and hit enter. You get a linked list of all the files. Copy & paste into excel. Remove the unnecessary data.
When I do this using IE11 all that happens is that another Windows Explorer window opens and I'm back to the same point that Doug started off at in his video.
That's a real trick, thanks
Thanks ! You saved hours of my life when my only option looked like typing out a list by hand ...
You're Welcome!
Thanks for helping to view the files with cmd. remembering the olden days with CD , MD, and del. Thank you once again very useful tip.
Nice one Doug - I liked how nice and clear this was - thanks a stack man - I am NOT a cmd user and I got it - so... kudos to you
Hi Stephen Quirke, glad you liked it, thanks for commenting!
@@DougHExcel Hey man - Oh cool nice to hear from you - I got it right with my updated file - I have 450 paintings I want to put in my spread sheet - big saver
If you do this on a recurring basis, u might want to try power query th-cam.com/video/F1jMeWA4Law/w-d-xo.html
Always wanted to do this but never knew how. Thanks a bunch, Doug!
You're welcome. There's even a better way to do this with Power Query th-cam.com/video/F1jMeWA4Law/w-d-xo.html
Old School, for sure!
good vid, I did a lot of stuff with Access back in the day , haven't touched it in years :)
Hi Wag2112, thanks for the comment!
Really useful. Appreciate it.
Glad it was helpful!
Thank you so much. This is useful incase you wanna keep a track of files you lost after some data corruption !
Hi Dev S, glad you liked it, thanks for commenting!
i cant tell you how much this helped. i subscribed and liked the viodeo for your help. god bless you!
Thanks HisNameIs Greatest, glad it helped!
Nice, that was easy!
Hi Curtis Hargreaves, thanks for the comment!
What software are you using to create that image with the rough edges?
That's Snagit
That is cool Thanks Doug!
how would you ommit the file format in the imported text (.txt , .mp3) or choose to only import a curtain file type?
very helpful video by the way... THANKS
You may want to try using power query. See this video th-cam.com/video/F1jMeWA4Law/w-d-xo.html
Doug H 9 thanks
Holy shit, thanks for such easy old school trick.
I spend the whole day searching how to achieve this by python scripts or VBA macros...
Glad it helped!
Back to school. Great!
Hi Sandeep Kothari, thanks for the comment!
there is a faster method
highlight the files and right click on one of them while pressing shift down
this gives you the 'copy as path' option
copy the paths and paste it in the spreadsheet
use formula to extract file names
Thank you, much easier, but Doug thanks too
Hi Juho Lee, thanks for the comment!
God Bless man, this is a life saver!
Glad it helped!
Great video. Thank you!
Thanks for the comment!
Perfect! Thanks!👌
Hi Cirill Parnó, thanks for the comment!
Thank you Dough, it saved my time a lot :)
Hi Ikram Mahmood, glad you liked it, thanks for commenting!
awesome! thanks Doug
Hi Federico guglielmino, glad you liked it, thanks for commenting!
thank you this video was really Helpful
Thanks +Imraan khan, glad it helped!
Thanks +Imraan khan, glad it helped!
Thanks +Imraan khan, glad it helped!
Thanks +Imraan khan, glad it helped!
Thanks +Imraan khan, glad it helped!
what about subfolders and their content?
I have bunch of files inside several folders? I wanted to get their date info so I can easily sort it out in excel.
maybe Power Query can help th-cam.com/video/F1jMeWA4Law/w-d-xo.html
Great video. Thank you.
You're welcome. If you do this exercise often, Power Query is another way to do it and faster too -> th-cam.com/video/F1jMeWA4Law/w-d-xo.html
Helped alot ! Many Thanks :)
Glad it helped!
Awesome you saved my time, great thanks a lot
Hi Vinod K, glad you liked it, thanks for commenting!
how to go back in previous folder?
Excellent tutorial. Thanks a lot. But I have a slightly different issue to deal with. I have more than 1000 files in a single folder, they are all images transferred from my mobile phones. They are named image 1.jpg, image 2.jpg and so on. There is an intentional space in the names of these images/files. When I followed your tutorial everything went fine except the fact that while using delimiters I chose two Tab and Space and the final result was - all the filenames were divided into 2 separate columns, ie "image" (in one column) and "1.jpg" in another column. I want it to be one column only ie "image 1.jpg", I know that the intentional space within the filenames is causing this problem, but how do I deal with this? Thanks a lot.
Great, thanks a lot.
Hi james macintosh, thanks for the comment!
open note pad copy this dir /o /b /s >name.csv and save as name.bat , run it your directory ...that's it
thank you
Thank you Sir!!!
You’re welcome!
There is a faster method - after selecting the images in a folder, try the "copy path" function within the clipboard ribbon/tab in Excel.
Thanks for adding the knowledge!
Thank You!!!!
You're Welcome!
awesome thank you!
You're Welcome!
in windows 10 you can copy and paste from CMD directly just highlight and copy paste
Hi fpet1, thanks for adding to the thread!
If you just need the name "Shift right-click" in the explorer and select copy path, then paste inExcel
Hi Günther Wagner, thanks for adding to the thread!
perfect deal. It worked well.
Hi Henry johns, thanks for the comment!
I can't find, how to delete the extension, and how to arrange by date
to delete the extension, hit Ctrl+H. a window opens. enter 'extension' to "Find what", leave "Replace with" blank.
you can use the Sort option to arrange by date.
Hi Axel Schultz, thanks for the comment
Merci beaucoup.
You're Welcome!
Thanks Doug. I'm having a dos flashback.
You're Welcome! I'll have a video out later this month that covers how to do this but using a feature in Excel without going into CMD mode. Stay tuned!
thaaaaaank yooooouuuu!!!
You're Welcome!
how to extract other information like date, authors, size, etc
Try using power query for this th-cam.com/video/F1jMeWA4Law/w-d-xo.html
Make more such presentations using Ms DOS.
Hi Sandeep Kothari, thanks for the comment!
press shift + right click and now thers a option to copy the path. Right click and Paste in a excel file and cut the unnecessary information.
Power Query is prolly now a better option th-cam.com/video/F1jMeWA4Law/w-d-xo.html
use “dos dir” have Problem，if the file have “&” not use “dir”。
For example :APPLE &YE
will error 。
use export.bat↓
c:/
CD/window/tee
dir >test.txt or test.xls
but
d:/
cd/APPLE &YE
dir >test.txt or test.xls
must ERROR
See if Power Query works
th-cam.com/video/F1jMeWA4Law/w-d-xo.html
But if you want to do it a quick way: Select files in win explorer, Home/Copy as Path, paste in Excel, Ctrl + H for Find & Replace, put *\ in find, Replace All = you have only the file names (with extensions, if your folder settings are such)
thanks for adding to the thread!
and it works bingo thumbs up
Thanks!
You can get rid of the redundant information by adding an option. The cmd command would look like this: dir *.* >contents.tx /b /on
The /b option means "bare format",
The /on option sorts the result, it means "order" "name"
You can find all options by typing [dir /?] (without the square brackets).
These options saves you a lot of manipulation of the data. You can open the text file and then copy paste the result, instead of importing and choosing the formatting, which I think is very annoying.
Hi Ruben Moerbeek, thanks for adding to the thread!
Super
Thanks Dr Embaby!
how to copy file names from past few minutes?
If you have Power Query, it's another great tool to perform this. See th-cam.com/video/F1jMeWA4Law/w-d-xo.html
Use dir /b file*
Hi John Hopstick, thanks for the comment
helpful thanks!
Thanks!