· 10 min read · By Jason Dorn

Print 1,847 Graduation Diplomas From a CSV in 30 Minutes (Without an Outsourced Vendor)

How registrars, course creators, and K-12 teachers print graduation certificates from a spreadsheet in 2026. Cost: ~$0.10 per diploma. Lead time: 30 minutes.

May 2026. A college registrar in Maryland has 1,847 graduating seniors, twelve degrees across four schools, and a stack of pre-printed diploma cardstock that arrived from a vendor 3 weeks late. The vendor's price was $4.85 per diploma. The registrar's office spent forty staff hours over the previous two weeks personalizing each one in Word.

This is roughly how 90% of US institutions handle graduation diplomas in 2026. It's also completely unnecessary. A spreadsheet plus an AI tool can generate every personalized diploma in the cohort — 1,847 of them — in roughly 30 minutes. Total cost: about $99/month, vs. the $9,000 the vendor charged.

This post is a practical walkthrough of how registrars, course creators, and K-12 teachers are actually doing graduation certificate runs in 2026 — including the specific column structure of the CSV you'd upload, the design conventions to follow, and the trade-offs vs. outsourced certificate vendors.

Key Takeaways

  • One CSV column per personalization field (name, degree, major, honors, date) — drop in your registrar export
  • Design the master diploma once with your institution's branding, save as template, re-use forever
  • 500 diplomas process in ~8 minutes, 5,000 in ~80 minutes — well within the EZdoc Scale plan ($99/mo)
  • Optional: add an _email_to column to auto-deliver each personalized PDF to the graduate's inbox

The Three Ways Institutions Print Graduation Diplomas Today

Before walking through the CSV-driven workflow, it's worth understanding what most institutions are doing now and why each approach falls short:

1. Outsourced certificate vendors (Herff Jones, Jostens, regional certificate companies). The traditional path. Quality is reliably high. Cost runs $3-8 per diploma plus per-student personalization fees. Lead time is 2-3 weeks before graduation. The trade-off you're paying for is that the vendor handles everything — pre-printing on premium cotton stock, personalization, sometimes even mailing. The downside: the design is locked to the vendor's templates. Want a unique conferral language for your institution's bicentennial graduation? You'll pay extra and wait longer.

2. In-house Word-document workflow. A registrar staffer opens a master Word doc, types each graduate's name, copies the next row from the senior export, prints, repeats. Cheaper than vendor pricing — the marginal cost is just paper + toner — but it's labor-intensive and error-prone at scale. A class of 500 typically eats 20-30 hours of staff time. A class of 5,000 is just untenable this way.

3. Pre-printed certificate stock + mail merge. A middle path. The institution orders blank certificate cardstock from a vendor (cheaper than fully personalized diplomas), then uses Word's mail merge to populate the variable fields. Faster than fully manual, but mail merge breaks badly when:

  • A graduate has Latin honors with italics
  • A long major name needs to wrap to two lines
  • Multiple degree types (BS, BA, MS, MBA) need different formatting
  • The institution wants per-graduate signatures or verification URLs

The CSV-to-AI workflow described below sits in the same conceptual space as option 3 but produces dramatically better-looking output and handles the edge cases automatically.

The Workflow, Step by Step

Step 1: Export the Graduating Class From Your SIS

Whatever student information system your institution runs — Banner, PeopleSoft, Workday, Jenzabar, Ellucian Colleague, Anthology — they all export graduating class lists as CSV. The columns vary by SIS but the standard set looks like:

Column Required? Example
recipient_name Yes Maria Rodriguez
degree Yes Bachelor of Science
major Yes Mechanical Engineering
concentration Optional Aerospace Systems
honors Optional Magna Cum Laude
graduation_date Yes May 22, 2026
diploma_id Optional Internal verification ID
_email_to Optional [email protected]

The most-asked question from registrars: "How do we handle multiple degree types in one cohort?" Answer: just include the degree column. One CSV with all 1,800 graduates — including the 1,200 BS, 400 MS, 150 MBA, and 50 PhD recipients — works from a single template. The degree column tells the AI how to render each row.

Step 2: Design the Master Diploma Once

Open the AI Builder (ezdoc.app/ai-builder). Describe your institution's diploma standard:

"University of Maryland graduation diploma. Conferral language: 'The Trustees of the University of Maryland confer upon'. Recipient name large in formal italic serif. Degree on second line, major on third. Latin honors in italic where applicable. Three signatures: President (Darryll Pines), Dean (varies by school — leave a placeholder), and Provost (Jennifer King Rice). School colors: red (#E03A3E) and gold (#FFD520). Use the school seal at top center. Motto 'Fearlessly Forward' in small italic at the bottom."

The AI returns a print-ready PDF in 30 seconds. If the design isn't quite right, iterate via follow-up prompts:

  • "Make the border more conservative — closer to a thin gold line than an ornamental motif"
  • "Use Trajan Pro or similar Roman serif for the institution name"
  • "The recipient name needs to be 1.5x larger relative to the conferral language"
  • "Add a small watermark of the seal behind the conferral language at low opacity"

When you like the design, save it as a template. That saved template is what you'll use for every future cohort — for every spring graduation, every winter graduation, every summer cohort, year after year.

Step 3: Bulk-Generate the Cohort

