How to Generate Certificates in Bulk from an Excel Sheet (Mail Merge)

Whether you run a training course, coordinate a seminar, or manage award distributions, you regularly need to issue customized certificates. Standard mail merge in traditional desktop office tools is slow, shifts formatting fonts, and uploads documents to third-party clouds. Performing a local PDF mail merge solves these issues.

The Bulk Generation Workflow

iCreatePDF splits bulk certificate generation into three simple steps:

• Upload Layout Template: A single-page PDF template representing the blank certificate structure.
• Import Spreadsheet Data: An Excel table (.xlsx) or CSV containing rows of details (Recipient Name, Course Title, Issue Date, Grade).
• Map Draggable Placeholders: A visual browser preview where you drag spreadsheet variable labels onto their positions on the template page.

Formatting Fonts & Colors Locally

Once you drag a placeholder like {{Name}} onto the canvas, you can adjust:

• Font Family: Embed clean standard PDF typefaces (Helvetica, Times Roman, Courier).
• Text Alignment: Set alignment to Center for names to ensure short and long names remain centered on the layout.
• Font Size & Weights: Scale sizes up to 144pt and configure Bold weights.
• Branding Color: Pick custom hex color codes matching your corporate style guide.

Export Options: ZIP vs. Combined PDF

After setting up, choose how you want to download the generated files:

1. Combined PDF: Compiles all certificates into a single, multi-page PDF document. Ideal for bulk printing at a print shop.
2. ZIP Folder (Individual PDFs): Creates separate PDF files for each row, named after the primary naming column (e.g. Certificate - John_Doe.pdf). Ideal for emailing to recipients.