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 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!
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 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 !
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&""""
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??
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...
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.
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.
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.
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?????
This so helpful, thank you 😁 ive doing a scanning project and it turns to it to rename all files. With differebt type of file name. I will practice this to make my work easy.
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.
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 ❤️
Hi, I can’t get to separate the extensions in another column in spreadsheet. How did you manage to separate different file types (.pdf,.txt, .docx etc.) to separate with a single click/command?
I managed to figure it out. highlight all of the cells underneath the "Ext." column hit ctrl + F click on "Replace" and set these values: Find what: *. Replace with: . then just click replace all (this will set the default value to this) Then if you want to continue, just highlight the cells and hit ctrl + R to get the same effect since default values are set.
Hi I'm curious if there anyway to rename image file inside a folder same as the parent folder name? Because I have more than 2000 folder of products with folder name something like WJ70066190PR, WJ70066191PR and I want all images inside of the folder get WJ70066190PR.jpg WJ70066191PR.jpg
Hi, I am not able to rename the file which file name are long, if the file which I want to rename has already short file name in that case it's working but for the long filename this formula is not working. Please advise
@@Everythintechy Hi, thanks for your comment, for example this is file name " Certified Final (IDC completed) Proj Doc No MGP1-P4020MR019-C04-0001 Revision 004 Title INSTRUMENT BILL OF MATERIAL (BOM) FOR CORROSION INHIBITOR INJECTION PACKAGE (GP2-A-15702) Current Status 6 - Information.msg " and its extension is .MSG. I am not able to rename it thru the formula.
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
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
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
6 years later you are still saving lives. Thanks!
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
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 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
Man on 2022 this was a life saver for me, thanks a lot.
Thank you so much dear for your awesome feedback
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...
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. 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.
The epic music made it feel like I was hacking into pentagon files.
This deserves a thumbs up man. Cheers!
Thanks for your awesome comment. Cheers!
thanks for the great tips. so we can even rename with any kind of rename varieties using batch command...
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 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
2:30 dir /d => filename.txt
6:34 ren "old name.extension" "new name.extension"
YOU HELPED ME SO MUCH TY I LOVE YOU
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...
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.
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
WOW... I wanted just this but couldnt find it anywhere... A BIG THUMBS UP FROM ME
Is it applicable for all windows version?
Yes!
Thankyou bhaijaan, mai 2 din se isme phasa tha
Most welcome Bhai.. don't forget to subscribe our channel 😁
Very very informative & useful information
Please please..make a video again in full details
Okay, thank you
thanks! does it work with folders renaming?
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
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...
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.
My dude has the background music of an epic quest 10/10
Football world cups
THank YOU Bro.... Saved some precious time...
Thank you dear for your valuable feedback. I help to make more video.
Thank you so much bro you saved my 4hours of time 🙌
Thank you
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...
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?????
How to delete multiple files with only one particular character in it?
Will make a separate video on the same
cool!! I managed to change my filename by follow the step show in the video~ Thank you!!!
how about for folders?
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.
pls help if i want to insert different files name on the 1st page of multiple PDF files at once.
VERY HELPFUL! THANKS
Thank you so much 😊
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
Loved it! You saved us.
Thanks
Is there a way to do it if the files are in D drive instead of C?
Why not type all your text in the notepad beforehand? Or use text-to-speech generator.
This so helpful, thank you 😁 ive doing a scanning project and it turns to it to rename all files. With differebt type of file name. I will practice this to make my work easy.
Thank you for your kind feedback, it help to make more like the same. Cheers.!
Great video but hated the music! However, thanks very much for creating the video!
Thank you for your feedback...
Mind blowing its working yaar .. love and thank you so much
Thank you
Amazing Tutorial, This trick work for me, thanks a lot ❤️🙏🏻
Thank you 😊 saved me a massive job with 100 odd files!!!
Thank you so much for your valuable feedback. Cheers!
Great. Thank you very much!
You can use batch files renamer tool for this too..
Hi thx for the tutorial same I have one request how to rename photos in bulk ? Pls guide me
I have problem with the font recognition, cmd can not read Vietnamese fonts, please help?
Please change the font from the Vietnamese to any English.. it might help... Thanks.
@@Everythintechy thanks, I found another way to copy all file names while keep the font format.
This trick was help me a lot, thankyou
Thank you so much for your valuable comment
Very nice video.....
Teaching without Words...
Awesome Bro
Yeah... Btw thank you so much...
in Linux.. it is much easier to do it. no painful this way.
single command does for all.
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.
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
Thanks for Helping!
Very useful and i use it 2021 thanks bro 👍🏽
zoom in zoom out thing - spinned my head
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 :)
great lil excel hack, I like it ;)
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. It worked for me. Hats off
Thank you so much for your awesome feedback...
what if i just want to remove the "copy"
Thank you for this video it was very helpful
Thank you so much
I want to replace one word in all files is it possible?
you can't save many file's with same name in the same folder. You must have to change the extension of file or change the name of file. thank you.
l have a problem with my txt file. my text have 2 colmn and i can't select only one? Problem whit txt?
sorry for the delay reply, please share more details.
@@Everythintechy everting is ok i have problem whit my pc. this is the best choise for rename all files. 🙂🙂
Thank you for sharing this great trick! but "dir d/" doesn't work for me any advice?
I think please try to use "dir /d"
please share the error details... thank you so much.
What if i want to add a word before the number ? Like doc-1 doc-2 doc-3
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
Exactly what I needed. Thanks!
glad to know! thanks
Hi, I can’t get to separate the extensions in another column in spreadsheet. How did you manage to separate different file types (.pdf,.txt, .docx etc.) to separate with a single click/command?
I managed to figure it out.
highlight all of the cells underneath the "Ext." column
hit ctrl + F
click on "Replace" and set these values:
Find what: *.
Replace with: .
then just click replace all (this will set the default value to this)
Then if you want to continue, just highlight the cells and hit ctrl + R to get the same effect since default values are set.
Dear sorry for the delay in reply... there is option in MS OFFICE 13 which called 'Flash Fill'... you can use it by shortcut key "CTRL+E"..
Thank you.
You can use it by shortcut key CTRL+E. Thank you.
That was a game changer! Thank you so much!
Thank you so much for your comments...
=D2&" """&A2&""" """&C2&B2&"""" There's the formula in command for rename
Bro, you got some excellent skills bro 🤐👍👍👍👍
Thank you so much for this bro
Thanks buddy, cheers!
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
Doesn't work for me. The "filename.txt" is written in 2 rows, so 2 filenames in one line.
Had the same problem. You've to switch /d with /b
try "dir /b => filenames.txt"
When I make the list, I get two columns with the file names instead of one.
please try dir /b => filename.txt may it work.. thank you.
WTF YOU ARE THE BEST BRO SABOONER AND LIKE TNX
thanks buddy...
Thank you so much
You're most welcome
This was is very helpful thanks for sharing mate
Thank you for your feedback dear...
Hi I'm curious if there anyway to rename image file inside a folder same as the parent folder name? Because I have more than 2000 folder of products with folder name something like WJ70066190PR, WJ70066191PR and I want all images inside of the folder get WJ70066190PR.jpg WJ70066191PR.jpg
It is possible to do the via the same method just you yahe to extract the file location and then rename
Thanks you very much.
Wooooooooooh....thanks a lot buddy
You can also rename multiple files with the help of long Path tool.,It is great tool.
saved me a job with tousands of files
ohh great.
thank you so much, its very helpful
Glad to hear that!
Worked perfectly, thank you!!
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 🤗🤗
It’s amazing I tried it and it worked for me 🎉
Thanks for your feedback
It is good trick. Appreciate it.
Thank you so much... Glad to know
Hi, I am not able to rename the file which file name are long, if the file which I want to rename has already short file name in that case it's working but for the long filename this formula is not working. Please advise
As I have checked it work for me... Please go thru the same. Btw thanks for your feedback.
@@Everythintechy Hi, thanks for your comment, for example this is file name " Certified Final (IDC completed) Proj Doc No MGP1-P4020MR019-C04-0001 Revision 004 Title INSTRUMENT BILL OF MATERIAL (BOM) FOR CORROSION INHIBITOR INJECTION PACKAGE (GP2-A-15702) Current Status 6 - Information.msg " and its extension is .MSG. I am not able to rename it thru the formula.
Thank you !!!!
You saved me . 😁
why in my notedpad they are everywher, they were not in 1 line
i figure it out thouuu thanks so muchhhhhh!
Thanks a lot, buddy. This is a very helpful tutorial.
Glad it helped