Excel spreadsheet with macros to bulk/batch rename, copy, and move, files in Windows Explorer
HTML-код
- Опубликовано: 15 сен 2024
- Spreadsheet can be downloaded through link at www.legaltree....
Spreadsheet contains macros which allow bulk renaming, copying, and moving of files or folders in Windows Explorer. The following tabs in the spreadsheet offer the following functionality:
0:53 Rename files in place
Tool to rename files in their existing locations. The new name data can be created in Excel, typically using the original file names as starting data and then manipulating the data as needed e.g. using “find and replace”, or functions such as LEFT, RIGHT, LEN, VLOOKUP, etc.
4:39 Create subfolders
Tool to create empty subfolders (up to three levels) in the specified parent folder. Useful, for example, to create library of year and month folders for photographs.
7:43 Rename paths ("Move")
Tool to rename any part of the path e.g. just the file name, just the folder path, or both.
11:43 Copy to folders (& can rename)
Tool to put copies of listed files into specified target folders. The target folders do not need to already exist, but will be made by the macro as needed.
Helper sheet (Build file names) (used as part of "Copy to folders" demonstration):
Helper sheet to assist with building useful file names from pre-existing data. File metadata e.g. date modified, or photo date last taken, can be extracted from files using the FileList Software described in the previous video at • Export detailed metada...
You!, Good sir are god sent. God bless you. Saved so much of my time. I can't believe this only got 2k views. Definitely subscribing.
Wow!!!! Thank you for this Michael this is really such a big help! Been doing the manual renaming of PDF file for such a long time! Finally save a lot of time bcoz of this! A day will now be a minute only 😍 love this! super helpful 101%
Hope you can also share how to set password for multiple PDF files 😊
Thanks this is rather useful - I was doing it using CMD, but this is a lot quicker.
1 item to comment on - around the 13 min mark you reference using another methodology for extracting the date modified details for each file. If you copy the location of the files and paste them into the URL bar in Chrome, it will list everything as text. Ctrl+A then Ctrl+C and paste the details into Excel - Job is done! Much quicker ;-)
Wow, nice, I did not know about that trick with Chrome, thanks for sharing!
Wow Michael !!
thanks fir sharing, its saved my 10 days work.
Excellent tool Michael and a great video. Bravo!
This is mind blowing and really helpful.
No words..thanks a lot...amazing
U deserve millions bro
Really, that is like a magic tools
Thank you
Wow thank you so much, work’s amazingly!
Just a question, we cannot rename subfolders is that correct ? Only files?
You can rename folders, use the 'Rename paths ("Move")' tab. As per the instructions on that tab:
CAN change the paths of folders (including folders that contain subfolders and files), but when listing the current and target paths of folders to be renamed specify only the portions of the paths up to and including the end of the old and new folder names.
CAN'T change the portion of a path before the file name, or before the last folder name (if the path ends with a folder), i.e. the target "parent folder" paths must already exist.
Very helpful. Thanks a lot!
Hello Michael, I purchased your spreadsheet, but I get an error that it can not run the macro. Could you help me?
Sure, you can email me at legaltree at gmail dot com.
it is magic you are amazing reallyyyyyyyy really thaaaaaaank you man
Hi,
The rename paths function is throwing an error and not allowing me to run the macro. The paths exist, they're spelled right, I have copied as values but I cannot seem to get it to run. I even renamed the file names to numbers just to see if it was a formatting of the file names in the folders themselves. Not sure what else to do
If you email me the file I will take a look at it. You can get my email address from the "about" page of my youtube channel. Even though I will not have the corresponding library of files I may be able to draw some conclusions by looking at your data.
@@MichaelDewTechTips thank you, just emailed you
@@blackrandy77 hmmm...it did not come through yet, did you send it to legaltree "at" gmail ?
Waw... Very nice.. Thanks you..
Bravoo👏👏👏
we have lots of excel file ...then how to convert the excel file name with the specific cell value....
every file have different cell value....
Sorry, I do not understand your question, you will have to be more clear...
Amazing!! Thank you.
I bought this macro 6 months ago. It is excellent. However I moved this file from one folder to another for easier access. It is disabled. I have tried to enable in trust centre, it still does not work? Do you have any suggestion to resolve this? Or do I have to pay again to redownload? Thank you
No, your file should not have expired yet, and you will get an express message to that effect when that occurs. Probably it is a security setting on your PC. You should make the location the file is saved in a "trusted location", see notes at the link in the description.
@@MichaelDewTechTips Thank you Michael for your quick reply. I have tried the following steps. However, it still does not work. "Add the file location to the trusted locations: You can add the new location where you have moved the xlsm file to the Trusted Locations in Excel. Go to "File" > "Options" > "Trust Center" > "Trust Center Settings" > "Trusted Locations". Add the folder location where the xlsm file is stored in the "Path" section".
@@olliesplace4533 send me an email at legaltree at gmail and I will reply with a fresh file just in case the file somehow got corrupted (?)
Thanks this really helps
Any way to get a little support? Love the idea and the flexibility and the simple instructions and functionality... but getting a run-time error even after passing the "pre-check for errors" on Rename Files In Place... 145 files for which I pasted into the last column (rather than edit original names) the new filenames, as text, with extensions, from another spreadsheet.
That seems strange. If you email me your spreadsheet (see email address on about page) with the content you pasted in then I can take a look at it...
@@MichaelDewTechTips will do, thanks for the quick reply!
FYI for others, the issue was an open file which interfered with renaming - do remember to close all files before running the renaming macro.
so helpful thank you
GOAT
I get this error. How do I fix it? "The file extension for the new name does not match the file extension for the new name. Spaces on the end of the new name may trigger this error"
The file extensions for both the old file name and the new file name must match. A space on the end of the new file name could cause the macro to detect an error. Before running the macro you can use the TRIM function in Excel to remove spaces from the end of contents. exceljet.net/excel-functions/excel-trim-function
@@MichaelDewTechTips Still couldn't work. We were trying to reply to your email but it says "noreply".
@@e-lib4all441 If you want you can get my gmail address from the "about" page on the youtube channel and email me your spreadsheet with data in it and I can take a look at it (may take a day or so to get to it though).
@@MichaelDewTechTips Thanks, sent!
In case others might benefit from this clarification: every file needs a complete new name, including a proper file extension (e.g. ".pdf"), and the file extension of the new file name on each row must match the file extension of the old file name on that same row.
Bravo!
this video is very well but i didn't find the excel file can you give excel file ?
Follow the link in the description. It is a paid download.
it works great
Thanks man
You are amazing! Is there a direct shortcut key to paste data as value?
"Ctrl + V", then "Ctrl", then "V". Actually goes pretty quick once you get the hang of it i.e. you can do those three steps in very quick succession.
I tried multiple times doesnt seem to work with zip or audio files
I have an updated version that I have been experimenting with that has better code and may work for your files. If you email me I will email you a copy of that updated version to try out. Also, I will likely soon upload that improved version.
@@MichaelDewTechTips great thanks
@@MichaelDewTechTips I got it to work finally lol just need to moove it to like 2-4 more subfolderes
@@Calicrazedbeats Glad you got it to work, but can you clarify, did the original spreadsheet you downloaded work, or just the new one I emailed you? Also, is it working perfectly or would you say there is still a bug / shortcoming in the spreadsheet?
@@MichaelDewTechTips The downloaded file works ok. At a certain point glitches sometimes like the file name extrated will display accross the entire row after first column. I have to repeate the process twice to get the tiles to move down to the 5th or sixth subfilder. I have not received the emailed update
Hello. I am from India and I cannot be able to make the payment
Other people have purchased from India, but you could try a VPN if needed.
@@MichaelDewTechTips it's saying unable to process your request.can you please say any alternate way to pay
@@rajmitra4715 email me at legaltree "at" gmail.com
I cant kiss you. But I would! Damn this so helpful. You created a new horizen in my mind!
Hi Michael
Great video - could you please help or direct me to one of you vids.
I have hundreds of files with unique names. I have then produced those files into basic file names but in order as originals. Eg.
OLD NEW
ancdef.jpg = _01.mp4
bcffgff.jpg = _02.mp4
...and so on. I would like to replace new names back to original names.
Thank you for your help
Frank
You should be able to use the "rename files in place" sheet as explained starting at 0:53 in the video. You cannot change file name extensions, so the new names and old names have to have the same file extensions. You can use Excel functions such as LEFT, RIGHT, LEN, VLOOKUP, etc. to juggle the data before applying the renaming.
this is free?
No, currently, it costs just a bit more than a fancy cup of coffee...