How to Bulk Generate Certificates

Bulk-Generating Personalized Certificates

Creating certificates one at a time is impractical when you have a class of 30 students, a training cohort of 200 professionals, or a conference with 500 attendees. With Mergram, you can design a certificate template once, connect a spreadsheet of recipients, and generate every personalized certificate in a single operation.

Prerequisites

To bulk-generate certificates, you need:

• A certificate design exported as PDF — with blank space for variable data
• A spreadsheet with recipient information (names, course titles, dates, etc.)
• A Mergram account

Certificate Template Design Tips

A professional certificate has several key elements:

Preparing Your Recipient Data

Create a spreadsheet with one row per recipient. Include all the variable fields you need:

Placing Fields on the Certificate

Text Fields

Drag each spreadsheet column onto the canvas in the corresponding position:

1. RecipientName — Center of the certificate, large font (24–36pt)
2. CourseTitle — Below the name, medium font (14–18pt)
3. CompletionDate — Lower section, regular font (12–14pt)
4. CredentialID — Bottom corner, small font (10–12pt)
5. InstructorName — Near the signature area, regular font

QR Verification Codes

Add a QR code field linking to a verification page:

1. Add a column to your spreadsheet with verification URLs: https://verify.example.com/CRED-2025-001
2. Place the field on the canvas and set render type to “QR Code”
3. Position in a bottom corner — small enough to be unobtrusive, large enough to scan

Recipient Photos

To add photos to certificates:

1. Create a Media Album — Upload all recipient photos (PNG or JPEG)
2. Name files to match — Use filenames that match a spreadsheet column (e.g., alice-chen.jpg matches alice-chen in the cell)
3. Place an image field — Set render type to “Image” and resize the bounding box to the desired width. Images scale to cover the bounding box width.
4. Link the album — Connect the Media Album in the editor’s Media tab

Custom Fonts

For formal certificates, upload and apply custom fonts:

1. Go to Assets → Fonts and upload a calligraphic or script font
2. Select the RecipientName field on the canvas
3. Change the font in the properties panel to your uploaded script font
4. Preview to verify the name renders in the formal typeface

Output Options

Choose the right output mode for your distribution method:

Filename Templates

Use meaningful filenames when generating individual PDFs:

Sending Certificates via Email

Deliver certificates directly to recipients’ inboxes using the email campaign feature:

1. Configure SMTP — Set up your email provider in Settings → SMTP
2. Write email template — Use merge fields for personalization:

Subject: Your Certificate for [[CourseTitle]]

Dear [[RecipientName]],

Congratulations on completing [[CourseTitle]]!

Your certificate is attached to this email. It includes a QR verification code that can be scanned to confirm your credential (ID: [[CredentialID]]).

We wish you continued success in your professional development.

Best regards,
The Training Team

3. Run the campaign — Each recipient gets their personalized certificate as a PDF attachment

Real-World Certificate Use Cases

Best Practices for Certificate Generation

1. Design at print resolution — Create your template at 300 DPI for crisp printing on cardstock
2. Use landscape orientation — Certificates traditionally use landscape (horizontal) layout
3. Leave ample white space — Cramped certificates look unprofessional. Give the recipient name prominent, centered placement
4. Test with the longest name — Preview with the longest recipient name in your dataset to ensure it doesn’t overflow
5. Standardize credential IDs — Use a consistent format (e.g., CRED-YYYY-NNN) for easy reference and sorting
6. Include a verification method — QR codes or credential IDs that can be looked up online add credibility
7. Batch by course or date — If generating certificates for multiple courses, sort or filter your spreadsheet to keep batches organized

Common Issues and Troubleshooting

Long names overflow the field: Reduce the font size for the recipient name field, or increase the field width. Preview with the longest name in your dataset before running the full merge.

Dates appear in wrong format: Mergram uses the text exactly as it appears in the spreadsheet cell. If dates show as 2025-01-15 instead of January 15, 2025, pre-format the date column in your spreadsheet as text with the desired format.

Photos not appearing on certificates: Verify your Media Album is linked to the template and that spreadsheet values match the uploaded image filenames. Check for extra spaces or different capitalization.

QR codes too small to scan: Increase the QR code bounding box size. A minimum of 1cm x 1cm is recommended. Test by scanning a preview with your phone camera.

Fonts not rendering correctly: Ensure you’ve uploaded the correct font file and applied it to the specific field. Preview to verify — if characters are missing, the font may not cover the required Unicode range. Switch to a broader-coverage font.

Get Started

Design your certificate, prepare your recipient spreadsheet, and upload both to the Mergram editor. Place your fields, apply custom fonts, add QR codes, and generate your entire batch of certificates in minutes.