How to rename multiple files at once using Excel (Windows)

Ғылым және технология

Change file names in Windows Command Prompt:
ren "old filename.ext" "new filename.ext"
Use Excel to make multiple copies of this code then paste it back into Command Prompt.
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to rename multiple files in Windows kzread.info/dash/bejne/e22ayLmTj6XaZg.html
- List of filenames from folder into Excel (Windows) kzread.info/dash/bejne/aWtlutuskaeXdLg.html

Пікірлер: 511

  • @user-pr3yj3tg3z
    @user-pr3yj3tg3z11 ай бұрын

    no ads, straight to the point, clear instructions, no unnecessary music and no asking to subscribe. YOU ARE AMAZING!! Thanks!!!!!

  • @karinbauer4538
    @karinbauer45383 жыл бұрын

    I thought I was going to have to spend hours renaming 2000 files and this literally saved my life. THANK YOU!

  • @numerodoz3403

    @numerodoz3403

    4 ай бұрын

    2000 reminds me of smth..

  • @TJ-tu5xc
    @TJ-tu5xc3 жыл бұрын

    Absolutely fantastic!!! So easy to follow, so well explained and so incredibly much time saved. Thank you so, so much, this is truly one of the best videos that ever existed

  • @maty1229
    @maty12292 жыл бұрын

    This has been an extremely helpful tutorial and opened a lot of possibilities on what I thought would be a very tedious process, thank you very much! Short and to the point with good visuals.

  • @vincentlao9498
    @vincentlao94983 жыл бұрын

    To say that this has increased my productivity by ten times fold is an understatement. This is perfect!!! and Thank you Karina A.

  • @JavierDrWeld
    @JavierDrWeld11 ай бұрын

    I've just renamed four thousand music files that had numbers and hyphens in front of the file names, now my iPod can play them, Thanks

  • @deeeff1994
    @deeeff19942 жыл бұрын

    I have been asking my colleagues for months on how to do this, and finally while burning the midnight oil I found the answer. Thank you

  • @heitorcassanta364
    @heitorcassanta3642 жыл бұрын

    This is far one of the best videos about how to rename multiple files at once. The possibility to use excel unlocks so many other things like logical ways to set file names and them use it in file names. That's awesome. Thanks a lot

  • @VincentX
    @VincentX2 жыл бұрын

    You are my hero! I work in an Accounts Payable position and this will be a massive time saver for splitting & renaming large statements. I just shared it with my team too. Thank you so much for posting this and making it so easy to follow along and learn.

  • @ritikjain5660
    @ritikjain56603 жыл бұрын

    please give this woman a nobel prize for renaming files.

  • @AONomad
    @AONomad2 жыл бұрын

    I looked up 6 different web guides on renaming files and didn't find what I needed... this is exactly it. You saved me hours and hours of work, thanks so much!

  • @JKiefer
    @JKiefer4 ай бұрын

    Wow, using Excel as a means to generate large amounts of individual CMD prompts is a genius idea. Thank you!

  • @peibarry1335
    @peibarry13352 жыл бұрын

    Best tech video I've ever seen. It is easy to follow, easy to set it up, and the Excel template that gets created, can be re-used over and over effortlessly. Thank You so much

  • @ajd2344
    @ajd23443 жыл бұрын

    I was banging my head against the wall trying to write a script to do this. Thank you!

  • @Motionbuck
    @Motionbuck Жыл бұрын

    This video has been absolutely vital to me and my team as we needed to rename hundreds of glossary terms, this has saved us and our business hours of droll work! Thankyou so much for this!!!

  • @jasonzdora
    @jasonzdora2 жыл бұрын

    Youre a lethal badass, Karina! Cutting straight through with 100% killer and no filler. I truly appreciate your clear and succinct style. So very well done!!!

  • @samlyall9668
    @samlyall9668 Жыл бұрын

    Amazing video! So well explained and really easy to follow. One of the best videos I’ve ever watched as it impacted my work life so much!

  • @sidhedanu
    @sidhedanu2 жыл бұрын

    Great video! I changed it up a little by using concatenate in the last part to just include ren and spaces as part of the formula instead of dedicating columns to those elements. So useful!

  • @RobertABradley
    @RobertABradley2 жыл бұрын

    Thank You, Thank You. I had hundreds of files that needed renaming, and thought “There’s got to be an App that does this.” And then lo and behold, I tripped over your KZread video that showed I already “had” the App with Windows and Excel! Your super clear instructions were a wonder, and I got the files renamed as if by magic. I, of course, saved the spreadsheet, and have already reused it as a template for other lists of files. Cut, Paste, doublecheck, and Done! THANK YOU!

  • @whiskeytangowhiskey
    @whiskeytangowhiskey Жыл бұрын

    Such a great video - best tutorial I’ve ever seen. Very interested to check out the others even though I don’t need them right now. Thank you for making this, Karina!

  • @buzznut
    @buzznut3 жыл бұрын

    What a bloody legend mate, cheers!

  • @hughevelyn3393
    @hughevelyn33933 жыл бұрын

    I have tried every file renamer in the book - without success. So, after spending hours today and weeks and months before trying to find how to completely rename each one of a long list of files in a file directory it has taken this wonderful lady Brit to come up with the answer - and so briefly and succinctly, too! Thank you, thank you, thank you! (Oh! and plus the =A2&B2&C2 - which is so much quicker than concat)!

  • @tdvr43
    @tdvr43 Жыл бұрын

    Just used this and it worked out swimmingly, my girlfriend needed help renaming 3,000 folder names based on an excel file with a corresponding number. I really appreciate it.

  • @bluenosedive
    @bluenosedive3 жыл бұрын

    OMG!!! I love you :) was able to rename 500 files at once. Can't believe how easy and time saving it is

  • @TakingTheMike
    @TakingTheMike10 ай бұрын

    I just used this workflow to rename 2000 photos that were incorrectly renamed during an import into Lightroom that crashed half way through. This workflow has literally saved me days of work. Thanks so much Karina!

  • @Synthnerd11
    @Synthnerd116 ай бұрын

    Renaming several hundred wav files for the sake of changing two numbers in the file name was no fun at all. THIS has been a brilliant time saver. Thank you SOOO MUCH Karina for your fantastic help 👍👍👍👍

  • @nabeelmahmood9735
    @nabeelmahmood97353 жыл бұрын

    thanks you just saved me from manually changing 1000 file names

  • @marconico1012
    @marconico1012 Жыл бұрын

    10/10 quality tutorial. Well explained and paced as well. Thank you so much for this

  • @icleducafro8556
    @icleducafro85562 жыл бұрын

    Not only has this tutorial saved loads of productivity time, it has also probably saved even many hours of just learning the trick somehow else

  • @ONoarhO_Not-Know
    @ONoarhO_Not-Know Жыл бұрын

    I am a university student from Thailand. Thank you very much for helping me to solve the task of resolving many variants of file names in a short time after I was stuck on this problem for a long time.

  • @David-pu8vs
    @David-pu8vs3 жыл бұрын

    exactly what I was looking for, straight to the point, no BS, thumbs up and subscribed!

  • @Roguewiz
    @Roguewiz3 жыл бұрын

    Wow. Way easier than writing some VB. Thank you, Karina! You rock. I probably should have remembered that the command prompt could do that

  • @LarahSardia
    @LarahSardia2 жыл бұрын

    THANK YOU VERY MUCH!! Spent hours figuring out how to rename my files and I am so thankful to found your tutorial. Thanks for sharing this, it is truly helpful!!

  • @MrinalTrivedi
    @MrinalTrivedi Жыл бұрын

    Outstanding delivery/explanation. So simple. I went through half a dozen videos where the speaker just jumpes into the steps without explaining the reasoning. Great job!!😊

  • @bandipalli
    @bandipalli2 жыл бұрын

    Excellent! Explained in a lucid manner that anyone can easily follow it. Thank you. Much appreciated.

  • @zzzzzzzzzzzzzzzz9
    @zzzzzzzzzzzzzzzz9 Жыл бұрын

    Bravo. Just had to change the name of each file in 40 different folders. Took me about an hour, which is peanuts compared to doing it manually. It's one of the best tricks.

  • @levlylove
    @levlylove2 ай бұрын

    Oh my gosh, this is amazing! I needed to batch rename 125 files that had TWO sequential numbers in them, and wasn't sure if even a batch rename app existed to do this. Despite knowing the ren command, I never would have considered using a spreadsheet to create the commands in bulk! Thank you!

  • @TheMooper27
    @TheMooper277 ай бұрын

    You're a diamond! I've seen a few videos teaching this skill, but all required the audience to download some 3rd party software from a sketchy site. So good to see that we can do this with excel and not have to put our computer's security at risk. Thank you so much :)

  • @HuyNguyen-wz8lx
    @HuyNguyen-wz8lx3 жыл бұрын

    You have no idea how much this trick means to me!!! I appreciate your help with this video a lot, Karina!

  • @forte_dx1813
    @forte_dx18132 жыл бұрын

    Amazing! This reduced so much of my workload. I now keep the excel at hand, anytime I have to add something to multiple filenames. Thank you!

  • @jonathanfriz4410
    @jonathanfriz44102 жыл бұрын

    Excellent video. straight to the point, clear, and functional. Thank you.

  • @Klokinator
    @Klokinator Жыл бұрын

    I would have had to tediously scan and rename each individual file in a folder of 500 chinese-named files for my translation project. But this guaranteed only the exact files got renamed. Thanks so much! Saved me HOURS!

  • @arka9294
    @arka92942 жыл бұрын

    That is marvelous!! I never knew that renaming multiple files is that easy without coding. I was astonished to see the video. Waiting for more videos like this. I immediately subscribed to your channel.

  • @bsreekanthrao
    @bsreekanthrao2 жыл бұрын

    Absolutely fantastic video - saved me and my team several hours!!!!!! Thanks a million.

  • @rlrconsulting
    @rlrconsulting2 жыл бұрын

    This was an absolute life-saver! Best way I have seen to do this in a long time.

  • @8Doomsock8
    @8Doomsock83 жыл бұрын

    This is exactly what I needed and so clear, Thank you!

  • @gabrielaparecido6259
    @gabrielaparecido62592 жыл бұрын

    Thank you very much; I looked everywhere for this. Great job and great explanation!!

  • @sohailahmed8309
    @sohailahmed83093 жыл бұрын

    You know how to teach. Wish I had teachers like you in my school. Thank you.

  • @MrGmo422
    @MrGmo422 Жыл бұрын

    This one video saved me one hour of work. I cannot stress how much I appreciate you!

  • @sagar_bhalerao
    @sagar_bhalerao3 жыл бұрын

    Thanks a lot, I was struggling to rename almost 100 files, you made it easier.

  • @jeanpaullarrainaspilcueta1292
    @jeanpaullarrainaspilcueta12922 жыл бұрын

    Thanks a lot for sharing! Absolutely helpful and crystal clear!

  • @sahilaggarwal2835
    @sahilaggarwal283528 күн бұрын

    Straight to the point with clear instructions. Thats how a YT tutorial should be...THANK YOU so much..

  • @peddipankaj437
    @peddipankaj4373 жыл бұрын

    This is exactly what I have been looking for. Thanks a lot!

  • @MatharuCH
    @MatharuCH Жыл бұрын

    Saved me from renaming 160 images separately, thank you SO MUCH Karina!

  • @nausheenali9747
    @nausheenali97472 жыл бұрын

    Incredible!!!! Thank you so much. All the steps were explained very clearly and it was really very helpful. :)

  • @kusalviduranga7352
    @kusalviduranga73522 жыл бұрын

    Absolutely fantastic!!! So easy to follow. THANK YOU!

  • @redchai10
    @redchai10 Жыл бұрын

    Wow! just WOW! You are my HERO! I love organizing my files so I usually rename them (especially downloaded files with so many extra characters) so it will be neat and consistent. Though my fingers are fast on keyboard, renaming hundreds of files is still tedious. I finally decided to search whether bulk renaming is possible without using 3rd party apps. This really saved my day! This is so amazing! THANK YOU VERY MUCH!

  • @tonniebaumeister
    @tonniebaumeister2 жыл бұрын

    When you want a long list of all the files in a map/directory: type dir >namefile then you have a txt-file with all the files in the new made file namefile.txt

  • @JustinPayton
    @JustinPayton Жыл бұрын

    You're a godsend! I had 3 folders with 60+ files to rename in each folder. This took a task that would of taken 1/2 day to do down to less than 10 minutes

  • @kirkalderdice6340
    @kirkalderdice63402 жыл бұрын

    Absolutely brilliant - thank you so much for taking the time to share

  • @kennethgreen2829
    @kennethgreen28292 жыл бұрын

    Hi Karina. Not sure if you are still active on this video but wanted to say a huge thank you for the video. I needed to remame 300+ files and your video helped me to do that so very gratful. Many thanks.

  • @jnay2728
    @jnay27282 жыл бұрын

    Thank you very much!! You are a life saver. I had to rename 226 files, and your tutorial saved me from long suffer! Thanks again!

  • @matheusmilagres
    @matheusmilagres Жыл бұрын

    Perfect!! Thank you for this simple and complete tutorial, easy to follow.

  • @zukuma1692
    @zukuma16922 жыл бұрын

    Your incredible. I renamed 360+ plus files using this method. Dont know what I would do without you

  • @embeathome1
    @embeathome12 жыл бұрын

    Karina, thank you! Fantastic tutorial!! You saved me hours of work!

  • @shivhota627
    @shivhota62710 ай бұрын

    Absolutely fantastic… really help a lot i had multiple folders with 300+ pdf file name to edit blessed to see you video

  • @fragranceenthusiast5790
    @fragranceenthusiast57903 жыл бұрын

    I found this just incredibly useful. Just superb. Thank you Karina. I can't remember when I was as excited! Perhaps it was in 1989 when I heard 'When You Come Back To Me' by Jason Donovan for the first time. Or maybe even further back and 'Souvenir' by OMD! :0)

  • @marktheirl1842
    @marktheirl18422 жыл бұрын

    Thank you! This is so easy! Especially for those of us who remember the days of DOS

  • @juliemillerwealthartificer4764
    @juliemillerwealthartificer47643 жыл бұрын

    Hi there, thank you for this. There is also a quick way via VB at this location. It didn't work for me initially because I had a pipe (|) in my rename and the only way I worked out that problem was by following your tutorial. It really helps to go back to basics.

  • @user-qb7ps9pm9t
    @user-qb7ps9pm9t Жыл бұрын

    Thank you so much for this. I used to do this in PowerAutomate, but I no longer have access to MS. Now I have created an Google Sheets template and doing it this way is even quicker! Thanks again!

  • @amirhosseinbolouk
    @amirhosseinbolouk8 ай бұрын

    So simple yet so useful. Amazing! Thank you.

  • @MOATHALSHIBLIvfx
    @MOATHALSHIBLIvfx Жыл бұрын

    this exactly what i have been looking for all day. thank you

  • @tomwaterhouse9419
    @tomwaterhouse94194 ай бұрын

    This video was excellent - really clear, worked first time. Thank you!

  • @ernestaboagye3385
    @ernestaboagye338511 ай бұрын

    This is incredible. Easy to follow and well explained tutorial ❤

  • @kostastekos4402
    @kostastekos4402Ай бұрын

    Absolutely fantastic video. Straight to the point and very helpful.

  • @bandipalli
    @bandipalliАй бұрын

    Thank you very much. Straight to the point, nothing more nothing less. Impressive.

  • @DavidBelmar-zw2vc
    @DavidBelmar-zw2vc2 ай бұрын

    You are amazing, thank you so much. Companys need more people like you. Good job!

  • @xgeo-learnspanish4917
    @xgeo-learnspanish49172 жыл бұрын

    Wow!!! Fantastic!! I wish I found this trick out years and years ago. I would have saved countless hours renaming files.

  • @the-cyburstud
    @the-cyburstud3 жыл бұрын

    Thank you! So simple and efficient!

  • @cuteycuteylala
    @cuteycuteylala2 жыл бұрын

    This video is a life saver. Helped me so much at work. Thank you!!

  • @theusmansem
    @theusmansem2 жыл бұрын

    I can't thank you enough, WOW. Amazing things I learned in this video not only renaming. God Bless You.

  • @bgrung
    @bgrung Жыл бұрын

    GENIUS!!!!! I've never ever thought to do it this way. Blown away!

  • @AlexanderHartmann71
    @AlexanderHartmann712 жыл бұрын

    🙂 This saved me a lot of time. I used this technique for SQL Queries and now also for terminal commands 🙂

  • @catcameo1670
    @catcameo16702 ай бұрын

    Thanks so much for your help. I had the words in excel but I couldn't figure out how to make them into files. Using command was really cool!

  • @cameronholtz8960
    @cameronholtz8960 Жыл бұрын

    Thank you!! I cannot express how much this helps me. Really, thanks.

  • @StuartDeane
    @StuartDeane3 жыл бұрын

    Brilliant tutorial - many thanks - you have solved a huge problem for me :)

  • @Yige-wc8ih
    @Yige-wc8ih8 ай бұрын

    What a amazing tutorial, you solved my problem that took me almost 1week time on figure it out, thank you so much

  • @Kiet-Tran
    @Kiet-Tran4 ай бұрын

    I used this trick at my internship, and it got me good praises!

  • @carinahernandez1247
    @carinahernandez12473 жыл бұрын

    OMG THANK YOU!!!! This worked! getting it all set up initial took a bit but now I can use this for other folders!

  • @PoeLemic
    @PoeLemic Жыл бұрын

    This is so brilliant. And, I used to type the "RENAME" command like 250 to 300 times to rename everything. Gosh, it took the whole morning. This is so much faster just to add author at end.

  • @javierperez9034
    @javierperez90342 жыл бұрын

    Incredible!, you saved me so much time. Wish I knew this before. I already subscribed, your videos are so useful keep doing this please...

  • @domanticthoughts2307
    @domanticthoughts2307 Жыл бұрын

    My first time commenting on a KZread video. This really helped me. Thank you!

  • @smzai410
    @smzai4107 ай бұрын

    Amazing, superb, ive just done this for 2000+ folder with this technique and it works, thanks for saving my time

  • @littlemspd9674
    @littlemspd9674 Жыл бұрын

    Awesome tutorial... the best yet. Thank you!

  • @tayl0124
    @tayl01242 жыл бұрын

    This is extremely useful!! I wish I could like it more than once! matched with a batch rename file it is helping me create image placeholders for volume photography.

  • @nathanieljb666
    @nathanieljb666 Жыл бұрын

    Thank you for this! I was able to fix so many problems using this! Life saver.

  • @MasayaShida
    @MasayaShida2 жыл бұрын

    this is very helpful. A task that would have taken me an hour took me a few minutes. THANK YOU

  • @vipulsinghal7
    @vipulsinghal72 жыл бұрын

    Thank you so so much.. This technique is brilliant for a non-coding like people. I am really very grateful for this easy guidance.

  • @davids3313
    @davids33133 жыл бұрын

    WOW! Thank you so very much. Like some other comments, I thought I'd have to change over 700 file names manually.

  • @Lillykat003
    @Lillykat00311 ай бұрын

    OHMYGOD!!! You just saved me HOURS of tidious work! So well explained! Thank you so so much!!