Can Batch, Please connect to my Google Sheet directly?
No, and that is deliberate. There is no account, no Drive permission, and no live connection to break — you download a CSV and upload it, so nothing of yours stays connected to this tool.
Use cases
Google Sheets to certificates
From a shared sheet to finished certificates.
Attendance, sign-ups, and course rosters usually already live in a Google Sheet. Download that tab as a CSV, upload it, and place columns such as name, course, and completion date onto a certificate design. Every row becomes a certificate, without a script, an add-on, or granting access to your Drive.
Teams working in Google Workspace
Google Forms organizers
Community and club leads
What it solves
Replace manual personalization with a repeatable CSV flow.
- Add-ons that want full access to your Drive
- Apps Script solutions nobody on the team can maintain
- Form responses that need cleaning before they are presentable
Example CSV columns
Bring the fields you already track.
full_namecourse_namecompletion_dateinstructoremail
Each column can become a text field on your design. You decide where it appears, how it is styled, and how overflow is handled before export.
Starting point
Getting your list out of Excel or Google Sheets.
The upload accepts CSV files. Both Excel and Google Sheets save one in a couple of clicks — the details below are the parts that usually trip people up.
From Microsoft Excel
- Working in Excel instead? File → Save As → CSV UTF-8 (Comma delimited).
- See the Excel to certificate page for the Excel-specific details.
From Google Sheets
- Keep one header row at the top and one recipient per row below it.
- Delete trailing empty rows — Sheets can export them as blank rows.
- File → Download → Comma-separated values (.csv). Google Forms responses work the same way, via the linked response sheet.
Workflow
From spreadsheet to finished PDFs.
The same process works whether you start with a built-in design or upload your own PNG/JPG artwork.
- 1
Open the tab holding your roster — the download exports the active tab only.
- 2
File → Download → Comma-separated values (.csv).
- 3
Upload the CSV, pick a certificate design, and place your columns on it.
- 4
Preview real rows for text fit, then export the certificate PDFs.
Export options
Download the format that fits the job.
Certificate PDFs from a Sheets roster
Certificates from linked Google Forms responses
One combined PDF or separate files
Questions
Answers for this use case.
Which tab gets downloaded?
Only the tab you are viewing when you choose File → Download → CSV. If your roster is on a second tab, open that tab first.
What happens to my formulas?
They download as their results, not the formulas themselves. A column that joins first and last names, or looks up a course title, arrives as finished text ready to place on the certificate.
More use cases
Related CSV-to-PDF workflows
Excel to certificate PDFs
Excel to certificate
Turn an Excel spreadsheet into personalized certificate PDFs. Save the .xlsx as CSV, place your columns on a certificate design, and export the whole list.
Bulk certificate generator
Bulk certificate generator
Generate certificates in bulk from an Excel, Google Sheets, or CSV list. Up to 500 per batch as one combined PDF or separate files. Free, no account needed.
CSV certificate generator
Certificate generator from CSV
Create personalized certificates from a CSV spreadsheet and a certificate design. Upload rows, place fields, preview names, and export PDFs in bulk.