How can I rename multiple files in 1 folder with a list?

[Sean McDonough]

I have over 200 files in one folder on my Desktop. All files are PDFs. I need to insert info into each title, but the insert isn't the same for all. I have an excel file with a column of the original titled files and a column with the names they need to be changed to. Is there a tool I can use in Bulk Rename Utility that allows me to use the Excel sheet to change the names? Here's an example:

Column A Column B
John Doe Student.pdf John Doe (1000-1005) Student.pdf
John Smith Preschool.pdf John Smith (1006-1018) Preschool.pdf...



I've seen some instructions to use CMD, but don't understand most of it. The instructions are sort of confusing since I've only learned to use CMD for some things. (combining CSV files into one)
I was just wondering if there was a tool in Bulk Rename Utility that could be used to do this.

Thanks,
Sean

[therube]

Renaming From A Text File

With Bulk Rename Utility it is possible to rename files according to a text file. The text file should contain a list of "old name" and "new name" pairs, separated by a pipe symbol ( | ) or a comma ( , ). Bulk Rename Utility will read ANSI and Unicode (UTF-16) text files.

To use this facility, create a text file in for the correct format, for example:


Track001.mp3|Headlong.mp3
Track002.mp3|Rushes.mp3
TRACK003.mp3|AnywhereIs.mp3


or use comma separated (CSV)


Track001.mp3,Headlong.mp3
Track002.mp3,Rushes.mp3
TRACK003.mp3,AnywhereIs.mp3


One entry per line.


Next, click the Import Rename-Pairs on the Actions menu and select your file. If the file is valid, then select all the files to rename and you will see the "new name" column reflecting the contents of the text file.

When comparing the current filename with the text file, the application ignores the case of the filename, e.g. it will match Track001.mp3 and TRACK001.mp3. This makes it easy to rename the files.

Click on "Rename Pairs Imported" to show the list of imported renaming pairs.



Specifying Full Paths
You can also specify full paths, such as c:\folder\track1.mp3, in the first column for the old file names.
Then Bulk Rename Utility will match these names against the full path and not just the file name.


Text File Requirements
Bulk Rename Utility will read ANSI and Unicode (UTF-16) text files.


Note: You can view all the imported rename-pairs by selecting 'View Imported Rename-Pairs' from the Bulk Rename Utility menu.