[SOLVED] Batch renaming multiple files with different titles

Thomster246

Commendable
Mar 12, 2017
12
0
1,510
Hello everyone

I was wondering if there is a method of 'batch' renaming a large number of files (in this case, audio files) with different titles for each individual file. There are over 1000 files to rename, enlisted as Track_01, Track_02, Track_03 etc, and the file names in question are stored on an Excel sheet.

If you know of a much faster method of completing this tedious task please let me know.

Thanks for reading.
 
Last edited:
Solution
In that Excel sheet, create a column which reads "ren <original name> <new name>", where names are some formulas (use Excel' string manipulation and concatenation to form these names.). Copy / Paste Special this column once into a new sheet, "Values only", then export this sheet as .BAT file, and execute it.
In that Excel sheet, create a column which reads "ren <original name> <new name>", where names are some formulas (use Excel' string manipulation and concatenation to form these names.). Copy / Paste Special this column once into a new sheet, "Values only", then export this sheet as .BAT file, and execute it.
 
Solution