Filling in a certificate one name at a time is fine for five people and painful for fifty. Doing it in bulk depends less on the design tool than on the spreadsheet that feeds it: most bulk-certificate problems, such as misspelt names, cut-off text and files that overwrite each other, start in the data. This guide covers how to prepare your list and how to produce the certificates with the free bulk certificate generator.
Step 1: Clean up your list
Use one row per certificate and a header row with short, simple names such as Name, Course and Date. Then fix the data before you generate anything, because fixing a typo afterwards means exporting again.
- Names. Decide on one style. In Excel,
=TRIM()removes stray spaces and=PROPER()capitalises each word, but check the result by eye: PROPER turns "McDonald" into "Mcdonald" and "de Silva" into "De Silva". - Dates. Format them as text exactly as you want them printed, for example "14 September 2026".
- Duplicates. If two people share a name, add an ID column. When you name the output files from a column, identical names can overwrite each other inside the ZIP, so use a value that is unique to each person.
Step 2: Save the list as CSV
The studio reads CSV files, not .xlsx. In Excel choose File > Save As > CSV UTF-8 (Comma delimited). In Google Sheets choose File > Download > Comma-separated values. UTF-8 matters if any names have accents or non-English characters.
Step 3: Prepare the template
Upload a PNG, JPG or PDF (the first page of a PDF is used). Give the design a clear, empty area for each field, particularly the name, because names vary in length. Centre-align the name field so short and long names both look balanced. The studio offers seven fonts: Inter, Outfit, Montserrat, Playfair Display, Pacifico, Times New Roman and Georgia. A larger template image gives sharper output when printed.
Step 4: Test before the full run
In the export panel you choose the start and end row. Export a handful first, including the row with your longest name, and open the files. It is much cheaper to adjust the font size now than after 300 certificates.
Step 5: Export and check
Choose PDF for printing (original template size or A4, one bundled PDF or one per person), or PNG or JPG for sending on screen. Pick 2x or 3x resolution for print. Before you send anything out, open the first file, the last file and a few in the middle.
What the tool does not do
It creates the certificate files; it does not email them. If each person needs their own file by email, name the files from a column so they are easy to match, and use a separate mail-merge or email tool to send them. For a handful of certificates, a normal design tool may also be quicker than setting up a batch.
Ready to try it? Open the bulk certificate generator. It is free, has no watermark, and your files are processed in your browser.