Your Training Centre
Certificate
This is to certify that
Anna Green
attended the course “First aid”, lasting 20 hours, held on 15 October 2026.
The Director
Batch generation
Generate documents from Excel
Invoices, certificates, contracts or letters: design the template once, upload your spreadsheet and download one PDF per row. No Word, no copy and paste.
| Name | Course | Hours |
|---|---|---|
| Ana García | First aid | 20 |
| Luis Pérez | First aid | 20 |
| Marta Ruiz | Fire safety | 8 |
- certificate-ana-garcia.pdf
- certificate-luis-perez.pdf
- certificate-marta-ruiz.pdf
Try it with your own spreadsheet
Pick a sample template, use its spreadsheet or upload yours, and see the first documents it produces. No sign-up.
1. Choose a template
2. Use the sample spreadsheet or upload yours
Using the sample spreadsheet (4 rows).
Your file is read in your browser: it is not uploaded anywhere.
3. Check which column fills each field
Name
Course
Hours
Date
The first 2 documents of 4
Your Training Centre
Certificate
This is to certify that
Luke Parker
attended the course “First aid”, lasting 20 hours, held on 15 October 2026.
The Director
Your spreadsheet has 4 rows. With a Pro account you generate all of them at once, with your own template. Create a free account →
How it works
Design the template
Write the document once with variables where the data changes: name, amounts, dates. Add formulas, conditions and your letterhead.
Upload the spreadsheet
An Excel (.xlsx) or CSV file with one row per document. Columns are matched to the template variables by their titles; you can adjust them.
Download the PDFs
You get a ZIP with one PDF per row, each named after the column you choose, or a single PDF with all of them, plus a report of every row.
What you can generate
Invoices
One invoice per client or per order, with totals, VAT and the amount in words worked out by the template.
Certificates and diplomas
Attendance or completion certificates for a whole course from the list of attendees.
Contracts
The same contract for each client or employee, with their details and only the clauses that apply.
Letters and notices
Personalised letters, notices or reminders, ready to send as PDF.
Reports
One report per site, inspection or client from the results in your spreadsheet.
Quotes
Quotes with their lines and conditions, each one with its own number.
More than mail merge
Word’s mail merge works, but it was designed for printed letters. This is what changes when the goal is PDF documents.
| Feature | Word mail merge | Documentemplate |
|---|---|---|
| One PDF per row | Merges into one document; splitting it into PDFs needs a macro or an add-in | One PDF per row named after a column, or all in one |
| Calculations | Limited formula fields, set up by hand | Formulas in the template: totals, VAT, amount in words |
| Shared data (VAT rate, company details) | Repeated in each document or each file | Global constants: change them once and every template follows |
| Text that depends on the data | IF fields, written by hand | Sections and blocks that show only when a condition is met |
| From another program | No | REST API: send the spreadsheet, download the ZIP |
| What you need | Word installed | A browser |
What the spreadsheet needs
- An Excel (.xlsx) or CSV file of up to 10 MB. CSV separators (; , tab) and encoding are detected automatically.
- The first row holds the column titles; each following row is one document.
- A column for each piece of data in the template. Columns that match a variable by title are paired automatically.
- If a row is missing a required piece of data it is skipped and listed in the report, without stopping the rest.
Batch generation is part of the Pro plan (€5/month): up to 500 documents per batch. With the free plan you can design templates and generate documents one by one. Pricing
Want it to run on its own?
The same batch generation is available through the API: your system sends the spreadsheet and the template id, waits for the batch and downloads the ZIP. Useful for monthly invoices or anything that comes from your own software.
Read the API documentation →Your next hundred documents, in a minute
Create your free account, design the template and try it with your own data.
Frequently asked questions
Can I generate PDF documents from an Excel file?
Yes. Design a template with variables, upload an .xlsx or .csv file with one row per document and you get one PDF per row in a ZIP, or a single PDF with all of them.
Do I need Word or Excel installed?
No. Everything happens in the browser: you design the template in Documentemplate and upload the spreadsheet as a file. You can export it from Excel, LibreOffice or Google Sheets.
How many documents can I generate at once?
Up to 500 per batch on the Pro plan. If you need more, split the spreadsheet into several batches.
Can each PDF have its own file name?
Yes: choose the column that names each file (for example, the client’s name). If you don’t, the column that looks like a name is used, or the row number.
Can I do it from my own program?
Yes, with the REST API: send the spreadsheet and the template id and download the ZIP when the batch is ready. It is part of the Pro plan.