Bulk certificate generator from CSV or Excel
Upload a spreadsheet, map its columns into a design, and download every certificate at once, as one PDF for the printer or a ZIP of named PDFs for email. The list is processed on your device and never uploaded.
1 Add your list
2 Design and map fields
Type {column} anywhere to merge a value from your list. Click a column to insert it.
No column called {name}, {hours}, {course}, {date} in your list. It will print as typed.
3 Check and download
Everything runs on your device; the list never leaves your browser. The design (not the list) is remembered here.
How the merge works
Every certificate in a batch shares one design. What changes is the text, and that comes from your spreadsheet: each row becomes one page, and each {column} placeholder is replaced by that row's value. Step through it on the right.
Preparing your spreadsheet
- Put column names in the first row:
name,course,date,hours,award, whatever you need. - One person per row. Remove blank rows and totals.
- Type names exactly as they should print (capitals, accents, titles such as "Dr.").
- Export from Google Sheets with File → Download → CSV, or upload the Excel file as is.
Tips for printing a batch
Print one page first to check alignment on your cardstock, then print the rest. Long names shrink automatically to fit the line, but check the longest name in the preview using the arrows.
- Read one row
- Find each {placeholder}
- Swap in that row's value
- Draw the page, then the next row
| name | course | hours |
|---|---|---|
| Amara Osei | First Aid | 8 |
| Ben Kowalski | First Aid | 8 |
| Chloé Dubois | Fire Warden | 4 |
has completed {hours} hours of {course} training.
This is the same "mail merge" idea word processors use for letters: one template, one row per recipient. Because it happens in your browser, 300 pages take seconds rather than an afternoon of copy and paste.
Questions people ask
How do I generate certificates from Excel?
Upload the .xlsx file directly (the first sheet is used) or save it as CSV. Make sure the first row holds column names such as name, course and date. Then type {name}, {course} and so on wherever those values should appear.
How many certificates can I make at once?
Up to 500 per run. Each page is rendered at 300 DPI on your own device, so very long lists are best split into batches of a few hundred to keep memory use comfortable, especially on phones.
Can I email each person their own certificate?
Choose "ZIP of separate PDFs": every file is named after the recipient, ready to attach. CertifyFast does not send email itself, so your list stays private.
What if my CSV uses semicolons?
Comma, semicolon and tab-separated files are all detected automatically, and quoted values with commas inside are handled.
Do accents and non-English names work?
Yes for Latin-script names, including accents (é, ñ, ø, ł). Save CSV files as UTF-8 so characters are preserved.
Is there a watermark or limit on the free version?
No. There is only one version, it is free, and it has no watermark.