If you're using Windows 11, instead of using '/d' in the command, use '/b'. For example: dir /b > list.txt Microsoft changed the way dir commands function in Windows 11 and you now have to use the /b tag to generate a list that's easy to paste into Excel. Using /d will end up with a wrapped list with two filenames per row instead of one, which makes pasting into Excel a CHORE to the point where it'd be more time-efficient to just manually go through each file and rename them yourself in file explorer. If you use /b, it will generate a list formatted the same way as the list that's used in this video.
This was extremely helpful. Thank you. For those who are getting two columns instead of a single column, type in: dir /b => filename.txt This worked better for me.
Thank you so much for this! FYI it also works with items in sub-directories I had 17,000 files from a crashed hard drive that were all named Thumb1 2 or 3. They were all in different folders but until I used this with the directory path and file name I was going to have to manually change all the names. This saved me HOURS & HOURS of time to recover these pictures of my kids. Thank you!
Thank you for the video, this worked perfectly! Note: If command prompt won't let you paste, right click on the window's title bar then open the Properties. Then enable Ctrl+Shift+V !
Thank you very much! I had to modify part of the formula to """"&A2&B2&"""" because the extension was missing from the original file for some reason. But it worked, saved me lots of time.
I used this to remove the "(2) - Copy" from all files after separating the originals to a different folder. Excel was perfect for this becasue the formula makes it much easier for different file types too. Pro Tip: I had to do this in a Network folder I could not cd into. In that case, add a column for filepath to go in the equation and it will work the same if you have write access. Example: a new column for filepath = 'V:\user\home enamedFiles\' I placed this in the E column then equation becomes: =D2&" """&E2&A2&""" """&C2&B2&""""
Thank you so much you really helped me. But.. in a different way :D I was using other easier tutorial from a to z but it didn't work. So I changed only last step from that other tutorial and I have added quotes (") to the files name. And it worked like magic. Thank you so much ❤️
That works but to a point. I did all that you suggested, but then what happened was that there's 116 pictures in my folder, and when it got to the 26th picture, it started adding the number in parenthesis starting with (1) again?????
I was looking to batch rename files in Linux but decided to take a look at your video just for curiosity. Result: I'm so glad I don't use this windows crap...
amazing, very useful.....only one problem i have faced is in the video you said to type "dir/d=>filename.txt" it creates file but in that, file names have no order or not came one by one, it came infront of each other..... so i tried /b insted of /d and i got proper results. (i did it blindly) can you pls explain what is reason behind that??
Fantastic...!!! Awesome.....you never know what did you do.. My work is almost reduced to 2 mins from 20 hrs In renaming thousands of files every month.
thanks but i had a problem, I am able to rename only 50% files, please help me to resolve this problem. i need another help, may i take all data from different sheets (more than 500 sheets) in one sheet only in excel
Yes you can get as there is a option in Excel to get data from the folder... You have to just put all (500 Excel) into that folder... If you want we can make a separate video on the same.
aside from the horrible music, if you wanted to rename it that way, you could've just, selected all and renamed a single file and windows would number the rest.
6 years later you are still saving lives. Thanks!
OMG! Thank you sooo much, I changed 62000 file names in a matter of minutes with this. you are the real lifesaver. !!
Thank you so much for your valuable feedback... Glad to know it works...
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
If you're using Windows 11, instead of using '/d' in the command, use '/b'. For example:
dir /b > list.txt
Microsoft changed the way dir commands function in Windows 11 and you now have to use the /b tag to generate a list that's easy to paste into Excel. Using /d will end up with a wrapped list with two filenames per row instead of one, which makes pasting into Excel a CHORE to the point where it'd be more time-efficient to just manually go through each file and rename them yourself in file explorer. If you use /b, it will generate a list formatted the same way as the list that's used in this video.
Thank you
This was extremely helpful. Thank you.
For those who are getting two columns instead of a single column, type in: dir /b => filename.txt
This worked better for me.
Thanks for sharing! Glad to know it help to you...
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
Thanks mate
thank you my hero
Holy shit it worked, thanks bro.
Thank you so much for this! FYI it also works with items in sub-directories I had 17,000 files from a crashed hard drive that were all named Thumb1 2 or 3. They were all in different folders but until I used this with the directory path and file name I was going to have to manually change all the names. This saved me HOURS & HOURS of time to recover these pictures of my kids. Thank you!
Really appreciate for your awesome feedback...
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
Man on 2022 this was a life saver for me, thanks a lot.
Thank you so much dear for your awesome feedback
Thank you for the video, this worked perfectly! Note: If command prompt won't let you paste, right click on the window's title bar then open the Properties. Then enable Ctrl+Shift+V !
Thank you
The music made me feel like a hacker for a while gaining access to confidential stuff lol
LOL, will try another BGM in next time.. thanks for your comment.
Lol true, gr8 video tho
lmao my dude :D
Same😅
it make me feel like doing this is illegal
I love how the music makes it seem like it's the task of all tasks, and then the song repeats, for good measure.
Thank you so much for your kind reply...
This deserves a thumbs up man. Cheers!
Thanks for your awesome comment. Cheers!
Thankyou bhaijaan, mai 2 din se isme phasa tha
Most welcome Bhai.. don't forget to subscribe our channel 😁
Thanks. It's really helpful. Just that your written instructions are to quite convincing but after all my work is successfully finished. Thanks again
Great to hear! and i'm working on English language and try to give best.. thank you so much once again.
Thank you so much! Well explained and this method will save me time especially renaming photos one by one which will waste my time. Much obliged!
Thank you
Thank you, thank you, thank you. That was exactly what i was looking for. you are a real life saver. Absolutely brilliantly explained
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
The epic music made it feel like I was hacking into pentagon files.
YOU HELPED ME SO MUCH TY I LOVE YOU
WOW... I wanted just this but couldnt find it anywhere... A BIG THUMBS UP FROM ME
Thank you very much! I had to modify part of the formula to """"&A2&B2&"""" because the extension was missing from the original file for some reason. But it worked, saved me lots of time.
Glad it helped! and thank you for your valuable comment on the same.
I used this to remove the "(2) - Copy" from all files after separating the originals to a different folder. Excel was perfect for this becasue the formula makes it much easier for different file types too.
Pro Tip: I had to do this in a Network folder I could not cd into. In that case, add a column for filepath to go in the equation and it will work the same if you have write access.
Example:
a new column for filepath = 'V:\user\home
enamedFiles\'
I placed this in the E column
then equation becomes: =D2&" """&E2&A2&""" """&C2&B2&""""
thanks for the great tips. so we can even rename with any kind of rename varieties using batch command...
Thank you so much bro you saved my 4hours of time 🙌
Thank you
cool!! I managed to change my filename by follow the step show in the video~ Thank you!!!
The genius way. Brillian .... Finished click subcribe, thumbs up, & bells.
thank you so much for subscribing and also for liking this video..
Thank you so much for this! it hepls me so so much .
Thank you for your kind feedback... Don't forget to subscribe for new updates
Mind blowing its working yaar .. love and thank you so much
Thank you
Great. Thank you very much!
Amazing Tutorial, This trick work for me, thanks a lot ❤️🙏🏻
Very useful and i use it 2021 thanks bro 👍🏽
Thank You So Much. It worked for me. Hats off
Thank you so much for your awesome feedback...
Very nice video.....
Teaching without Words...
Awesome Bro
Yeah... Btw thank you so much...
Loved it! You saved us.
Thanks
Thanks a lot! you saved me so much time and my colleagues are impressed 🙏🏼🙏🏼🙏🏼
Cheers dear... Thank you for your feedback!💐
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
Thank you, this was exactly what I needed. Saved me hours :)
thank you so much... glad to know
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
Thank you so much you really helped me.
But.. in a different way :D
I was using other easier tutorial from a to z but it didn't work. So I changed only last step from that other tutorial and I have added quotes (") to the files name. And it worked like magic. Thank you so much ❤️
I also used ren command from your tutorial instead of a rename command from other guys tutorial :) I'm so happy thanks :)
Wooooooooooh....thanks a lot buddy
2:30 dir /d => filename.txt
6:34 ren "old name.extension" "new name.extension"
That works but to a point. I did all that you suggested, but then what happened was that there's 116 pictures in my folder, and when it got to the 26th picture, it started adding the number in parenthesis starting with (1) again?????
Worked perfectly, thank you!!
VERY HELPFUL! THANKS
Thank you so much 😊
This trick was help me a lot, thankyou
Thank you so much for your valuable comment
Thanks for Helping!
great lil excel hack, I like it ;)
This was is very helpful thanks for sharing mate
Thank you for your feedback dear...
I was looking to batch rename files in Linux but decided to take a look at your video just for curiosity. Result: I'm so glad I don't use this windows crap...
thanks for your comment...
That was a game changer! Thank you so much!
Thank you so much for your comments...
Very very informative & useful information
Please please..make a video again in full details
Okay, thank you
This was amazing! Thank you
Thank you for this amazing videos, I subbed.
Thank you so much... Appreciate it
Bro, you got some excellent skills bro 🤐👍👍👍👍
Now I wish every tutorial on youtube has an epic music background in it..
lol ikr, that'll really draw your attention and make file renaming in windows 10 more intense.
LOL, right...
Exactly what I needed. Thanks!
glad to know! thanks
Thank you for this video it was very helpful
Thank you so much
thank you so much, its very helpful
Glad to hear that!
Wow, this is purely amazing! Thanks a ton for sharing this invaluable tip!
Glad it was helpful!
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
awesome tutorial! many thanks!
Glad it was helpful!
amazing, very useful.....only one problem i have faced is in the video you said to type "dir/d=>filename.txt" it creates file but in that, file names have no order or not came one by one, it came infront of each other..... so i tried /b insted of /d and i got proper results. (i did it blindly) can you pls explain what is reason behind that??
wow, this was exactly my probblem. How do you solve it?
THank YOU Bro.... Saved some precious time...
Thank you dear for your valuable feedback. I help to make more video.
Thank you 😊 saved me a massive job with 100 odd files!!!
Thank you so much for your valuable feedback. Cheers!
Thank you so much for this bro
Thanks buddy, cheers!
Excellent my dear friend - you are awesome!! thanks from heart Bro!!
Thank you so much dear for your valuable comment...
You r a savior man 🤗🤗
Thank you bro.. it saves lot of time.. :)
Thank you dear.
how about for folders?
Thank you !!!!
You saved me . 😁
Thanks a lot, buddy. This is a very helpful tutorial.
Glad it helped
Helpful indeed! Thanks
Glad it was helpful!
You can use batch files renamer tool for this too..
It’s amazing I tried it and it worked for me 🎉
Thanks for your feedback
So helpful, thank you
Thanks you very much.
Thank you so much
You're most welcome
It is good trick. Appreciate it.
Thank you so much... Glad to know
My dude has the background music of an epic quest 10/10
Football world cups
Thanks alot! top job
WTF YOU ARE THE BEST BRO SABOONER AND LIKE TNX
thanks buddy...
Awesome thank you!
Great! It saved my time!
Glad it helped!
Fantastic...!!!
Awesome.....you never know what did you do..
My work is almost reduced to 2 mins from 20 hrs
In renaming thousands of files every month.
ohh wow, glad to know! thank you so much for your valuable comment on the same.
How to delete multiple files with only one particular character in it?
Will make a separate video on the same
Thank you so much ☺️☺️
Thank you for this :) It help a lot
Glad to know
THANK YOU SIR.... IT'S WORKING
Thanks
Excellent tutorial, thank you so much! Came in handy.
Thank you so much for your comment.
Yeh he kaam ki video, updated ideas of file rename - ua-cam.com/video/N_Gz72qv6ds/v-deo.html
You are amazing!
Really useful thank you..
Thank you for your comment.
thanks! does it work with folders renaming?
God bless you. Saved me so hard. :D
pls help if i want to insert different files name on the 1st page of multiple PDF files at once.
thanks but i had a problem, I am able to rename only 50% files, please help me to resolve this problem. i need another help, may i take all data from different sheets (more than 500 sheets) in one sheet only in excel
Yes you can get as there is a option in Excel to get data from the folder... You have to just put all (500 Excel) into that folder... If you want we can make a separate video on the same.
NYC information
Thanks buddy..
aside from the horrible music, if you wanted to rename it that way, you could've just, selected all and renamed a single file and windows would number the rest.
This single comment helped me in under 10 seconds
Thank you bro..
need to know how did you get ext. so quickly. did u use any shortcut key or manually?
yeah, i used it CTRL+E. there is option in MS EXCEL 2013 which is called Flash FIll...
instead filename.txt you can type filename.xlsx. then you don't need to copy from txt to excel file.
i try but in excel file has not anuthing.
zoom in zoom out thing - spinned my head
Why not type all your text in the notepad beforehand? Or use text-to-speech generator.
THANK YOU !
You're welcome!
Hi thx for the tutorial same I have one request how to rename photos in bulk ? Pls guide me
thanks
Super thanks a lot