How to Bulk Generate Designs from a Canva Template

How to Bulk-Generate Personalized PDFs from Canva Templates

Canva mail merge is the process of importing a Canva design into Mergram, connecting it to a spreadsheet of recipient data, and automatically generating a unique, personalized PDF for every row. Instead of manually editing hundreds of designs in Canva, you design once and let data do the rest.

Canva makes it easy to create stunning visual designs — certificates, invitations, ID badges, postcards, promotional flyers, and more. But when you need hundreds or thousands of personalized versions, manually editing each one is impossible. Mergram bridges this gap: import your Canva design as a template, connect a spreadsheet, and generate every personalized PDF in a single operation.

Prerequisites

Before you begin, you need:

• A Canva account with at least one design to use as a template
• A spreadsheet with your recipient data (Excel, CSV, or Google Sheets)
• A free Mergram account

Step 1: Design Your Template in Canva

Create your design in Canva with personalization in mind. The key principle: include all static elements in Canva, and leave blank space where variable data will go.

Design Tips for Merge-Ready Templates

Design your Canva template with these principles — leave blank space for variable data, use standard page sizes (A4, Letter), and avoid placing text where merge fields will go. For a full reference on supported design elements and import limitations, see the Canva Templates documentation.

Recommended Blank Areas by Design Type

Step 2: Connect Canva and Import Your Design

Once your Canva template is ready, bring it into Mergram:

Connect Your Canva Account

1. Open the Mergram editor
2. Click Import from Canva in the editor welcome screen or toolbar
3. If this is your first time, you will be prompted to sign in to Canva and authorize Mergram
4. Mergram requests read-only access — your designs are never modified

Browse and Import

1. After connecting, a design picker opens showing your Canva designs as a thumbnail grid
2. Search by design name if you have many designs
3. Click a design to select it
4. Click Import as PDF — Mergram exports the design via the Canva API and converts it to a high-resolution PDF
5. The PDF loads directly into the Mergram editor as your merge template

Step 3: Prepare Your Data Spreadsheet

Create a spreadsheet with one row per recipient and one column per variable field. The column headers become the field names you drag onto the canvas.

Example: Event Invitations

Example: Employee ID Cards

Supported File Formats

Step 4: Place Fields on the Canvas

With your PDF template loaded and spreadsheet uploaded, drag column headers from the Data Fields panel onto the canvas to create positioned fields.

Text Fields

1. Drag a column (e.g., GuestName) onto the canvas
2. Position it over the blank area in your Canva design
3. Resize the bounding box to fit the expected text length
4. Adjust font, size, color, and alignment in the properties panel

Image Fields (Photos, Logos)

To add per-recipient photos (see the guide to adding images to PDFs for a deeper walkthrough):

1. Create a Media Album — Go to Assets → Media Albums and create an album
2. Upload images — Add all recipient photos (PNG or JPEG)
3. Name files to match — Use filenames that correspond to a spreadsheet column value (e.g., alice-chen.jpg matches the cell value alice-chen)
4. Place an image field — Drag the PhotoFile column onto the canvas, set render type to “Image”
5. Link the album — In the editor’s Media tab, select the album you created
6. Resize the bounding box — images scale to cover the bounding box width

QR Code Fields

Add scannable QR codes for verification, links, or unique identifiers:

1. Add a column with URLs or text to encode (e.g., https://verify.example.com/INV-001)
2. Drag the column onto the canvas
3. Set render type to “QR Code”
4. Resize — QR codes scale to cover the bounding box width and stay square

Barcode Fields

For ID numbers, product codes, or tracking numbers:

1. Add a column with numeric or alphanumeric codes
2. Place the field and set render type to “Barcode”
3. The barcode stretches horizontally to fill the bounding box width

Step 5: Preview and Merge

Before running the full batch, preview individual rows to verify accuracy.

Preview

1. Click Preview in the toolbar
2. Browse through rows using the row selector
3. Check that text fits, images appear, and QR codes/barcodes scan correctly
4. Verify with the longest text values in your dataset to catch overflow

Run the Merge

1. Click Merge in the toolbar
2. Choose your output options:

3. Click Start Merge — the job runs server-side in the background
4. Download results individually, as a ZIP archive, or via CSV export

Advanced: Send via Email Campaign

Deliver personalized PDFs directly to recipients’ inboxes (see how to send merged PDFs via email for full setup instructions):

1. Configure SMTP — Set up your email provider in Settings → SMTP
2. Switch to email mode — In the merge dialog, select Email Campaign
3. Write your email template — Use merge fields for personalization:

Subject: Your Invitation — [[EventDate]]

Dear [[GuestName]],

We are delighted to invite you to our gala dinner on [[EventDate]].
Your table number is [[TableNumber]] and your unique invite code is [[InviteCode]].

Your personalized invitation is attached.

Warm regards,
The Events Team

4. Run the campaign — Each recipient receives their personalized PDF as an attachment

Design Type Examples

Here are real-world scenarios where bulk-generating from Canva templates saves hours:

Tips for Best Results

1. Design at exact output dimensions — Set custom dimensions in Canva before starting. Resizing after import affects quality
2. Preview with edge-case data — Test the longest names, longest addresses, and most complex data before bulk merge
3. Keep Canva originals — Save your Canva design in case you need to adjust the layout after testing merges
4. Use high-resolution images — For Media Album photos, use at least 300 DPI at the target print size
5. Match your fonts — Upload the same fonts used in your Canva design to Mergram for consistent typography (see custom fonts in PDFs)
6. Use QR codes for verification — Each QR code is unique per row, perfect for event check-in or certificate authentication
7. Batch by category — If generating for multiple events or groups, sort your spreadsheet so you can merge in organized batches

Common Issues and Troubleshooting

Design looks different after import: Canva uses its own font rendering. Subtle differences may appear in the PDF conversion. This only affects the static background — merge fields use Mergram’s rendering. To minimize differences, use standard fonts in Canva.

Text overflows the bounding box: Reduce the font size for the field, or widen the bounding box. Preview with the longest value in your dataset to catch this before bulk merge.

Photos not appearing: Check that your Media Album is linked in the editor’s Media tab, and that spreadsheet values exactly match the uploaded image filenames (case-insensitive, without file extension). Extra spaces or different spelling cause mismatches.

Import takes a long time: Large or complex Canva designs take longer to export. The import process converts the full design to PDF via the Canva API — wait for the “Imported successfully” confirmation before proceeding.

Re-import lost my field positions: This is expected. When you re-import a design, the background template changes and field positions may not align. You need to re-place fields on the canvas. Consider saving your template in Mergram before re-importing so you can reference the previous field layout.

Get Started

Design your template in Canva, connect your account in the Mergram editor, import your design, upload your spreadsheet, and generate hundreds of personalized PDFs in minutes.