PDF Mail Merge
Share tool
Only this public address is included. Your files, inputs and results stay out of the link.
Fill PDF templates with rows from an Excel or CSV file. Map existing text fields or place text, preview individual records and create separate PDFs.
Preparing your tool…
A visual example
One table row becomes one PDF
Example: map the ID and name columns to the matching fields in your template.
Two source records ID Name 00001 Anna Müller 00002 Sam Keller Two source records
Keep identifiers as displayed text, including leading zeros.
Template mapping PDF field Table column Reference ID Recipient Name Template mapping
Choose which column supplies each PDF field or positioned text box.
- Separate PDFs
00001 · Anna Müller
00002 · Sam Keller
Two personalised copies
Each output uses the values from its own row.
Generate a sample with a long name or an empty value before confirming the batch.
Illustrative example. The tool creates files and does not send email. Overflow and unsupported characters are reported; text is not silently shrunk to fit. Date and decimal conversion are explicit choices.
How to use it
- Load a PDF template and table, choose the worksheet and header row, and review the displayed values.
- Map columns to existing text fields or rectangles on individual pages. Set fixed text size, wrapping, alignment and explicit blank/date/decimal rules.
- Generate sample PDFs and review every template page, including long and empty values. Correct any overflow or missing-character errors.
- Confirm the current mapping, create the batch and check the manifest. Download the ZIP or individual PDFs; failed records remain explicitly listed.
The synthetic example generates 100 two-page letters with IDs 00001–00100, accented names, a long wrapping name and optional multiline notes. A missing glyph or overflowing name produces a record error instead of clipped text.
Details & limits
10 MiB template, 1–20 unrotated pages, 5 MiB CSV/XLSX, 1–100 records, 60 mappings and 96 MiB output. At most 20 million embedded image pixels per document; unsupported filters are rejected. Ordinary text fields and Western European Helvetica/WinAnsi characters. Active, signed, encrypted, XFA and unsupported form templates are rejected. Embedded images: unfiltered/Flate pixels or checked JPEG, up to 8,192 px per side. Inline images, JPEG 2000, JBIG2, CCITT and unusual JPEG variants are unsupported.
Will the mail merge remove leading zeros or shrink long names?
Displayed table text is retained by default, including leading zeros. Date and decimal conversion require an explicit per-field choice. Text uses the selected fixed size: overflow must be corrected, never silently shrunk. Formula cells use stored results only. Original files stay unchanged; output metadata is not anonymized. Optional flattening removes form interactivity from the generated copies.