How to make certificates from a CSV file
A CSV with a header row and one person per line can be uploaded directly. sheetcerts reads quotes and commas, maps columns, and downloads a certificate ZIP. Save the CSV as UTF-8 so accented names survive.
CSV details that matter
Fields that contain commas should be wrapped in double quotes. A quote inside a field is written as two quotes. A leading BOM is ignored. CRLF and LF line endings both work.
Headers
Duplicate headers get a numeric suffix so every column stays addressable. Blank headers become Column 1, Column 2, and so on.
Starting list
You can download the current list as CSV, including accented names, and replace the rows with your own.
Steps
- 1.Export UTF-8 CSV. From Excel, choose CSV UTF-8 when you are offered an encoding. From Google Sheets, the CSV download is the usual path.
- 2.Open the tool and drop the file. You should see the row count and a preview list. The first six names are shown. The rest still generate, up to the plan limit.
- 3.Map and edit. Confirm the name column. Edit template text if the default sentence is wrong.
- 4.Download. PDF, PNG, or JPG. PNG and JPG ask for screen or print size. JPG also asks for quality.
Free covers 10 certificates per batch, with a small sheetcerts mark. Batch pass is $5 once for up to 200, without the mark. Pro is $19 a month or $190 a year, up to 500 a month, with saved templates. Team is $39 a month or $390 a year, up to 3,000 a month, with a public check page.
Open the editor and bring your spreadsheet.
Questions
Can I use a semicolon-separated file?
No. The parser expects commas. Export with comma separators, or save as Excel.
How are empty cells treated?
They become empty strings. An empty cell prints as a blank, so rewrite the sentence if that would leave a hole.
Does the CSV leave my device?
No. It stays on your device. Closing the tab clears the current batch.