Fill a PDF form from a CSV (mail merge)
Make one filled copy of a form for every row of a spreadsheet.
Processed on your deviceor drop a PDF anywhere on this page. Files stay on this device.
How to fill a PDF form from a CSV (mail merge)
To fill a PDF form from a CSV, open the fillable PDF, then a CSV whose column headings match the form field names. Puffin PDF fills one copy of the form for every row and gives you a ZIP of separate files or one combined PDF, optionally flattened so it cannot be edited. Names and other data stay on your device.
- Select a fillable PDF form.
- Select a CSV whose column headings match the field names.
- Choose separate files or one combined PDF, and whether to flatten.
- Press Fill forms and download the result.
Questions and answers
How do I find the field names?
The tool lists the form's field names and shows which CSV columns match them.
What about checkboxes?
Use yes, true, x or 1 to tick a box.
My form has no fields. What now?
Add them first with Create fillable form.
Are my files uploaded?
No. The work is done by code running in your browser, so your file never leaves your device. You can check this yourself: open your browser's developer tools, switch to the Network tab and run the tool. No request carries your file.
Is it free? Are there limits?
Yes, it is free with no sign-up, no watermark and no daily limit. Because your own device does the work, it costs us almost nothing to run, so there is nothing to meter.