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

แชร์
ฝัง
  • เผยแพร่เมื่อ 24 พ.ย. 2024

ความคิดเห็น • 533

  • @AlejandroPierro-o8r
    @AlejandroPierro-o8r ปีที่แล้ว +32

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

  • @karinbauer4538
    @karinbauer4538 3 ปีที่แล้ว +80

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

    • @numerodoz3403
      @numerodoz3403 8 หลายเดือนก่อน

      2000 reminds me of smth..

  • @ritikjain5660
    @ritikjain5660 3 ปีที่แล้ว +7

    please give this woman a nobel prize for renaming files.

  • @TJ-tu5xc
    @TJ-tu5xc 3 ปีที่แล้ว +70

    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

  • @TakingTheMike
    @TakingTheMike ปีที่แล้ว +1

    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!

  • @deeeff1994
    @deeeff1994 2 ปีที่แล้ว +3

    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

  • @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.

  • @vincentlao9498
    @vincentlao9498 3 ปีที่แล้ว +10

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

  • @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.

  • @ahyathartono7765
    @ahyathartono7765 5 หลายเดือนก่อน +1

    Totally clear explanation, amazing. Thank you for the tutorial

  • @linejunction
    @linejunction หลายเดือนก่อน +1

    Briliant. The most difficult part was finding your video! Thank you

  • @maguelonehenriot1158
    @maguelonehenriot1158 4 หลายเดือนก่อน +1

    I was about to give up and you saved my day !!! Thanks a lot 😀

  • @sahilaggarwal2835
    @sahilaggarwal2835 5 หลายเดือนก่อน +1

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

  • @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.

  • @wahyunawangwulan8767
    @wahyunawangwulan8767 2 หลายเดือนก่อน +1

    NICE!!! You’re an angel! You save my life renaming hundreds of files ❤❤❤

  • @hughevelyn3393
    @hughevelyn3393 3 ปีที่แล้ว +1

    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)!

  • @O_M_
    @O_M_ หลายเดือนก่อน +1

    This is amazing 🤝 I had nearly 3000 files to rename this made it so much Easy

  • @heitorcassanta364
    @heitorcassanta364 3 ปีที่แล้ว +2

    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

  • @Synthnerd11
    @Synthnerd11 10 หลายเดือนก่อน

    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 👍👍👍👍

  • @john9291
    @john9291 2 หลายเดือนก่อน +1

    great stuff, works a treat and much quicker than trying to re-learn regex

  • @RobertABradley
    @RobertABradley 2 ปีที่แล้ว

    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 TH-cam 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!

  • @VincentX
    @VincentX 2 ปีที่แล้ว +4

    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.

  • @AONomad
    @AONomad 2 ปีที่แล้ว

    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!

  • @Motionbuck
    @Motionbuck ปีที่แล้ว +2

    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!!!

  • @levlylove
    @levlylove 7 หลายเดือนก่อน

    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!

  • @bluenosedive
    @bluenosedive 3 ปีที่แล้ว +4

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

  • @buzznut
    @buzznut 3 ปีที่แล้ว +33

    What a bloody legend mate, cheers!

  • @peibarry1335
    @peibarry1335 2 ปีที่แล้ว +2

    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

  • @icleducafro8556
    @icleducafro8556 3 ปีที่แล้ว +4

    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

  • @bandipalli
    @bandipalli 5 หลายเดือนก่อน +1

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

  • @lucyameliasumual8157
    @lucyameliasumual8157 3 หลายเดือนก่อน +1

    This is so helpfull!!! Thank you very much!! I almost cry because i have to rename thousand of files..

  • @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!!😊

  • @TheMooper27
    @TheMooper27 11 หลายเดือนก่อน

    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 :)

  • @JKiefer
    @JKiefer 8 หลายเดือนก่อน +1

    Wow, using Excel as a means to generate large amounts of individual CMD prompts is a genius idea. 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!

  • @MatharuCH
    @MatharuCH 2 ปีที่แล้ว

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

  • @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.

  • @JavierDrWeld
    @JavierDrWeld ปีที่แล้ว +1

    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

  • @sidhedanu
    @sidhedanu 2 ปีที่แล้ว +5

    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!

  • @ajd2344
    @ajd2344 3 ปีที่แล้ว +1

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

  • @LarahSardia
    @LarahSardia 2 ปีที่แล้ว

    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!!

  • @NikhilKumar-zk9kx
    @NikhilKumar-zk9kx 3 ปีที่แล้ว

    thanks mam.... i just changed name of around 120 files with the help of your video.... thanks again mam it saved me lot of time

  • @sohailahmed8309
    @sohailahmed8309 3 ปีที่แล้ว +1

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

  • @MrPerezOP
    @MrPerezOP หลายเดือนก่อน +1

    goated. ngl. don't know why i didn't think of this, but this was goated.

  • @nabeelmahmood9735
    @nabeelmahmood9735 3 ปีที่แล้ว +1

    thanks you just saved me from manually changing 1000 file names

  • @jasonzdora
    @jasonzdora 2 ปีที่แล้ว

    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!!!

  • @Roguewiz
    @Roguewiz 3 ปีที่แล้ว +3

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

  • @SharonJohnson-p6v
    @SharonJohnson-p6v ปีที่แล้ว

    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!

  • @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

  • @HuyNguyen-wz8lx
    @HuyNguyen-wz8lx 3 ปีที่แล้ว +2

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

  • @jonathanedwards1108
    @jonathanedwards1108 ปีที่แล้ว

    This is a very smart method, thanks for posting this! Like most comments, you have saved me a big headache, I was trying to get AI to write a script to accomplish this with mixed success. To others, ***if you want to do this on macOS,*** it works too. Just copy and paste a group of files intoTextEdit after selecting "Format, Make Plain Text" from the menu to make the file list, and copy/paste into Excel. Then in terminal, use the "mv oldFileName newFileName" command to rename the files, in the same method as the video. (in the correct path). Paste the column into terminal. Wow thanks!

    • @conniecampbell2668
      @conniecampbell2668 ปีที่แล้ว

      Can you elaborate on this 'ust copy and paste a group of files intoTextEdit after selecting "Format, Make Plain Text" from the menu to make the file list' please

  • @maty1229
    @maty1229 2 ปีที่แล้ว +15

    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.

  • @phunguyen305
    @phunguyen305 2 ปีที่แล้ว

    I already have some apps that can rename multiple files but it's hard to keep them in right order. With your solution, the sort order is absolute right. Thanks very much for your sharing.

  • @AbdulAlim-wk3tg
    @AbdulAlim-wk3tg ปีที่แล้ว +1

    Thanks a lot my friend, its very helpful...

  • @thanhlawd132
    @thanhlawd132 4 หลายเดือนก่อน +1

    very creative with excel! thank you!

  • @Xtremeshot007
    @Xtremeshot007 3 ปีที่แล้ว

    Lady, you are a legend. Although my BP went up with all the columns. I have to rename 2500 files. That brought me here😑❤

  • @cheeky12332
    @cheeky12332 2 หลายเดือนก่อน +1

    100% worth it
    Thankyou 🔥

  • @kennethgreen2829
    @kennethgreen2829 2 ปีที่แล้ว

    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.

  • @shivhota627
    @shivhota627 ปีที่แล้ว

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

  • @forte_dx1813
    @forte_dx1813 2 ปีที่แล้ว

    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!

  • @Kiet-Tran
    @Kiet-Tran 8 หลายเดือนก่อน

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

  • @smzai410
    @smzai410 ปีที่แล้ว

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

  • @xgeo-learnspanish4917
    @xgeo-learnspanish4917 2 ปีที่แล้ว +1

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

  • @MrGmo422
    @MrGmo422 2 ปีที่แล้ว

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

  • @MonicaMoore-q5r
    @MonicaMoore-q5r 11 หลายเดือนก่อน

    KARINA!
    LEMME TELL YOU SOMETHING!!!!!! YOU JUST SAVED ME HOURSSSSSSSSSSSSSSSSSSSSSSS!
    I am sure that there are a myriad of ways to do this but I really appreciate how straight and simple this was. I also enjoyed how well you gave directions clearly and made it simple for users to follow and get the results they were looking for with MINIMAL knowledge and processing.
    BRAVO SISTER!!!! Absolutely fantastic and I am thankful to you! Keep Exceling ;).
    -Girls Who Love Data

  • @AlexanderHartmann71
    @AlexanderHartmann71 2 ปีที่แล้ว +1

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

  • @marconico1012
    @marconico1012 2 ปีที่แล้ว +7

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

  • @zukuma1692
    @zukuma1692 2 ปีที่แล้ว

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

  • @domanticthoughts2307
    @domanticthoughts2307 ปีที่แล้ว

    My first time commenting on a TH-cam video. This really helped me. 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!

  • @DavidBelmar-zw2vc
    @DavidBelmar-zw2vc 6 หลายเดือนก่อน

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

  • @bacharobeid7430
    @bacharobeid7430 2 ปีที่แล้ว +1

    FANTASTIC!!!

  • @arelivillavicencio7256
    @arelivillavicencio7256 หลายเดือนก่อน +1

    Thank you for making this!!!!!!

  • @marktheirl1842
    @marktheirl1842 2 ปีที่แล้ว

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

  • @PaiDerFilzige
    @PaiDerFilzige 5 หลายเดือนก่อน +1

    I simply love you!

  • @sagar_bhalerao
    @sagar_bhalerao 3 ปีที่แล้ว +1

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

  • @CarlosFeral
    @CarlosFeral ปีที่แล้ว

    😍OMG you saved me like 4 hours of work!!!

  • @Lillykat003
    @Lillykat003 ปีที่แล้ว

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

  • @toddpowell9118
    @toddpowell9118 19 วันที่ผ่านมา

    Such a great walk trough with simple detail. Saved me hours.

  • @vipulsinghal7
    @vipulsinghal7 2 ปีที่แล้ว

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

  • @liouaflazi9537
    @liouaflazi9537 7 วันที่ผ่านมา

    Brilliant,
    Right to the point, well explained, step by step with a lot of tricks that help you in other tasks, I loved the trick of how to extract only the extensions.
    thank you very much

  • @Yige-wc8ih
    @Yige-wc8ih ปีที่แล้ว

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

  • @dukesnoogens
    @dukesnoogens 3 ปีที่แล้ว

    OMG it worked!!
    Your a fricken LIFE SAVER!
    I search a pile of docs and tutes online; written by numpties and got nowhere.
    Thanks so much for sharing this. xo

  • @Magooch86
    @Magooch86 10 หลายเดือนก่อน

    Brilliant! Re-named 21 seasons of South Park episodes with this, thanks so much

  • @samlyall9668
    @samlyall9668 2 ปีที่แล้ว +5

    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!

  • @jnay2728
    @jnay2728 2 ปีที่แล้ว

    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!

  • @bgrung
    @bgrung 2 ปีที่แล้ว

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

  • @MOATHALSHIBLIvfx
    @MOATHALSHIBLIvfx 2 ปีที่แล้ว

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

  • @bandipalli
    @bandipalli 2 ปีที่แล้ว +2

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

  • @catcameo1670
    @catcameo1670 6 หลายเดือนก่อน

    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!

  • @kostastekos4402
    @kostastekos4402 5 หลายเดือนก่อน

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

  • @RecruitmentAIG
    @RecruitmentAIG 2 หลายเดือนก่อน +1

    Thank you teacher

  • @aura_6913
    @aura_6913 3 ปีที่แล้ว

    THANK YOU LADY ON TH-cam, YOU JUST SAVED ME, LIKE, A SOLID 2 HOURS

  • @MasayaShida
    @MasayaShida 2 ปีที่แล้ว

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

  • @ratankanade7395
    @ratankanade7395 2 ปีที่แล้ว

    Thanks alot my notepad crashed when I had 650 files open. Hopefully was save in backup with wanted to rename this helped alot 💯

  • @neminier3863
    @neminier3863 3 หลายเดือนก่อน +1

    Thank you for the video

  • @rakeshg7879
    @rakeshg7879 ปีที่แล้ว

    This is very helpful for me. You explanation is very clear and simple. Thank you very much

  • @davids3313
    @davids3313 3 ปีที่แล้ว +1

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

  • @redcantful
    @redcantful 2 ปีที่แล้ว

    Thank you! This video is very helpful. Also you can use A1&" "&B1&" "&C1 for space instead of insert new column.

  • @tonniebaumeister
    @tonniebaumeister 2 ปีที่แล้ว +2

    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