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

No video

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

Рет қаралды 13,701

Күн бұрын

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.co...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com...
✅ Free Dashboard Course - bit.ly/free-ex...
✅ Free VBA course - bit.ly/excel-v...
✅ Free Power Query Course - bit.ly/power-q...
✅ Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

Пікірлер: 73

@trumpexcel 4 ай бұрын

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 4 ай бұрын

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

@rangs1966 4 ай бұрын

Please Publish new Videos on Power Query M Language

@trumpexcel 4 ай бұрын

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

@trumpexcel 4 ай бұрын

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

@IvanCortinas_ES 4 ай бұрын

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

@trumpexcel 4 ай бұрын

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

@DarkCobra88 21 күн бұрын

This was very useful, thank you. Windows default method (1), (2) when selecting multiple files with F2 is a let down and this is much more useful, i have a photo folder with hundred of images and this solves the issue right away. much appreciated.

@rutaztsai6760 4 ай бұрын

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

@trumpexcel 4 ай бұрын

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

@parag2684 4 ай бұрын

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

@trumpexcel 4 ай бұрын

Glad you found the video helpful Parag 🙂

@mrsfrenchy3 4 ай бұрын

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!

@danajohnston 2 ай бұрын

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

@rrrprogram8667 4 ай бұрын

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 4 ай бұрын

Glad you found the video helpful 🙂

@TunisianSpring 4 ай бұрын

Thank's a ton for these cool tricks!!

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@timmcauley6061 4 ай бұрын

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 4 ай бұрын

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

@jonnyostensen2471 4 ай бұрын

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

@trumpexcel 4 ай бұрын

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

@abdulsalam935 4 ай бұрын

Sir, your methods are simple SUPERB. Thank you.

@trumpexcel 4 ай бұрын

Thank you 🙂

@nana-t1w Ай бұрын

this very usefull! i can rename 3 folders each had more than 300 files less than 30 minutes! THANKYOU VERY MUCHHH

@Sudharsan-dq6fi 4 ай бұрын

Thank you so much for this killer hack...

@trumpexcel 4 ай бұрын

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

@Pigeon0fDoom 4 ай бұрын

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 4 ай бұрын

Just got a bit late in making this one 😉

@Pigeon0fDoom 4 ай бұрын

@@trumpexcel okay, understandable, have a nice day

@bjbrooks 4 ай бұрын

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 4 ай бұрын

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

@izzatkiswani 4 ай бұрын

Thank you !

@relax_eglence 4 ай бұрын

Thank you very much

@trumpexcel 4 ай бұрын

Glad you found the video useful 🙂

@russnorcup 4 ай бұрын

Excellent video will use your tips again

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@ghaziehaq Ай бұрын

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

@jhankhanajani9314 4 ай бұрын

Thank you Sumit !!

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@micheltremblay8184 4 ай бұрын

Thank you, very wise :)

@trumpexcel 4 ай бұрын

Thanks Michel 🙂

@gsuderman 4 ай бұрын

Brilliant and simple too. Thank-you

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@da_ta 4 ай бұрын

Excellent thanks

@playwithdata_03 2 ай бұрын

Thanks Sir for this video ❤

@wiktoriawiki1862 4 ай бұрын

Excellent!! 😁

@temyraverdana6421 4 ай бұрын

Great idea, thanks a lot

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@sekharispassion 4 ай бұрын

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

@trumpexcel 4 ай бұрын

Glad you found the video helpful 🙂

@NuliyaAmirafil 3 ай бұрын

Very helpful, thank you so much😊🎉

@scottlockhart7168 Ай бұрын

Great video. What would the command be if you would like to search for two types of files types at once? For example: *.pdf and *.txt

@abhishekpandey21790 4 ай бұрын

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

@guptaharsh3183 2 ай бұрын

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

@rickyrock311 3 ай бұрын

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

@quytngo920 2 ай бұрын

Thank bro

@chandanlimma3443 4 ай бұрын

Brilliant

@excelmixture 4 ай бұрын

Great 👍

@georgepapaioannou3924 4 ай бұрын

what if we use power automate instead?

@trumpexcel 4 ай бұрын

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 4 ай бұрын

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

@trumpexcel 4 ай бұрын

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 4 ай бұрын

thank you!@@trumpexcel

@tedmoy 4 ай бұрын

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

@trumpexcel 4 ай бұрын

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

@tedmoy 4 ай бұрын

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