Bulk Credential Generation: How to Issue Hundreds of Credentials in Minutes

Issuing credentials one at a time is reasonable when you're handling a handful of recipients. It doesn't work when you're finishing a cohort of 200 people, running quarterly compliance renewals, or onboarding a new client with 500 existing certification records to migrate.

Bulk generation in CertLister handles volume issuance without compromising the quality of individual credentials. Each recipient still gets a properly named, branded, QR-coded PDF. You just don't have to produce them one at a time.

Here's how the full workflow looks, from importing your data to delivering credentials to recipients.

Step 1: Prepare Your CSV

The fastest path for bulk issuance starts with a spreadsheet. CertLister's CSV importer accepts any spreadsheet you can export from Excel, Google Sheets, or your existing training management system.

The required columns are minimal: First Name, Last Name, Email, and Credential Title. Optional columns include: Issue Date, Expiry Date, and any custom attributes you've configured for the category (course name, score, instructor, license number, etc.).

A few formatting notes:

• Dates should be in YYYY-MM-DD format (e.g., 2026-05-29) or standard date formats — the importer handles most variants
• Email addresses must be valid — invalid emails will be flagged in the validation step and won't import
• Each row becomes one credential record

You don't need to use every optional column. Start with the required fields; you can always add custom fields later.

Step 2: Import into a Category

In CertLister, credentials live inside categories. A category defines the credential template, the custom fields available, and the default settings (issue date logic, automation rules, badge design). Before importing, make sure you have a category set up for the credential type you're issuing.

To import:

1. Go to Categories and open the category you want to import into
2. Click Import Credentials
3. Upload your CSV file
4. On the column mapping screen, match your CSV columns to CertLister fields. If your header names match exactly, this happens automatically.
5. Review the validation summary — the importer flags any rows with missing required fields, malformed emails, or duplicate entries
6. Fix any flagged rows (you can download a report of the errors), then confirm the import

The import screen shows a preview of how the first few rows will be created before you commit. Take a moment to check that the column mapping looks right, particularly for dates and any custom fields.

Step 3: Generate PDFs in Bulk

Importing creates credential records, but it doesn't generate PDFs immediately. PDF generation is a separate step — this lets you review the imported records before committing to a full generation run.

To generate PDFs in bulk:

1. From the Credentials list, filter by category (and optionally by date range or status) to select the records you want to generate PDFs for
2. Use the Select All checkbox to select all matching records, or select manually
3. Open the Bulk Actions menu and choose Generate PDFs
4. The generation page walks you through a 3-step process: confirm the selection, choose the template (if the category has multiple designs), and start the job
5. A progress bar shows generation status in real time. For 200 credentials, this typically takes 1–3 minutes.

Once generation completes, each credential has a downloadable signed-URL PDF and a QR code that points to the public verification page.

Step 4: Send Credentials to Recipients

With PDFs generated, you have two options for delivery.

Option A: Batch email. Select your credentials, choose Bulk Actions → Send Email, and confirm. Each recipient gets an individual email with their credential attached (or a link to download it), using the email template you've configured under Settings → Email. The emails go out individually — each recipient sees only their own credential, not a group email.

Option B: Let recipients self-serve. If you have the recipient portal enabled, you can skip sending individual emails entirely. Recipients can log into the portal, see all credentials issued to their email address, and download their PDF directly. Some organizations prefer this approach for recurring issuances — recipients know to check the portal rather than waiting for an email.

Handling Large Volumes

For very large imports — 1,000+ records — a few practices keep things clean:

Import in batches if your data is messy. A CSV with 50 rows is much easier to validate and correct than one with 1,000. If your data comes from multiple sources or isn't well-cleaned, importing in smaller batches makes error handling more manageable.

Use the Google Sheets integration for ongoing programs. If you're issuing credentials for a recurring program — a weekly training course, a monthly cohort — connecting Google Sheets to a CertLister category means new rows in the sheet automatically create credential records. You add a row when someone completes the course; the credential is created and the issue email goes out automatically. This eliminates the import step entirely for ongoing operations.

Filter before generating. If you've imported a large batch but only want to generate PDFs for a subset (e.g., records with a specific issue date or status), use the filter and search tools on the Credentials list before selecting. Generating PDFs for records that aren't ready yet wastes time and can confuse recipients.

What Each Recipient Gets

At the end of the bulk workflow, each recipient in your import has:

• A credential record in CertLister with their name, credential title, issue date, expiry date, and any custom fields
• A generated PDF credential with your organization's branding, their details, a QR code, and a unique credential number
• A verification URL — a permanent public link to their credential that anyone can use to confirm authenticity
• (If enabled) access to the recipient portal, where they can download the PDF, get their badge file, and share to LinkedIn

The QR code on each PDF links directly to the public verify page for that credential. Recipients don't need to keep the PDF safe — anyone can verify from the QR code alone.

Bulk generation is designed to make the high-volume case as fast as the low-volume one. The import step takes 5 minutes, PDF generation takes 1–3 minutes per hundred records, and delivery is a single bulk send. What previously took an afternoon now takes less time than a coffee break.