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 !
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&""""
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?????
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.
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.
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??
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 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.
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.
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...
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
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.
i liked this and this is very help full but later on when i go on dir /d => filename.txt i got in in notepad in 2 collums and i cant copy it in order , always copied 2 colums make it hard for me to copying into excel. Please help
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.
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.
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
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
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
6 years later you are still saving lives. Thanks!
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
Thanks mate
thank you my hero
Holy shit it worked, thanks bro.
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
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
2:30 dir /d => filename.txt
6:34 ren "old name.extension" "new name.extension"
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...
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
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
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.
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&""""
Man on 2022 this was a life saver for me, thanks a lot.
Thank you so much dear for your awesome feedback
thanks for the great tips. so we can even rename with any kind of rename varieties using batch command...
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 😁
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?????
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...
The epic music made it feel like I was hacking into pentagon files.
Very very informative & useful information
Please please..make a video again in full details
Okay, thank you
Amazing Tutorial, This trick work for me, thanks a lot ❤️🙏🏻
WOW... I wanted just this but couldnt find it anywhere... A BIG THUMBS UP FROM ME
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
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.
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.
Thank you so much bro you saved my 4hours of time 🙌
Thank you
Mind blowing its working yaar .. love and thank you so much
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..
YOU HELPED ME SO MUCH TY I LOVE YOU
thanks! does it work with folders renaming?
Very nice video.....
Teaching without Words...
Awesome Bro
Yeah... Btw thank you so much...
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.
pls help if i want to insert different files name on the 1st page of multiple PDF files at once.
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?
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 So Much. It worked for me. Hats off
Thank you so much for your awesome feedback...
Very useful and i use it 2021 thanks bro 👍🏽
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
This trick was help me a lot, thankyou
Thank you so much for your valuable comment
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 :)
Thank you for this video it was very helpful
Thank you so much
THank YOU Bro.... Saved some precious time...
Thank you dear for your valuable feedback. I help to make more video.
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.
Bro, you got some excellent skills bro 🤐👍👍👍👍
Is there a way to do it if the files are in D drive instead of C?
This was is very helpful thanks for sharing mate
Thank you for your feedback dear...
Why not type all your text in the notepad beforehand? Or use text-to-speech generator.
VERY HELPFUL! THANKS
Thank you so much 😊
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.
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
Great. Thank you very much!
Excellent my dear friend - you are awesome!! thanks from heart Bro!!
Thank you so much dear for your valuable comment...
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.
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.
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...
how about for folders?
It’s amazing I tried it and it worked for me 🎉
Thanks for your feedback
Worked perfectly, thank you!!
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
thank you so much, its very helpful
Glad to hear that!
Thanks for Helping!
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
Thank you bro.. it saves lot of time.. :)
Thank you dear.
Loved it! You saved us.
Thanks
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.
Thanks a lot, buddy. This is a very helpful tutorial.
Glad it helped
It is good trick. Appreciate it.
Thank you so much... Glad to know
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
great lil excel hack, I like it ;)
Thank you for this amazing videos, I subbed.
Thank you so much... Appreciate it
You can use batch files renamer tool for this too..
Hi, looking to c:\\copy abcd-10.txt c:\\bcd*.txt Is there a way to drop the first char while copying in a command line? Thanks!
Yes it is possible thru Excel... But please share complete details what you are looking exactly... Thank you
Is it applicable for all windows version?
Yes!
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...
Thank you so much for this bro
Thanks buddy, cheers!
Hi thx for the tutorial same I have one request how to rename photos in bulk ? Pls guide me
Exactly what I needed. Thanks!
glad to know! thanks
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.
awesome tutorial! many thanks!
Glad it was helpful!
i liked this and this is very help full but later on when i go on dir /d => filename.txt i got in in notepad in 2 collums and i cant copy it in order , always copied 2 colums make it hard for me to copying into excel. Please help
Please paste it directly by copying from Notepad to Excel. i think it should be paste in a single column. thank you.
@@Everythintechy have the same problem, i get 2 file names in one column with 5 spaces, also when i paste it in excel i got them in one cell :/
ah okay found it in another comment, it worked with: dir /b => filename.txt 👍
My dude has the background music of an epic quest 10/10
Football world cups
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"
Wooooooooooh....thanks a lot buddy
THANK YOU SIR.... IT'S WORKING
Thanks
in Linux.. it is much easier to do it. no painful this way.
single command does for all.
That was a game changer! Thank you so much!
Thank you so much for your comments...
Thank you 😊 saved me a massive job with 100 odd files!!!
Thank you so much for your valuable feedback. Cheers!
This was amazing! Thank you
Thank you !!!!
You saved me . 😁
You r a savior man 🤗🤗
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.!
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 - ruclips.net/video/N_Gz72qv6ds/видео.html
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
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.
Thank you so much ☺️☺️
What if i want to add a word before the number ? Like doc-1 doc-2 doc-3
WTF YOU ARE THE BEST BRO SABOONER AND LIKE TNX
thanks buddy...
why in my notedpad they are everywher, they were not in 1 line
i figure it out thouuu thanks so muchhhhhh!
Thank you for this :) It help a lot
Glad to know