Batch rename using .csv/.xlsx file

I have a folder of about 100 files (all of them are *.pdf). They are named in a variety of ways. I'm going to copy paste the file names into an Excel worksheet and get them looking the way I'd like them to look (which is complicated and requires me to pull data individually from the PDF's using an OCR tool).

When I'm done, I would like to rename all of them to the new names. Is there a way to do this within the rename dialog box? Or is this something I would need to create a script to do?

TLDR: I want to rename about 100 *.pdf files using a .csv or .xlsx file that has the new names in it.

Another option I just discovered is that perhaps I could copy the new names from Excel and paste them into the rename dialog?

Perfect job opportunity for the Clipboard button!

https://www.gpsoft.com.au/help/opus12/index.html#!Documents/Advanced_Rename.htm