Skip to content
BoringKit

Use case

Fill a PDF form for every row of a CSV

To fill the same PDF form once for every row of a spreadsheet, save the rows as a CSV, open PDF Form Mail Merge, map each form field to a column and download a ZIP with one editable PDF per row. It works with fillable (AcroForm) PDFs, runs in your browser with no upload, and a Free job without an account fills up to 3 rows; a trial, Plus or Pro fills up to 25 rows per job.

What you get

This suits certificates, award letters, registration forms or any document where the layout stays the same and only names, dates, amounts or checkboxes change. Nothing is guessed from field names: you choose the column for every field, and a value that does not fit its field stops the export instead of being cut off.

The result is a set of PDFs you review and send yourself. BoringKit does not email the files, collect signatures or flatten the forms.

How to fill a PDF form from each CSV row

  1. Prepare a fillable template

    Use a PDF with single-line text fields and checkboxes. Free accepts a template up to 4 MB with 3 pages and 10 fields.

  2. Save your rows as a UTF-8 CSV

    One header row with unique names, then one row per PDF. Checkbox columns must contain exactly true or false. Working in Excel? Export the sheet first. Open XLSX to CSV.

  3. Check the data before merging

    Optionally confirm required columns are filled and IDs are unique, so no PDF goes out with a blank name. Open CSV Rules Validator.

  4. Map every field to a column

    Choose a column for each form field and acknowledge any column you leave unused. Several fields may use the same column.

  5. Export the ZIP

    Download one editable PDF per row, named by row number, with a manifest that ties each file to its row. Open PDF Form Mail Merge.

  6. Open and review the PDFs

    Check a few filled PDFs before sending. If you need one combined file for printing, merge them afterwards. Open Merge PDF.

Synthetic example

Illustrative, made-up inputs and the result to expect. Review your own output before using it.

Input
Template fields (synthetic):
recipient (text), course (text), passed (checkbox)

certificates.csv (synthetic):
name,course,passed
Sample Person A,Intro to Spreadsheets,true
Sample Person B,Intro to Spreadsheets,false
Settings

Map recipient → name, course → course, passed → passed

Result
row-0001.pdf: recipient Sample Person A, course Intro to Spreadsheets, passed checked
row-0002.pdf: recipient Sample Person B, course Intro to Spreadsheets, passed unchecked
manifest.json lists both rows; the fields stay editable.

When to use it, and its limits

A good fit when

  • You already have a fillable PDF form and need the same form filled with different values per person, client or record.
  • Your data is in a spreadsheet or CSV with one row per document, such as a list of course attendees or event registrations.
  • The files must stay on your device: the template, the CSV and the filled PDFs are never uploaded.

Limits to know first

  • Free, without an account: 3 CSV rows, 10 form fields and a 3-page template per job (template up to 4 MB, CSV up to 256 KB with 10 columns).
  • Trial, Plus and Pro: up to 25 rows, 20 fields and a 5-page template per job.
  • Only fillable AcroForm PDFs with single-line text fields and checkboxes. Scanned forms without fields, XFA forms, encrypted PDFs, signature fields and rich-text fields are not supported.
  • The filled PDFs are not flattened, emailed or signed. Text that is too long for a field, or uses characters the field font cannot show, stops the export with a message.
  • To design an invoice from scratch rather than fill an existing form, the Invoice Generator is a better fit.

Frequently asked questions

How do I fill a PDF form with data from a CSV file?

Open PDF Form Mail Merge, choose a fillable AcroForm template and a UTF-8 CSV with a header row, map each form field to a column and export. The ZIP contains one editable PDF per CSV row and a manifest that lists which row produced which file.

How many rows can I merge for free?

Free jobs need no account and fill up to 3 CSV rows into a template with up to 3 pages and 10 fields. A no-card trial, Plus or Pro allows up to 25 rows, 5 pages and 20 fields per job.

Can I make certificates or letters for a list of people?

Yes, if the certificate or letter is a fillable PDF with text fields for the parts that change, such as the name and date. Each row of your CSV becomes its own PDF. A plain PDF without form fields cannot be filled by this tool.

Can I use an Excel spreadsheet instead of a CSV?

Export the worksheet as a comma-separated UTF-8 CSV first, in your spreadsheet app or with XLSX to CSV. The mail merge reads CSV only. Use unique, non-empty headers and one data row per PDF.

Are my PDF and CSV uploaded?

No. The website runs the merge in your browser tab; the template, the CSV and the filled PDFs stay on your device and use no cloud files.

Does it send the PDFs by email?

No. It creates the files only. Download and review them, then distribute them yourself.

Tools for this job