CertRoll desk guide

How to Export Certificates to CSV (Bulk Download Guide)

If you run workshops, courses, or training desks, names already live in a spreadsheet. This walk-through turns that CSV into certificate PDFs on your device — no account, no roster upload.

Certificates produced this way are completion or participation records you design. They are not academic credentials, degrees, or regulated licenses unless your own organization and jurisdiction say otherwise.

Why CSV works for bulk certificates

CSV is simple, portable, and works in Excel, Google Sheets, LibreOffice, Numbers, and most LMS exports. One row equals one certificate. You can sort, filter, and dedupe before printing. You reuse the same plate for every cohort. You keep the source of truth in a file you own.

Tools that ask you to create an account, store your roster in the cloud, or charge per seat add friction. CertRoll is different: buy once, keep the file. No account. PDFs stay on your device. One payment of $10 unlocks unmarked files and a ZIP of up to 100 names.

What a certificate CSV should contain

Start with the fields CertRoll actually prints. Extra columns can stay in your sheet for records; the press ignores them.

Column	Required	Purpose
name	Yes	Name on the plate. Use the spelling people expect on formal docs. Blank rows fail the file.
course	No	Program or event line. Empty cells use the studio field. Keep length consistent so the layout stays clean.
date	No	Date on the certificate. Prefer ISO YYYY-MM-DD. Empty cells use the studio date.

Headers are case-insensitive. Certificate IDs, organization names, instructor lines, and hours can live in your master sheet — they do not map into this press.

Column naming tips

1. Use stable headers. Prefer name over a display label that changes every export.
2. One person per row. Do not put two names in one cell.
3. Avoid merged cells. CSV exporters usually break on merges.
4. Keep dates as dates or ISO text. Mixed formats cause wrong sorting and wrong prints.
5. Strip titles unless you want them printed. Decide whether “Dr.” belongs in name.
6. Export UTF-8 so accents and non-Latin names survive.

Example CSV

name,course,date
Alex Rivera,Intro to Data Literacy,2026-09-01
Sam Chen,Intro to Data Literacy,2026-09-01
Jordan Lee,Intro to Data Literacy,2026-09-01

How to export from common sources

Google Sheets

1. Put headers in row 1 and data below.
2. File → Download → Comma Separated Values (.csv).
3. Open the file in a text editor once to confirm encoding and commas look right.
4. If names contain commas, Sheets will quote those fields — that is normal and correct.

Excel

1. Save a working copy as .xlsx for edits.
2. File → Save As → CSV UTF-8 (Comma delimited).
3. Avoid Macintosh or locale variants unless you know the generator expects them.
4. Re-open the CSV only to verify. Edit in .xlsx when possible.

LMS or event platform

1. Filter to the cohort you want — completed status only.
2. Export CSV or Excel.
3. Rename columns to name, course, and date.
4. Drop columns you will never print unless you need them for your own audit file.

Keep PII lean. For certificate PDFs you usually need a name and a title — not a full CRM dump.

Clean the CSV before bulk generation

Spend ten minutes cleaning. It saves hours of reprinting.

• Duplicates: same person enrolled twice? Keep one row.
• Blank names: delete or fix empty name rows.
• Trailing spaces: trim them.
• Line breaks inside cells: replace with spaces.
• Inconsistent course titles: normalize to one string per program.

In a spreadsheet, add helper columns temporarily — name length greater than zero, date parses — filter to failures, fix, then delete the helpers and re-export.

Turn the CSV into certificate PDFs

A CSV alone is not a certificate. You still need a layout. Mail merge works but gets fiddly at scale. Design tools plus paste are fine for five certificates, painful for fifty. A dedicated press maps the roster once and prints many PDFs.

Open the CertRoll studio. Pick a plate — completion, participation, workshop, training, achievement, or your own artwork after unlock. Fill the first recipient; empty CSV cells reuse those values. Drop the file on Name list. Preview one PDF free. The diagonal mark stays until you unlock. Then export a ZIP of unmarked certificates. Logo and custom artwork unlock with the same key.

1. Prepare UTF-8 CSV with a name header.
2. Choose a plate and adjust the studio fields.
3. Drop the CSV. Preview a few rows, including a long name.
4. Unlock once. Generate the PDF set and save it locally.
5. Archive the CSV and PDF folder together for your records.

That archive is your operational memory: who received which certificate and when.

Layout and wording

Good completion certificates are clear and modest:

• State what was completed.
• Show the date and issuing organization on the plate you chose.
• Avoid language that implies accreditation you do not have.
• If you verify completions internally, keep that process on your side — do not imply a public registry unless you run one.

These PDFs are not academic credentials unless your institution and rules say they are.

Common mistakes

1. Exporting the wrong filter — all registrants instead of completers.
2. Using display names with emojis or nicknames. Decide a formal name policy first.
3. Changing headers mid-cohort.
4. Generating before QA. Always preview three rows, including long names.
5. Losing the source CSV. Store CSV and PDFs together.
6. Assuming the PDF is a legal license. It is a document you designed.

Privacy and storage

Names, courses, dates, logos, and CSV files stay in this browser. We do not store the roster. Keep CSVs where you already keep training records. Limit who can edit the master sheet. If you email PDFs, send individually when privacy matters; avoid attaching a full class zip to a shared thread.

Femuo’s stance is the same across products: practical files, no account theater, PDFs on your device. The catalog lives at femuo.com.

When this workflow fits

Use it when you issue the same layout repeatedly, names already live in a spreadsheet, and you want a one-time tool cost — not per-certificate SaaS. Look elsewhere if you need LMS-integrated digital badges, government-regulated credentialing, or a live verification network.

Roster already in Google Sheets? See bulk workshop certificates from Google Sheets for a Sheets-first filter-and-export walk-through.

Buy once. Keep the file. For bulk certificate CSV workflows, that is usually enough.

CertRoll helps you turn spreadsheet rows into certificate PDFs. It does not issue academic credentials or regulated licenses.