Renaming WAV Files in a Folder

Greetings Everyone!

I request you for some assistance on a task that has been consuming a lot of time on a day-to-day basis. I’m currently doing this manually, which requires me to work through 1000+ files daily.

The task entails the following:

1. I have 1000+ wav files in a folder
2. The naming convention is as follows: “10059853 2014-06-05 09_12_54 0123456789 -_ 12146135740 ID_16207461.wav”
3. Each name has a unique ID at the beginning “10059853“ in this case
4. I have another list (2000-5000) entries with some more information. One of the columns in this has unique ID, which exactly match the unique ID of the file name

My request:

1. I’m seeking some help to be able to create a sub-folder within the folder / outside that has 1000+ WAV files
2. Rename the files (1000+) by picking the information from the larger list (2000-5000) for the IDs that match the IDs in the names of the “WAV files
3. Have attached a spreadsheet with some examples and the requested output

Appreciate all your help on this!

Happy to answer any questions or provide further clarity (if need be).

Best regards,
Spi