From the saved template, click "Bulk generate" and upload your CSV. Map columns to certificate fields once (recipient_name → recipient field, major → major field, etc.). The mapping is reusable for every future CSV with the same column structure.

Click generate. Output:

  • 100 graduates: ~90 seconds
  • 500 graduates: ~8 minutes
  • 1,000 graduates: ~16 minutes
  • 5,000 graduates: ~80 minutes
  • 10,000 graduates: ~160 minutes (split across two batches recommended)

The output is a ZIP file with one PDF per graduate, named after the recipient. You can download it or — for institutions that have moved to digital-first delivery — auto-email each PDF to the graduate's inbox by including the _email_to column in your CSV.

Step 4: Print or Deliver

For paper diplomas, two paths:

  • In-house printing on cardstock. Buy 100lb cotton certificate paper from an office store (around $30 for a 100-sheet pack at scale). Run through your office laser printer. For 1,000 diplomas, the printing alone takes about 4 hours of supervised printer time. Total cost: ~$0.30/diploma in materials.
  • Local commercial printer. Send the ZIP to a local printer or send 1,000 PDFs to a commercial print shop. Most charge $0.50-1.50/diploma at this volume, with same-week turnaround. Total cost: ~$1/diploma in printing.

For institutions that have moved to digital diplomas (or want a digital backup), the auto-email flow handles delivery. Each graduate receives their personalized PDF by email immediately after the batch completes.

The Specific Use Case: Multi-Degree Cohorts

Universities issuing multiple degree types in a single graduation often think they need separate templates per degree. They don't. The CSV's degree column tells the AI how to render each row from a single master template:

recipient_name,degree,major,honors,graduation_date
Marcus Chen,Bachelor of Science,Computer Science,Magna Cum Laude,May 22 2026
Eleanor Whitfield,Bachelor of Arts,English Literature,Phi Beta Kappa,May 22 2026
Robert Sanchez,Master of Business Administration,Finance,Beta Gamma Sigma,May 22 2026
Priya Subramanian,Master of Science,Data Science,,May 22 2026
Kenji Watanabe,Doctor of Philosophy,Economics,,May 22 2026

The AI handles each row — adapting to BS vs. BA vs. MS vs. MBA vs. PhD conventions automatically. Latin honors render in italic. Society memberships (Phi Beta Kappa, Beta Gamma Sigma) format as a separate italic line. Empty honors fields render cleanly without leaving awkward blank space. PhD rows might omit the Latin honors line entirely, since it's less common at the doctoral level.

For institutions with truly distinct diploma designs per degree level — say, a separate physical format for the doctoral diploma (often larger 11×14 stock instead of letter) — two or three templates handle every degree level. Many fewer than per-major templates.

Compliance, FERPA, and Student Data

A real concern for any registrar: graduation lists contain student PII, and FERPA limits how that data can be shared with third parties. EZdoc's data handling for this use case:

  • Your registrar export is uploaded to your private workspace. Nothing is shared, sold, or used for training.
  • Files automatically purge based on your retention setting (1-168 hours configurable).
  • For institutions with stricter requirements, the Scale plan supports SFTP delivery — your CSV uploads via encrypted SFTP, generated certificates come back via the same channel.

For institutions whose IT or general counsel needs a written data-handling commitment, reach out via the /for-colleges contact form. We're a small team and can produce a custom DPA quickly.

Pricing for an Institutional Workflow

Most institutions land on the Scale plan ($99/month, 20,000 pages). For a 5,000-graduate institution running graduation once a year, that's effectively $0.10 per diploma in EZdoc costs — vs. $3-8 per diploma from outsourced vendors.

Larger institutions (10,000+ graduates) can either run two months of Scale ($198) to spread the page count or contact us about higher-volume pricing. Most US universities with graduating classes in this range are using one Scale plan that covers graduation, plus other institutional document generation through the year — internship completion certificates, awards from the dean's office, alumni-relations recognition, training certificates from compliance offices.

What This Doesn't Replace

Three things to be clear about:

  1. Officially conferred credentials. Only your institution's registrar can confer a degree — the legally certified credential lives in your SIS, with your institutional record-keeping. EZdoc produces the print-ready PDF that visually represents that credential.
  2. The graduation ceremony itself. Graduates still walk across the stage, shake the dean's hand, and feel the moment. The diploma is the artifact of that moment, but the moment is still ceremonial.
  3. Vendor-handled mailing. Some institutions outsource because they want vendors to handle the mailing logistics. EZdoc generates the PDFs; your institution still handles physical printing and distribution. For institutions wanting a vendor-style mailing service, traditional vendors remain the right choice.

Other Ceremony Use Cases

This same workflow applies to:

The CSV column structure changes per use case but the workflow is identical: design once, save the template, swap the CSV per cohort.

Try It

If you're a registrar, dean, career services director, or faculty member at a college or university looking at this workflow for your next graduation: head to the /for-colleges hub for the full registrar workflow, or fill out the contact form there if you'd like a walk-through with our team. We're a small team and can usually get on a call within a few business days.

If you're a course creator, K-12 teacher, or anyone else who needs to print graduation certificates from a list of names, jump straight to the AI Certificate Maker. Free for the first three certificates. After that, $5 buys 4 credits, or paid plans (from $19/month) cover everything you need.

The forty-hour, two-week graduation diploma project is a 2010s problem. In 2026, it's a 30-minute job.

All posts Try EZdoc Free