I have been given a folder of over 1760 files. These are inside multiple directories.

I managed to make a file of all the filenames and paths. But I'm hoping excel can help with the renaming.

My idea is to enter the original path and name in one cell and its new name and location in another, in 1700 rows and let it run.

I've found some renaming scripts, but none I've found deal with subfolders. In most cases I need to make the subfolder first myself and that would be tedious.

Anyone have any ideas where to start?