How to Create Multiple Personalized PDF Copies with Different Headers
Question details
The user needs to automatically generate multiple personalized copies of a PDF document, each containing a unique header and recipient name mapped to sequential file names derived from an Excel list.

- Product
- PDF Editor
- Device & OS
- not provided
- Scenario
- Automating document personalization for a large batch of PDFs based on spreadsheet data to avoid tedious manual editing.
- Observed behavior
- Manual creation is highly impractical for large document sets, requiring an automated batch process or mail-merge solution to handle the headers and file naming accurately.
Ensure your Excel list is properly formatted with clear column headers (e.g., Recipient Name, Copy Number) and verify that all data is free of special characters that might cause file naming errors during the batch process.
Use an Acrobat Action Wizard and JavaScript Batch Process
Automate the PDF personalization process by running a custom JavaScript within Adobe Acrobat's Action Wizard to read data from a spreadsheet and apply it to the PDFs.
Adobe Acrobat Pro allows users to run custom JavaScripts that pull data from an external file (like a CSV exported from Excel) and place it into specific form fields or headers. Additionally, it can rename the output files based on variables like copy numbers and recipient names.
Export your Excel spreadsheet as a Tab-Delimited text file or CSV file to ensure compatibility with Acrobat JavaScript.
Open Adobe Acrobat Pro, navigate to the Tools menu, and select 'Action Wizard'.
Click 'New Action' and add the 'Execute JavaScript' command from the tools pane into your action steps.
Input your custom batch processing script designed to read the CSV, populate the header text fields, and save the document with the dynamic file name (e.g., 001_Filename_Adam.pdf).
Run the Action on your template PDF document. Test with a small batch of 2-3 records first to ensure the headers and file names generate accurately.

Use Microsoft Word Mail Merge to Export Individual PDFs
If you have the original source document in Word, using the native Mail Merge feature combined with an auto-split or third-party PDF exporter is often simpler than scripting in Acrobat.
Utilize Specialized PDF Automation Plug-ins
For users without coding experience, using a dedicated batch watermark or mail-merge plug-in for your PDF software is the most efficient solution.
Easily Automate Personalized Documents with WPS Office
WPS Office provides a powerful, built-in Mail Merge feature in its Writer application, allowing you to easily link an Excel spreadsheet to a document template and export personalized copies to PDF format efficiently.
- 1. Open Document: Open your document template in WPS Writer.
- 2. Connect Data Source: Go to the 'Mailings' tab, click 'Open Data Source', and select your Excel spreadsheet containing the names and copy numbers.
- 3. Insert Fields: Place your cursor in the header or text area and click 'Insert Merge Field' to add the dynamic data placeholders.
- 4. Merge to PDF: Click 'Merge to New Document' to generate the individualized pages, which can then be seamlessly exported as a PDF file.

Frequently Asked Questions
Can I automate PDF file naming based on Excel data?
Yes. When using a batch script in Adobe Acrobat or specialized mail merge software, you can map specific columns in your Excel file (such as Copy Number and Recipient Name) to dictate the final output file name, for example, '001_Filename_Adam.pdf'.
Do I need programming skills to batch process PDFs?
Writing custom JavaScript for Adobe Acrobat does require basic scripting knowledge. However, if you lack coding experience, you can use specialized third-party plug-ins or leverage the Mail Merge feature in word processors like WPS Writer to achieve the same result without any programming.
Why are my batch processed PDFs failing to recognize the Excel data?
This usually occurs if the data source is not exported in a format supported by the script (like CSV or Tab-Delimited text) or if there are unrecognized special characters in the column headers. Double-check your spreadsheet formatting and ensure column mappings perfectly match the script.
Can I add different watermarks to multiple PDFs at once?
Yes, PDF Action Wizards or third-party batch watermark tools allow you to apply dynamic text, such as customized headers, individual names, or personalized watermarks, across multiple PDF documents simultaneously using structured data from a spreadsheet.




