PDF Mail Merge from Excel

What Is PDF Mail Merge from Excel?

PDF mail merge from Excel is the process of filling a PDF template with data from an Excel spreadsheet — generating one personalized PDF document per row. It works like traditional Word mail merge, but outputs PDF files instead of printed letters.

If you have an Excel file with client names, invoice amounts, dates, or any structured data, you can merge those values into a PDF template automatically. One template + one spreadsheet = hundreds of individualized documents.

Prerequisites

• A PDF template — an invoice, certificate, contract, label, or any PDF you want to fill with data
• An Excel file — .xlsx, .xls, or .ods with column headers in the first row and data starting from row two
• A free Mergram account — sign up at mergram.com/new

How to Mail Merge from Excel

Step 1 — Upload Your PDF Template

Open the Mergram editor and upload a PDF file from your computer. You can also import a design directly from Canva via the built-in integration. Your template defines the static layout — logos, borders, headings, and any content that stays the same across all generated documents.

Accepted template formats:

• PDF files — Any PDF from Adobe Acrobat, Word, Google Docs, InDesign, or Canva
• Images — PNG or JPEG files (automatically converted to PDF)
• Canva designs — Import directly via the Canva connection

Step 2 — Upload Your Excel File

In the Data Source tab, upload your Excel file. Mergram supports three spreadsheet formats:

The first row of your spreadsheet is treated as column headers. Each subsequent row is one record to merge.

Step 3 — Place Data Fields on Your PDF

Drag column headers from the sidebar directly onto your PDF pages. Each column becomes a positioned field you can resize, align, and configure:

• Text — Names, addresses, amounts, dates, any textual data
• QR Codes — Payment links, verification URLs, product IDs
• Barcodes — Code 128, EAN-13, UPC-A, Code 39, ITF-14, Pharmacode
• Images — Photos, logos, signatures (matched by filename from Media Albums)

Position fields freely on any page. Snap-to-center guides help with alignment.

Step 4 — Preview with Real Data

Use the row selector to preview any row rendered directly in your browser. This runs client-side — no server round-trip, no data upload for preview. Check alignment, font sizes, and data formatting before committing to a full run.

Step 5 — Generate & Download

Choose your output format:

• Individual PDFs — One file per row, packaged as a ZIP download
• Combined PDF — All pages concatenated into a single document
• Email delivery — Each PDF sent as a personalized email attachment

Background workers process up to 100,000 rows with real-time progress tracking, pause, and resume support.

Excel Data Tips

Spreadsheet Structure

Your Excel file should follow a simple tabular structure:

Column header best practices:

• Use clear, descriptive names: Client Name, Invoice Number, Due Date
• Avoid special characters in headers: prefer First_Name over First Name (Primary)
• Keep headers unique — duplicate column names are not supported

Formula Handling

Mergram reads computed cell values from your Excel file, not the underlying formulas. If your spreadsheet uses formulas (e.g., =A2+B2), make sure the calculated results are the values you want merged.

Data Cleaning Checklist

Before uploading your Excel file, verify:

1. No merged cells — Merged cells can cause column misalignment
2. No blank header rows — The first row must contain your column names
3. Consistent data types — Dates should be in a standard format, numbers without text prefixes
4. No leading/trailing spaces — Extra spaces in headers may create duplicate-looking field names
5. Remove empty columns — Unnecessary columns add clutter to the field sidebar

Encoding and Character Support

Mergram supports full Unicode in cell values — accented characters (é, ñ, ü), CJK scripts (写真, テスト, 한글), Cyrillic (фото), Vietnamese tone marks (tài), and emoji. Your data displays correctly without any special configuration.

Common Use Cases

Best Practices

1. Use .xlsx format when possible — It’s the most widely supported and handles large datasets efficiently
2. Keep a clean header row — Clear, unique column names make field mapping straightforward
3. Preview before bulk generating — Check at least 2–3 rows to verify formatting and alignment
4. Use filename templates — Name output files dynamically: Invoice_[[InvoiceNumber]]_[[ClientName]].pdf
5. Save your template — After placing fields, save the template so you can re-run merges with updated data without re-placing fields

Get Started

Upload your PDF template and Excel file to Mergram, drag column headers onto your template, and generate personalized documents in minutes. No coding, no desktop software — everything runs in your browser.

Try it free: mergram.com/new

New to mail merge? Start with the free demo — no sign-up required.