4 min read
How to send certificates to a whole group at once
Making certificates one by one takes hours. Here is how to issue them all from one spreadsheet.
If you run a course, a workshop or an event, you probably know the routine: open the certificate file, type a name, save it as a PDF, attach it to an email, and repeat for every person. With 20 people that is an afternoon. With 200 it is a week, and somebody's name will be spelled wrong.
Issuing in bulk means you prepare one list and the certificates are made for everyone at once.
1. Put your list in a spreadsheet
Use one row per person and one column per detail. At a minimum you need two columns: the person's full name and their email address. Give each column a clear heading in the first row, such as "Name" and "Email".
2. Clean the list before you issue
- Names: check capital letters and spelling. The name on the certificate is exactly what is in the cell.
- Emails: look for typing mistakes and empty cells.
- Duplicates: remove anyone who appears twice, so nobody gets two certificates.
- Extra rows: delete totals, notes or blank rows at the bottom.
3. Save it as a CSV file
Most certificate tools read CSV files, a simple format every spreadsheet can save. In Excel, choose File, then Save As, and pick CSV. In Google Sheets, choose File, then Download, then Comma separated values.
4. Upload and match the columns
Upload the file and tell the tool which column holds the name and which holds the email address. A good tool checks the whole file first and tells you about problems, such as a missing email or the same person twice, before it issues anything.
5. Issue, then check a few
Issue the certificates, then open three or four of them at random and read them as the recipient would. If something is wrong, it is better to find it now.
Doing this in Certivate
Go to Issue Credentials, choose the credential, upload your CSV and match the name and email columns. Certivate checks every row first and issues nothing until the whole file is right, so you never end up with half a group done. For one or two people, use the Add manually tab instead. Your first 250 certificates are free.
Make your first certificate today
Design, issue and share certificates in minutes. Your first 250 certificates free.
Start free