Certificate Mail Merge
One certificate template + a CSV of names = a ZIP of personalized certificates. Live preview, free, private.
100% private — names and files never leave your deviceMerge certificates
Both files are parsed on your device — nothing uploads.
3. Place each field on the certificate
Move the X/Y sliders (percent of page) and watch the live preview below. Preview uses the first row of your CSV.
Merging…
Add a template and a CSV to begin
Position each field live, then batch-generate every certificate.
How it works
Upload template + CSV
Your certificate design as a PDF, and a spreadsheet exported as CSV with a header row like Name,Course,Date. Everything is parsed locally — student lists stay on your machine.
Position fields with live preview
Each CSV column becomes a placeable field. Drag the X/Y sliders, set the size and font, and the preview updates instantly on top of your actual certificate design.
Download one ZIP
Every row becomes its own personalized PDF — named after the recipient — bundled into a single ZIP. Free for 10 or 10,000 certificates.
Why mail-merge your certificates this way
Certificate platforms like Certifier.io and Accredible are good products — but they charge $30 to $100+ a month, put your recipients' names on someone else's servers, and meter you per credential. If all you need is the PDFs themselves — course completions, workshop attendance, volunteer recognition — that's a lot of overhead for a job your browser can do in seconds.
The workflow here mirrors the classic mail-merge idea: one beautiful template designed once (in Canva, Illustrator, anywhere), one spreadsheet of recipients, and the tool combines them. Because the merge happens on-device, there's no per-certificate fee and no waiting on a render queue; 500 certificates take about as long as your machine needs to draw text on 500 pages.
Two details make or break a merge, and both are built in. First, positioning: eyeballing coordinates is hopeless, so the live preview renders your real template and shows exactly where each field lands before you generate anything. Second, messy CSVs: quoted fields with commas inside them ("Doe, Jane") are parsed correctly instead of splitting into extra columns. Empty cells simply render as nothing, so a missing date won't print the word "undefined" across your certificate.
Worked example
A coding bootcamp graduates 240 students. The template: a one-page PDF designed in Canva. The CSV: Name, Course, Date and Instructor columns exported from a spreadsheet. Positioning the four fields with the live preview takes about 5 minutes. The merge produces 240 personalized PDFs — each named after its recipient — in roughly 6 minutes on a laptop, bundled into one 38 MB ZIP. A certificate platform would charge $30–$100/month plus per-credential fees for the same job. Cost here: $0, and no student names ever leave the organizer’s machine.
Limitations
One template per merge — different designs need separate runs. Fields are text-only; images and drawn signatures are not placeable yet. Very long names can overflow fixed field widths, so test with your longest name first. The CSV must be UTF-8 — Excel sometimes exports other encodings, in which case re-save as “CSV UTF-8” before uploading.
Frequently asked questions
How is this different from Certifier.io or Accredible?
What CSV format do I need?
Can I use fields other than the name?
Which page of the template gets stamped?
Are my recipients' names uploaded anywhere?
What CSV format do I need?
Can I use different templates for different recipients?
Related Tools
Email Button Generator
Build bulletproof email CTA buttons free — VML fallback for Outlook plus styled anchor, live preview, custom colors…
WhatsApp Chat to PDF — Free Chat Book Maker
Turn a WhatsApp chat export (.txt) into a beautiful printable chat book. Filter by date, align your own messages, then…
Voice Dictation — Free Speech-to-Text Online
Dictate live into text with free browser speech recognition. 8 languages, live results, copy or download notes. Works…
Email Newsletter Composer
Write Markdown, get email-client-safe HTML — table-based layouts with inline CSS for Outlook and Gmail. 3 templates…
Script Beat Planner
Plan retention-proof video scripts free — enter topic and length, get a timed beat-sheet with per-section word budgets…
Mojibake Fixer
Paste garbled text (Café, broken CSV exports) and get readable text back — auto-detects the wrong encoding, tries…