Excel spreadsheet with macros to bulk/batch rename, copy, and move, files in Windows Explorer

Excel spreadsheet with Visual Basic 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:

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.

Designed for Windows computers only, not Macs.

More details: https://www.legaltree.ca/node/2247

Video of spreadsheet: https://youtu.be/v2gnHJ3RYxI

Terms of download and license:

• The price paid is for a license for a minimum of 1 year (file currently available for download expires February 2027).
• The spreadsheet can be used one user for any purpose (private or commercial) and on any number of devices used by that user.
• Transfer of the spreadsheet to others for their use (including, without limitation, resale of the spreadsheet), is not permitted.
• The sheets of the Workbook are not password protected or locked, and users may modify them as they see fit, but the Visual Basic Editor is locked.
• Users assume all risk of loss or damage resulting from use of the spreadsheet.