How to update PDF Title with value from Excel

Question

I have searched and found information on importing excel data into a single PDF but that is not quite what I need. I need to loop through a directory of PDF's and if the pdf document name matchs the field PDF in my excel file then update the PDF Title field with the Title from the spreadsheet.

So basically loop through c:\pdfs and if PDF Name = Excel spreadsheet PDF column value then update the actual PDF Title with the value from the excel spreadsheet column Title. I guess I would have to scan every row of the spreadsheet to see if that PDF existed or not. Is this possible?

Thanks!

Excel:

PDF	TITLE
CL01000399.pdf	COMMON POLICY CONDITIONS

try67 · Accepted Answer

Edit: Sorry, my original reply was wrong. I misunderstood your request.Yes, this can be done in Acrobat, but it would require the development of a custom-made script and an Action.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded