CertRoll desk guide

Bulk Workshop Certificates from Google Sheets (CSV → PDF Workflow)

Workshop names already live in Google Sheets — RSVPs, attendance, completers. This walk-through turns that sheet into a Google Sheets certificate generator: export CSV once, map columns, and print PDFs on your device.

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

Why Google Sheets works for workshop certificates

Trainers already track who registered, who showed up, and who finished. One row per attendee keeps names, workshop titles, and dates editable before anyone prints. You can sort, filter, and share the same tab with a co-facilitator without opening a design tool.

A sheet is not a certificate. The useful move is to treat Sheets as the roster, export a dated CSV, and let a dedicated press map those columns onto a plate. CertRoll is built for that: no account, no roster upload, PDFs stay on your computer. Buy once. Keep the file. One payment of $10 unlocks unmarked files and a ZIP of up to 100 names.

Reuse the same column map for every cohort. January’s intro workshop and June’s advanced session can share headers even when the course line changes. That is the whole point of a Sheets-to-certificate workflow: the roster stays familiar; only the snapshot you export changes.

Set up a certificate-ready sheet

Put headers in row 1. Freeze that row. One person per row. No merged cells — CSV exporters break on merges. Keep a master .gsheet for edits and treat each download as a snapshot, not the place you keep rewriting names.

CertRoll prints three roster fields. Extra columns can stay in the sheet for your own records; the press ignores them.

Sheet column	Maps to	Notes
name	Required	Spelling people expect on a formal document. Blank rows fail the file.
course	Optional	Workshop or program line. Empty cells use the studio field.
date	Optional	Prefer ISO YYYY-MM-DD. Empty cells use the studio date.

Optional operational columns — status, email, hours, certificate_id, organization — help you filter and archive. They do not print unless you later move that text into course or the studio issuer line.

Hygiene before anyone exports

1. Use stable headers. Changing name to “Full legal name” mid-season breaks the next import.
2. Prefer UTF-8-safe names. Trim spaces and nicknames. Decide whether titles such as “Dr.” belong in the cell.
3. Keep dates as dates or ISO text. Mixed “Sept 3 / 3-9-26 / 2026-09-03” sorts badly and prints inconsistently.
4. Spot-check long names and accented characters so the plate does not clip.

Example sheet rows

name,course,date,status
Alex Rivera,Intro to Facilitation,2026-09-12,completed
Sam Chen,Intro to Facilitation,2026-09-12,completed
Jordan Lee,Intro to Facilitation,2026-09-12,registered

Filter completers before you export

The most common Sheets mistake is printing every registrant. Separate “registered” from “completed” with a status column or a filtered view. Export only the rows that earned a certificate.

Deduplicate people who attended two sessions of the same workshop but should receive one certificate. If someone completed two different programs, keep two rows with two course lines. That is a different person-event pair, not a duplicate.

A filtered view is enough: Data → Create a filter, show completed only, then download. If several people edit the tab, copy the filtered rows to a clean “export” sheet so a stray sort does not change who is in the file.

Export Google Sheets to CSV cleanly

1. File → Download → Comma Separated Values (.csv).
2. Open the file in a text editor once. Confirm commas and quoting look right — names with commas will be quoted, and that is correct.
3. Keep the master Sheet for edits. Name the CSV with the cohort and date, such as facilitation-2026-09-12.csv.
4. Archive that CSV with the PDF folder you generate next. The pair is your operational memory.

For column hygiene, encoding, and Excel or LMS variants, use the longer How to Export Certificates to CSV (Bulk Download Guide). This page stays on the Sheets-first path: filter, download, generate.

Map columns and generate PDFs with CertRoll

Open the CertRoll studio. Pick a plate — workshop, completion, participation, training, achievement, or your own artwork after unlock. Fill the first recipient so empty CSV cells have a fallback. Drop the file on Name list. Preview is free; the diagonal mark stays until you unlock.

1. Confirm the CSV header includes name. course and date are optional.
2. Preview at least three rows: a short name, a long name, and an accented name.
3. Unlock once if you need unmarked files. Generate the ZIP and save it locally.
4. Do not upload the roster anywhere else. Names never leave this browser.

That is the Google Sheets certificate generator loop: sheet as source of truth, CSV as the dated snapshot, PDFs as what people receive. No per-seat charge. No account theater.

Wording and layout for workshops — not credentials

Say what was completed. Do not borrow accreditation language you do not have.

• Clear: “Completed the 1-day Intro to Facilitation workshop.”
• Risky: “Certified facilitator” or “accredited diploma” unless you are authorized to issue that.
• Show the issuer name and date on the plate. Keep IDs modest if you only need them for your own log.

These PDFs are not academic credentials unless your institution and rules say they are. The footer on CertRoll plates says the same. Use the files for workshops, internal training, and events — not as a degree or a regulated license.

Common mistakes with Sheets → certificates

1. Exporting all registrants instead of completers only.
2. Changing header names mid-season so the next CSV no longer maps.
3. Leaving merged title rows above the header — download then starts on the wrong line.
4. Generating before a three-row preview, especially long names.
5. Emailing the PDF and losing the source Sheet or CSV.
6. Assuming the file is a legal license. It is a document you designed.

When this workflow fits

Use it when attendance already lives in Google Sheets, you issue the same layout each cohort, and you want a one-time tool cost. Look elsewhere for LMS digital badges, government-regulated credentialing, or a live public registry.

Full CSV prep and bulk-export detail: CSV columns and bulk export. Brand catalog: femuo.com.

Buy once. Keep the file. A Google Sheets roster is enough to start.

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