How to rename multiple files at once using excel

Changing thousands of filename manually could make you crazy. This is why in this advanced excel tutorial i have showed you how you can change thousands of file name at once using just excel. We are going to use vba code for this tutorial. Lets get started:
-------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------
Step 2: Write the name you want them to be renamed with in column B
Step 4: Click on visual basic
Step 5: Click on Insert and then Module
Step 7: Click on "run" button
Step 8: Select the folder where you kept all your files.
Step 9: Click OK and Boom. All your files at that folder is renamed.
#Rename #File
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Playlists:

Social media:

[michaelhand]

I just want to leave a review that the Visual Basic module works great. I was able to rename 70, 000 files and the module only had to run for about 20 seconds. On smaller folders of 5, 000 files or less, the module renamed the files almost instantly. Thank you so much for this time saver.

[mayu]

Boss! must say you're magician. you saved big amount of my time for renaming 2200 files. it work magically! Thank you!

[makatsulukidze]

I watched multiple videos, this was the most useful and got the job done. Thank you for sharing!

[dangliemvo]

Just give a great comment that even though the post was in 2019 but it is still greatly workable for 2023 with Window 10 Office 365.
Brilliant!!!

[katarinamilosavljevic]

I've just signed up and waiting for the code! Thank you so much!

[thrifty]

Signed up and waiting for code. Been looking for this ty.

[sree]

Bro, Typing original name takes huge time instead we can rename file directly.
My original name is like name of persons.

Please suggest a way to copy original name files in excel.

[michellesamson]

Already signed up. Waiting for the code. Thank you very much..

[KebunKurmaSemarang]

this is the one I need, thanks bro it works perfectly

[mnzsecuritiesltd]

It's really great. Can I get the code? It's too needful for me.

[Sagar-qtyr]

I have one question sir same code will apply for every situation

[ameraizatmahamod]

Seems very helpful. Waiting for the code now! :)

[virginiajustus]

Thanks! Signed up and can't wait to get the code.

[helenmclaughlin]

This is just want i have been looking for, thanks for the video, how do i get the code?

[nohson]

I signup! Can't wait to get the code.

[kayomarzbacha]

Signed up for 2 of your tutorials, awaiting code for
1. Extracting file names, path and ext
2. Renaming the file names

thanks

[pingucheng]

you are the star. brilliant! I have subscribed to your channel.

[breemerryn]

This looks very promising I have applied for the code many thanks

[lokeshsarnot]

Thank you for the video! waiting for the code :)

[youshiyun]

Hi, thanks for the wonderful video and code. Found some problem with the code from my side. After updated to Excel 2016, the Application.Match is no longer available, so it fail to match my original file and rename it. Do you have any solution on this？thanks