Genius Hack to Rename Multiple Files in a Folder in Seconds (Quick and Easy)

Поделиться
HTML-код
  • Опубликовано: 29 июн 2024
  • Want to rename multiple files in a folder quickly? In this video, I'll show you a very simple and easy method to rename some or all of the files in a folder.
    All you need is a simple Excel formula and a couple of easy commands.
    00:00 Intro
    00:15 Rename All Files in a Folder
    03:36 Get All File Names in Folders and Subfolders in Excel
    ➡️ Download File - www.dropbox.com/scl/fi/h4ujsa...
    ☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
    ✅ Free VBA course - bit.ly/excel-vba-course
    ✅ Free Power Query Course - bit.ly/power-query-course
    ✅ Best Excel Books: trumpexcel.com/best-excel-books/
    Subscribe to get awesome Excel Tips every week: ruclips.net/user/trumpexc...
    #Excel #ExcelTips #ExcelTutorial #SumitBansal

Комментарии • 70

  • @trumpexcel
    @trumpexcel  3 месяца назад +5

    If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
    Also, I have made all of my Excel courses available for free. You can check these out using the below links:
    ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
    ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
    ✅ Free VBA course - bit.ly/excel-vba-course
    ✅ Free Power Query Course - bit.ly/power-query-course

    • @kurtrichter1732
      @kurtrichter1732 3 месяца назад

      I've been renaming files manually for the last several years -- This is a extremely useful tip for me. THANKS!

    • @rangs1966
      @rangs1966 3 месяца назад

      Please Publish new Videos on Power Query M Language

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Sure... will publish some on M in Power Query

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Thanks Kurt... Glad you found the video helpful 🙂

  • @danajohnston
    @danajohnston 16 дней назад +1

    You are a GENIUS!
    So simple--you saved me!

  • @IvanCortinas_ES
    @IvanCortinas_ES 3 месяца назад +6

    Sensational method with many practical options to do. Thanks Sumit.

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Thanks Iván... I learned this recently and it's amazing how much time this can save if there is a need to rename files in bulk

  • @ghaziehaq
    @ghaziehaq День назад +1

    bro you are a life saver
    thanks for the help bro, really helpful

  • @rutaztsai6760
    @rutaztsai6760 3 месяца назад +1

    Bro I cannot imagine the learning way without your videos. This videos always enhance my working efficiency. Thanks a million!

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Thank you so much for the kind words Rutaz... So happy to know that the videos are being helpful 🙂

  • @parag2684
    @parag2684 3 месяца назад +2

    Thanks Sumit. Very useful as I was looking for it since long. You made it without VBA that's really grt8!!

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful Parag 🙂

  • @mrsfrenchy3
    @mrsfrenchy3 3 месяца назад

    WOW! This is absolutely awesome. I sure wish this was available about a year ago. I manually renamed hundreds of files to make everything uniform. I will be making use of this hack. Thank you so much for your videos!

  • @abdulsalam935
    @abdulsalam935 3 месяца назад +2

    Sir, your methods are simple SUPERB. Thank you.

  • @TunisianSpring
    @TunisianSpring 3 месяца назад +2

    Thank's a ton for these cool tricks!!

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful 🙂

  • @NuliyaAmirafil
    @NuliyaAmirafil 2 месяца назад

    Very helpful, thank you so much😊🎉

  • @Sudharsan-dq6fi
    @Sudharsan-dq6fi 3 месяца назад +1

    Thank you so much for this killer hack...

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Thanks Sudharsan... Glad you found the video useful 🙂

  • @rrrprogram8667
    @rrrprogram8667 3 месяца назад +2

    Brilliant.... I know easy method to copy all the files name in a folder... But i didn't knew how to rename all the files in one go....
    Excellent job..
    Loved it

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful 🙂

  • @timmcauley6061
    @timmcauley6061 3 месяца назад

    This was so useful and has streamlined my photography workflow. No need to run my VBA code to create csv files and then Powershell scripts using those csv files as imput!!!! Thank You!!!~

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Thanks Tim... Glad you found the video helpful 🙂

  • @izzatkiswani
    @izzatkiswani 3 месяца назад +1

    Thank you !

  • @jonnyostensen2471
    @jonnyostensen2471 3 месяца назад +1

    This was really useful. No need for VBA or Python scripts. Thank you!

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Yeah, pretty good trick and needs no programming or automation.

  • @da_ta
    @da_ta 3 месяца назад +1

    Excellent thanks

  • @Pigeon0fDoom
    @Pigeon0fDoom 3 месяца назад +2

    I needed this 5 years ago! where were you?
    We had to check a list in excel vs a folder to check if either was complete and change the names of the old files to the new format.
    about 6000 files. i feel so... so... i dont wanna talk about it.
    (like and add to playlist "excel to never forget")

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Just got a bit late in making this one 😉

    • @Pigeon0fDoom
      @Pigeon0fDoom 3 месяца назад

      @@trumpexcel okay, understandable, have a nice day

  • @chandanlimma3443
    @chandanlimma3443 3 месяца назад +1

    Brilliant

  • @micheltremblay8184
    @micheltremblay8184 3 месяца назад +1

    Thank you, very wise :)

  • @jhankhanajani9314
    @jhankhanajani9314 3 месяца назад

    Thank you Sumit !!

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful 🙂

  • @wiktoriawiki1862
    @wiktoriawiki1862 3 месяца назад +1

    Excellent!! 😁

  • @relax_eglence
    @relax_eglence 3 месяца назад +1

    Thank you very much

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video useful 🙂

  • @playwithdata_03
    @playwithdata_03 15 дней назад

    Thanks Sir for this video ❤

  • @gsuderman
    @gsuderman 3 месяца назад

    Brilliant and simple too. Thank-you

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful 🙂

  • @excelmixture
    @excelmixture 3 месяца назад +1

    Great 👍

  • @bjbrooks
    @bjbrooks 3 месяца назад +1

    Great tip, love it, really useful. Previously, I've done that sort of renaming using Excel to create the command, but I've always then created a .BAT file. This is much quicker and easier! (And I didn't know you could type "CMD" in the Explorer address bar!). Nice one, thank you.

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Thanks Brian... Glad you found the video helpful 🙂

  • @russnorcup
    @russnorcup 3 месяца назад +1

    Excellent video will use your tips again

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful 🙂

  • @temyraverdana6421
    @temyraverdana6421 3 месяца назад +1

    Great idea, thanks a lot

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful 🙂

  • @abhishekpandey21790
    @abhishekpandey21790 2 месяца назад

    Hi Sumit, can you make a video about pasting filtered value in different cell, I mean value in the filter not entire column.

  • @quytngo920
    @quytngo920 29 дней назад

    Thank bro

  • @sekharispassion
    @sekharispassion 3 месяца назад +1

    Sir, thanks a lot for the video and xl file.

    • @trumpexcel
      @trumpexcel  3 месяца назад

      Glad you found the video helpful 🙂

  • @rickyrock311
    @rickyrock311 Месяц назад

    Great!!!, what if i need only pdf in the subfolders to rename it.

  • @guptaharsh3183
    @guptaharsh3183 Месяц назад

    Can you Tell the Command to Rename All the File Name along with the Files of the Sub Folders?

  • @tedmoy
    @tedmoy 3 месяца назад

    Would also show us how to use the Command Prompt to rename folders and also subfolders as well?

    • @trumpexcel
      @trumpexcel  3 месяца назад +1

      You can rename the subfolders the same way you would rename a file. But for files within sub folders, you'll have to get into with each subfolder and then run the command

    • @tedmoy
      @tedmoy 3 месяца назад

      thank you!@@trumpexcel

  • @georgepapaioannou3924
    @georgepapaioannou3924 3 месяца назад +1

    what if we use power automate instead?

    • @trumpexcel
      @trumpexcel  3 месяца назад

      That would work too.. this is more of a quick and dirty trick if you want to do it one time. With Power Automate, you can make it a repeatable process.

  • @tedmoy
    @tedmoy 3 месяца назад

    You used to have a link where we can donate funds for your coffee budget. What happen to that link?

    • @trumpexcel
      @trumpexcel  3 месяца назад +1

      It's there in the video description 🙂 Putting it here as well - www.buymeacoffee.com/SumitB

    • @tedmoy
      @tedmoy 3 месяца назад

      Please keep this available on your videos. ;-)@@trumpexcel

  • @igboanugosamuel3375
    @igboanugosamuel3375 3 месяца назад

    wonder video,please i will like you to cover topics on power pivot, Dax and Data visualization in your next topic