PDF Mail Merge: Generate One PDF per Row from Excel, CSV, or Google Sheets

What is PDF mail merge?

PDF mail merge is the workflow of combining one reusable PDF form or layout with spreadsheet rows, then generating one completed PDF for each row.

In Doqlo, this workflow is called Bulk Fill. Bulk Fill keeps the product language precise while still matching the familiar mail merge idea: one template, many rows, one output document per row.

Traditional mail merge usually means a document template plus spreadsheet data. A name, address, invoice number, certificate recipient, or other variable value is pulled from each row and placed into the same structure. PDF mail merge applies that pattern to PDF forms and stable PDF layouts.

The data may start in Excel, Google Sheets, Airtable, an exported report, or an internal system. Doqlo uses CSV as the import format because CSV is portable, simple, and predictable across those tools. Prepare the data wherever your team already works, then export it as CSV before uploading it to Bulk Fill.

The usual result is a batch of completed PDFs: one PDF for row 1, one PDF for row 2, one PDF for row 3, and so on. The layout stays the same. The values change.

When should you use PDF mail merge?

Use PDF mail merge when the same document structure needs to be completed many times from structured data. It is a good fit when manual copying and pasting is slow, error-prone, or hard to repeat.

Common examples include:

• HR and onboarding packets that use the same employer forms for each person
• Certificates where each recipient has a name, date, course, or credential
• Notices and letters with stable wording and row-specific details
• Invoices, packing slips, or operational forms with a consistent layout
• Compliance or employer forms where each output follows the same structure
• Education and training documents produced from roster data
• Internal business forms that repeat across locations, employees, vendors, or customers

The key test is simple: if every output should follow the same PDF structure and the changing values already exist in rows and columns, a PDF mail merge workflow can usually save time.

Excel vs CSV vs Google Sheets

Excel, Google Sheets, Airtable, and similar tools are places where teams prepare and review tabular data. CSV is the file format Doqlo imports.

That distinction matters. Doqlo does not need your team to change where the data is maintained. You can keep preparing rows in the spreadsheet or system you already use, clean up the columns there, and then export the final data as CSV for Bulk Fill.

CSV works well for this job because it is a plain tabular format. It is easy to inspect, easy to export, and widely supported by spreadsheet tools and internal systems. It also avoids tying the import workflow to one vendor-specific spreadsheet format.

Before uploading the CSV, check that each row represents one output PDF and each column represents one value you may want to place into the PDF. Use clear column names when possible, remove rows you do not want to export, and make sure values such as dates, IDs, and amounts are formatted the way you want them to appear.

How Doqlo works with existing PDF forms

Doqlo Bulk Fill starts with the PDF you already have. That PDF can be an existing fillable PDF form or another stable PDF layout, as long as the layout does not need to change from row to row.

A basic Bulk Fill setup looks like this:

1. Upload the PDF.
2. Upload the CSV.
3. Decide whether the PDF should use native PDF form fields, overlay Fields, or a combination of both.
4. Map CSV columns to the places where values should appear.
5. Preview representative rows.
6. Export a test PDF.
7. Export the full batch when the output looks right.

For repeated work, you can reuse the validated setup instead of starting from scratch. A .doqlo project file can preserve the Bulk Fill mapping setup for later use with the same kind of PDF workflow. If another system needs to run an already prepared workflow, the Public API can be used where it fits the current Bulk Fill API contract and plan limits.

Native PDF form fields vs overlay fields

There are two main ways values can land on a PDF in Doqlo.

If the PDF already has supported native AcroForm fields, native fill is usually the cleanest path. The PDF provides the field structure, and Bulk Fill maps CSV columns into supported existing fields such as text fields, checkboxes, single-select dropdowns, and radio groups on supported non-XFA PDFs.

If the PDF is flat or does not provide the fields you need, overlay Fields can place text visually on top of the stable PDF layout. This is useful when the PDF looks right but does not contain usable native form fields, or when you need a value in a place the original form did not provide.

Doqlo supports both workflows because real PDFs are not all built the same way. Some forms have useful native fields. Some are flat layouts. Some need native fields for the main form data and overlays for extra labels, codes, or row-specific text.

This does not mean Doqlo redesigns the PDF for you. It means you can choose the fill method that matches the PDF you have.

Step-by-step workflow

1. Prepare the PDF. Start with the form or stable layout you want every output to use.
2. Prepare the spreadsheet and export CSV. Keep one output document per row.
3. Upload the PDF in Bulk Fill.
4. Upload the CSV.
5. Choose native fields, overlay Fields, or both depending on the PDF.
6. Map fields to columns. Use the CSV column that should drive each value.
7. Preview representative rows. Check short values, long values, blank values, dates, and any rows that may be unusual.
8. Export a test PDF. Open it like a recipient or downstream system would.
9. Export the full batch when the test output is correct.
10. Reuse the setup later through a .doqlo project file or the Public API if the workflow needs to run again.

For setup details, start with the Bulk Fill Overview, then read Prepare your CSV and Choose the right fill method.

Common use cases

PDF mail merge is most useful when the work is repetitive and the data is already structured. Doqlo is commonly a fit for:

• HR onboarding forms
• Training certificates
• Internal approval forms
• Compliance and employer forms with stable layouts
• Notices and letters
• Invoices or packing slips with consistent designs
• Education and training documents
• Government-style forms where the layout does not change
• Vendor, customer, or employee packets produced from tabular records

The workflow is strongest when the PDF template is stable, the row data is clean, and the team wants repeatable output rather than one-off manual editing.

Limitations

PDF mail merge is not the right tool for every PDF task.

If you only need to fill one PDF manually, a simple PDF editor may be enough. Bulk Fill is designed for repeated PDF output from rows of data.

If the PDF layout changes per row, Doqlo is usually a better fit after the layout is made stable. Bulk Fill expects one reusable PDF structure, then row-specific values inside that structure.

Doqlo currently uses CSV import, so Excel and Google Sheets users should export CSV before uploading data. Keep the spreadsheet as your working source if that is easier for your team, but upload the CSV to Bulk Fill.

Some XFA PDFs may need to be flattened or converted before they fit a standard Bulk Fill workflow. Native form filling in Doqlo is scoped to supported non-XFA AcroForm fields.

Doqlo also does not infer every mapping from arbitrary PDFs. You should plan to review fields, map columns, preview rows, and export a test PDF before running the full batch.

Next steps

If you have a PDF and spreadsheet data ready, start in Bulk Fill and run a small test batch first. Use the preview step to confirm that representative rows look correct before exporting everything.

For more detail, read the Bulk Fill Overview, Prepare your CSV, and Choose the right fill method. Those docs explain how to structure the CSV, when to use native PDF form fields, and when overlays are the better fit.