LEARNTEC 2027Meet Virtualbadge.io in Karlsruhe in February 2027.Book a meeting at our stand
How-to guide

Send certificates to a whole cohort from a CSV list

You upload a course's list of participants as a CSV file and send all certificates in one go. Afterwards you see how many emails were delivered and opened. This guide shows every step in Virtualbadge.io.

15 minFor issuersUpdated November 2026
At a glanceGuide
in 5 steps
Time
about 15 minutes
For
Issuers
Where
Open the template Recipients Add recipients Add list
Plan
See pricing page
What you need
  • An active template
  • List of participants as a CSV file with name and email address, saved as UTF-8
  • No more than 1,000 people per file

No account yet? Start a free trial. It runs for seven days.

For a course with many participants, the list is the fastest way. The example shows the certificate of attendance for an online seminar at Akademie Nord.

Example: certificate of attendance for an online seminar.

Step 1: Prepare the list

The list needs one column for the name, one for the email address and one column for each dynamic field in your template. The safest way is the sample from the upload dialog: it contains exactly the columns this template needs.

Save the file as CSV in UTF-8 so special characters arrive correctly. A file may hold up to 1,000 people and be no larger than 20 MB.

Structure of the list (example). The sample for your template gives you the exact column headings.
NameEmail addressCourse date (your own field)
Lena Hoffmannlena.hoffmann@example.org2026-11-12
Murat Yılmazmurat.yilmaz@example.org2026-11-12
Jonas Beckerjonas.becker@example.org2026-11-12
Tip

If the sample opens in Numbers on an Apple device, clear the option for table names when saving. Otherwise the upload may fail.

Step 2: Open the upload

Open the template and go to “Recipients”. Click “Add recipients” and choose “Add list”.

The “Add recipients” menu offers three ways: single, as a list or via API.

Step 3: Upload the CSV file

Drag the file onto “Drop a CSV file here” or pick it with “choose a file”. “Download sample” gives you the sample file. If your file is not UTF-8, the linked “UTF-8 converter” helps.

With “Continue”, Virtualbadge.io checks the file. If it contains issue or expiration dates, every value in a column must use the same format. You see faulty rows before the upload is completed.

The upload dialog for the CSV file.

Step 4: Check the list and send the emails

After the upload, everyone is in the list of recipients. With an active template, nothing is sent at this point.

Check a few rows, then click the button at the top right that shows the number of pending emails, “Send 6 emails” in the example. Only people who have not received an email get one.

List of recipients after the upload. The button sends all pending emails.

Step 5: Track delivery

“View statistics” in the template's overview shows how many emails were sent and opened and whether any addresses bounced. “Claimed” counts who has retrieved the credential.

The “More...” menu in the list of recipients lets you send retargeting emails: everyone who received their email but has not claimed the credential yet gets another one.

The dashboard shows the figures for all templates together.

Template statistics: claimed credentials and email delivery.

Follow this guide with your own data.

Check the result

  • The number of people in the list of recipients matches your file.
  • Special characters in the names are correct.
  • The statistics show sent and opened emails.

More on this: CSV to UTF-8 ConverterCertificate and Badge Management

Frequently asked questions

Can I add more people later?

Yes. Open the active template, add people one by one or as a list and send the emails. Only the newly added people receive an email.

Which date formats work in the CSV file?

DD/MM/YYYY, MM/DD/YYYY, DD.MM.YYYY, MM.DD.YYYY, YYYY-MM-DD and YYYY/MM/DD. Dates are switched off at first in the upload and can be switched on separately for issue and expiration dates.

An email did not arrive. What now?

You see bounced addresses in the list of recipients. If there is a typo, correct the entry or delete the person and add them again.

Does this work without a file?

Yes. You add single people by hand. For ongoing sign-ups, Zapier, Zoom or the REST API are a good fit, and for courses in Moodle the plugin for Moodle.

Where to go next

Try it with your own certificate

Upload your current certificate design, issue a test credential and follow the guides with real data. The trial runs for seven days.

More than 1,000 organizations issue with Virtualbadge.io, including telc, Vodafone, Dell, IDP, EBS Universität and Mannheim Business School.