Generate Bulk Certificates from a Spreadsheet in Word
Generating 50 or 500 certificates by hand is a miserable and tedious task. You open your template, type a recipient's name, save the file, and repeat the process. This manual approach not only wastes hours of your day but practically guarantees mistakes. Leaving the previous person's name on the next person's file or mistyping a date are common errors when you are rushing to finish a batch.
You can finish this job in a few minutes using a single Word document and a spreadsheet of your attendees. This guide shows you how to set up your certificate template, format your spreadsheet data correctly, and generate the entire batch at once using a bulk document generator.
What belongs on a certificate and what varies
Before touching Microsoft Word, you must decide which parts of your certificate are fixed and which parts change for every recipient. Fixed elements are written into the document normally. Variable elements are replaced with placeholders.
A placeholder is simply a text marker wrapped in double brackets, like {{RecipientName}}. When you run the generation process, the software finds that placeholder and replaces it with the corresponding text from your spreadsheet. Everything else on the page remains untouched.
| Certificate element | Status | Example |
|---|---|---|
| Organization logo and border | Fixed | Graphic image |
| Signatory name and title | Fixed | Jane Doe, Director of Training |
| Recipient name | Varies per row | {{RecipientName}} |
| Course or award title | Varies per row | {{CourseTitle}} |
| Completion date | Varies per row | {{CompletionDate}} |
| Certificate number | Varies per row | {{CertificateNumber}} |
Building your template in Microsoft Word
Certificates almost always use a landscape orientation. To set this in Word, go to the Layout tab, click Orientation, and select Landscape. Set your margins wide enough to comfortably accommodate any border graphics, foil seals, or background images you plan to use in your final print.
The recipient's name is the most dangerous element on the page for your layout. A name might be short, like "Ian Wu", or it might be very long, like "Christopher Bartholomew-Smythe". If you place the {{RecipientName}} placeholder inside a running sentence—for example, "This certifies that {{RecipientName}} has completed the course"—a long name will push the rest of the sentence onto a new line. This completely ruins the symmetry and professional look of your design.
To prevent this, place the name in its own dedicated paragraph. Highlight the paragraph and center the text. Apply generous line spacing before and after the placeholder so the name sits comfortably in the middle of the page, regardless of its length. Choose a large, legible font that scales well for both long and short names.
You can use ((field)), {{field}}, or [[field]] for your placeholders. Pick one bracket style and use it consistently throughout the document. Type the brackets and the field name in one continuous sequence. If you stop mid-word to apply bold or italic formatting, Word might split the placeholder internally. While ManyDocs reassembles placeholders that Word has split across formatting runs, typing them cleanly in a single pass is the best habit to develop.
Preparing your spreadsheet
Your spreadsheet is the engine of this process. The first row of your spreadsheet must contain the column headers. These header names must match your template placeholders exactly.
If your Word document uses the placeholder {{RecipientName}}, the cell in row 1 of your spreadsheet must say exactly RecipientName. It cannot say "Name of Student" or "Recipient Name ". A single trailing space in the spreadsheet header will cause the match to fail, leaving the raw placeholder in your finished certificate.
| RecipientName | CourseTitle | CompletionDate | CertificateNumber |
|---|---|---|---|
| Alex Morgan | Advanced First Aid | 14 March 2026 | CERT-2026-001 |
| David Chen | Advanced First Aid | 14 March 2026 | CERT-2026-002 |
| Samira Ahmed | Basic CPR | 15 March 2026 | CERT-2026-003 |
Every row below the headers produces one finished document. Prepare your sheet with exactly one header row and nothing else above it. Do not merge cells. Do not leave blank rows at the top of the sheet. Do not add a stylized main title row above your column names. The system strictly expects row 1 to be the headers, and row 2 onwards to be the records.
Getting dates to print correctly
Dates cause more frustration in bulk document generation than any other data type. When you type "14 March 2026" into Excel, the software usually converts it into a hidden serial number and applies a display format to make it readable on your screen.
ManyDocs does not apply Excel's visual formatting; it reads the raw stored value. If you leave your dates as standard Excel date objects, your generated certificates might print raw five-digit numbers or American-formatted dates like "3/14/2026", completely ignoring how they look on your monitor.
The reliable fix is to store the date as plain text in the exact format you want printed. You have two ways to do this in your spreadsheet. The first method is to highlight the entire column in Excel, right-click, select Format Cells, and choose Text. Then, type your dates manually.
The second, faster method is to type a single apostrophe before the date in the cell, like this: '14 March 2026. The apostrophe tells Excel to treat the cell contents strictly as text. The apostrophe itself will not appear on your printed certificate, but it guarantees the date prints exactly as you typed it. Give this step real attention before generating your batch.
Certificate numbering
Many organizations require a unique, sequential number on every certificate for auditing and verification purposes. You can build these numbers quickly in your spreadsheet rather than typing them out manually.
To create a simple sequence, type your first two numbers, such as CERT-2026-001 and CERT-2026-002, into the first two data rows. Select both cells. Click and hold the small square fill handle in the bottom right corner of your selection, and drag it down the column. Excel will automatically increment the numbers for you.
If you prefer to use an Excel formula to generate these numbers—perhaps combining a course code with a row number—you must take one extra step. ManyDocs does not recalculate spreadsheet formulas. It simply reads the values as they are stored at the moment you save the file. Before generating your certificates, highlight your column of formula-generated numbers, copy it, right-click the top cell, and select "Paste as Values". This strips out the formula and leaves only the final text, ensuring the generator reads the sequence correctly.
Generating and checking your batch
Never generate a batch of 300 certificates without testing the process first. A minor layout error or a misspelled column header will ruin all 300 files, forcing you to delete the batch and start over.
Create a test spreadsheet containing just your header row and two rows of data. Ideally, use one row with a very short name and one with a very long name to test your paragraph spacing.
Go to ManyDocs in your browser. Select your Word template and your test spreadsheet. The tool processes everything locally on your own device using JavaScript. There is no server upload, so the generation takes only seconds.
ManyDocs lets you choose how to name your output files. By default, it numbers them sequentially (document-1.docx, document-2.docx). For certificates, numbered files are nearly useless when you need to find one specific person. Instead, choose a spreadsheet column for the file names, such as your RecipientName or CertificateNumber column. This makes the resulting ZIP file immediately searchable.
Warning: Ensure the column you choose for file naming contains no duplicate values. If two rows have the exact same name, the second file will overwrite the first in the ZIP archive. Additionally, ensure the column contains no characters that are illegal in file names, such as slashes, colons, or question marks.
Download the ZIP, extract it, and open both test files in Word. Check the alignment of the long name to ensure it did not push the text down the page. Verify the date formatting. Once you confirm the layout holds up perfectly, switch to your full spreadsheet and generate the complete batch.
Distributing the finished certificates
ManyDocs delivers all your generated documents together in a single ZIP download. The output format is always DOCX, or ODT if you started with an OpenDocument template. The tool does not export directly to PDF, and it does not send emails. It simply builds and provides the finished files.
For certificates, you almost certainly need to distribute PDFs. Sending a DOCX file allows the recipient to alter their name, grade, or the course details, which invalidates the certificate.
To lock the documents, you must convert the generated files to PDF yourself. If you only have a few dozen certificates, you can open each DOCX in Word and use Save As > PDF. If you have hundreds, you need a bulk approach. You can use a dedicated batch PDF converter tool on your computer. Alternatively, if you have LibreOffice installed, you can use its command-line interface to convert an entire folder of DOCX files to PDF in one swift command.
Once the files are converted to PDF, they are secure and ready to be attached to individual emails, uploaded to a learning management system, or sent to a commercial printer.
Frequently asked questions
Does a mail merge upload my spreadsheet anywhere?
No. When you use ManyDocs, parsing the spreadsheet, replacing the placeholders, and creating the ZIP file all happen locally in your web browser. Your files are never uploaded to any server, and your data never leaves your device.
Which placeholder styles are supported?
You can use ((field)), {{field}}, or [[field]] in your templates. All three styles are fully supported and function identically. Choose one style and use it consistently throughout your document to avoid making mistakes during the setup phase.
Why did my dates format incorrectly?
ManyDocs reads the raw value stored in your spreadsheet, not the display formatting applied by Excel. If your dates look wrong, format the spreadsheet column as plain text and type the date exactly as you want it to appear, such as "14 March 2026".
Can I email the certificates directly from the tool?
No. ManyDocs is a document generator, not an email client. It provides a ZIP file containing your finished documents. You will need to use your own email software or a dedicated mail merge email tool to send the generated files to your recipients.
Can the tool output PDF files?
ManyDocs generates DOCX or ODT files, depending on your template format. It does not export directly to PDF. To get PDFs, you must convert the generated Word documents yourself using Microsoft Word, LibreOffice, or a bulk PDF converter on your computer.