Rename Multiple Files in a Folder at Once (With Different Names) From Excel List | Excel Template
ฝัง
- เผยแพร่เมื่อ 21 ส.ค. 2024
- In this Microsoft Excel video tutorial, I explain how to rename multiple files at once within a folder. The Excel template for this can be downloaded here: www.bluepecant...
The template automatically creates the text you need to paste into the command prompt. All you have to do is paste in the old filenames and provide the new filenames.
#exceltutorial #exceltips
For those who might need it, don’t forget to put the file type at the end of the new file name (e.g. .pdf, .jpg, etc). Took me 15 mins to realize my mistake lmao
This is THE video I’ve been looking for for years!
Bookmark this video. You will probably need it again.
You absolute life saver, you've just stopped me having to manually amend 1500+ files !!!!
That would have been a tad tedious
I just have to echo all the other comments here. You saved me so much time manually renaming hundreds of files. So glad I found your video that is simple, clear and easy to follow. The template was very handy as well. Thank you so much!
Glad I could help!
Brilliant! This was so quick and easy. For a complete novice, I was able to follow this with ease. The excel attachment with formula was the game changer! Thanks! I've got you saved!
JUST WOW! You have saved me hour and hours of work, thank you so much
This is awesome! I had to rename nearly 2,000 files and it worked instantly, as shown in your video. Thank you so much!
Thank you so much!! All the files i was trying to renamke had an $ in their name, and i wanted to remove it, but any kind of multiple renaming with code was getting wrong because they are folders. Your method was the only one that worked just fine! I would give you 100 likes if i could, but i cant just press it once
You Really are a Life Saver Chester, More Power to You!!!!!!
Takes me back to my early PC days....DOS 3.1 and a little later, Windows 3.12. Those were the days of doing command prompt stuff (even the date/time stamp on files), and when Norton really was a great Utilities package! And don't forget all of the PC Mag utilities!
it's works like a magic.. Thank you so much
you cant imagin how much you saved my day and my time !! Thank you very much
Perfect! It worked like miracle! Thank you.
That is amazing. Exactly what i needed. Thank you SO much!!!
One more BIG thank you for this video. I've been looking for a long time for an answer to this issue. This is the perfect solution for me, and I'm grateful that you shared.
Thank You So Much❤
Thank you so much!!! A brilliant solution for enabling the randomization of files.
Thank you so much! 🤩
Thank you
PERFECT VIDEO
King you dropped this👑
You absolute GENIUS! You have saved my sanity! 😆
Excellent! Amazing techniques ... much appreciated....👍👍👍
What a cool EASY trick, thank you
thank you!
Great Video, it saved a lot of time.
Thank you! This was very helpful.
Exactly what i am looking for.... Thanks
excellent!thanks for sharing
Great video, thanks a lot!
You made my day. Thanks a lot!
This is amazing!
Exactly what i needed
lifesaver
Very interesting 👌
Hugely helpful.
Many thanks
yes amazing, thank you very much!
thanks alot.. my half day work reduced.
Great video, however been looking for a way to replace " _ with a space " in a list of 15,000 PDF files. Some are duplicates so in that case I need it to make the duplicate file place a "RE: 1 etc after file name " after any duplicates so I can verify it is truly a duplicate. Be nice if it could stop at each file that has replaced the _ with a space and ask if it should replace file or add the 1 to the end of the file name. Not sure if I am overthinking things but can't seem to find a solution in my own head or on here. Thanks Great Excel videos have learned a lot, you have a talent of explaining things so clearly even a bone head like me can follow along. Tony
thank you somuch, u save my day
thank you so much, u save my life :D
thank you so much
super
We can also get the files names by Select all files in a folder and then right click and copy as path
Thanks
Many thanks
you're a goat
😎
Do I need to leave the “.xlsx” or will it re add them once the command runs with the correct file type? Or do I even need the “.xlsx” in the file name, I’m find with removing them if so. Thank you in advance!
Hello, it doesn't work for me. I followed each exact instruction but when I place the renamed file names and close, nothing happens. How can I fix this?
I'm getting access denied in cmd at the final step..means after pasting the new names at cmd and running in I'm getting access denied and the names are not changing please help me
i love you Chester, i want you to know that
Can this work if the files are attached to a folder in teams?
how do extend ren?
is there a way how to rename folders to dates? it keeps changing my folders to numbers like this 45313 instead of date
when I type cmd in the bar, nothing shows up....
Can I double like this?
For me, the first step, I know this is not what I am looking for, This ONLY works if the filename is in English and not Russian, Japanese, Chinese, Korean etc. I have lot of those anime so it wiil not work.
Hello. I hawe an issue. I receive an error when I try to renamd files that contain ș ț î ă â (romanian characters) and. Do you hawe a solution for this?
This not worked for me
Follow exactly the instructions in the video and it will work. Download the template too.