Excel spreadsheet with Visual Basic macros which allow bulk renaming, copying, and moving of files or folders in Windows Explorer.
Designed for Windows computers only, not Macs.
Download for $8CAD from https://legaltree.gumroad.com/l/cvrqj
The following tabs in the spreadsheet offer the following functionality:
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.
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.
Rename paths ("Move"): Tool to rename any part of the path e.g. just the file name, just the folder path, or both.
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): 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 https://youtu.be/6E1Th5RTTBk
Security issues