# PDF Form Mail Merge - Bulk Fill Forms from CSV, Export Data

> Fill a PDF form from CSV rows: auto-matched fields, checkboxes, radios, dropdowns, CJK text, optional flattening, one PDF per row or combined; export form data.

- URL: https://qilingtools.com/en/pdf/form-merge
- Category: PDF Tools (https://qilingtools.com/en/pdf)
- Tags: [PDF](https://qilingtools.com/en/tags/pdf), [Documents](https://qilingtools.com/en/tags/document), [Data Formats](https://qilingtools.com/en/tags/data), [Productivity](https://qilingtools.com/en/tags/office)
- Last updated: 2026-10-26
- Price: Free, no sign-up
- Privacy: Runs locally in the browser; files are never uploaded

Need dozens or hundreds of filled-in copies of the same PDF form — registrations, contracts, certificates, letters? Upload a PDF template with fillable fields, then paste rows copied from Excel or Google Sheets or load a CSV / TSV file (comma, tab and semicolon delimiters are detected automatically, and legacy GBK-encoded exports are handled). Columns are matched to form fields by name and you can adjust the mapping by hand. Checkboxes understand yes / no, true / false, 1 / 0, x, ✓ and their Chinese equivalents; radio groups, dropdowns and list boxes match options ignoring case and full-width characters, and any value that still doesn’t match can be mapped to an option one by one (separate multiple dropdown choices with semicolons). Choose whether to flatten the result (contents become part of the page) or keep a fillable form, and whether to output one PDF per row — named from a template such as {Name}-{#} and zipped — or a single combined PDF; when the form is kept, each copy’s fields get a suffix so they don’t mirror each other. Standard fonts can’t encode Chinese, Japanese or Korean: when flattening, such values are drawn into the field as high-resolution images; when the form is kept, values are stored and the reader renders them with its own fonts. Truncations, unmatched options and similar issues are collected in a warnings CSV. A second mode reads many already-filled PDFs at once and exports every field value to CSV and JSON for analysis. Everything runs locally in your browser.

## How to use

1. Upload a PDF template with fillable fields, then paste your table or load a CSV / TSV file
2. Check how columns map to fields and set value mappings for checkboxes, radios and dropdowns if needed
3. Pick flattening and output options, then click Generate PDFs to download a ZIP or a combined PDF

## Features

- Paste from Excel / Sheets or load CSV / TSV; delimiter and encoding detected
- Fields matched to columns by name, adjustable
- Smart matching and manual value maps for checkboxes, radios, dropdowns and lists
- CJK values drawn as images when flattened, rendered by the reader when editable
- Flatten or keep the form fillable
- One PDF per row with a file-name template, or one combined PDF
- Warnings collected in a CSV
- Bulk export of filled form data to CSV / JSON

## FAQ

### My PDF has no fillable fields — what now?

Mail merge needs form fields (AcroForm) in the template. Add text boxes, checkboxes, radio buttons and dropdowns with Create PDF Form first; naming the fields like your spreadsheet headers lets the columns match automatically. Files with only an XFA dynamic form have the XFA removed and are treated as standard forms.

### Will Chinese or other non-Latin text show up blank?

The standard PDF fonts don’t include CJK characters. With Flatten ticked, such values are rendered as high-resolution images in the field area, so every viewer shows them. When the form stays fillable, the values are stored and the file asks the viewer to redraw the fields; Acrobat, Chrome, Edge and most readers use their own fonts, but a few basic viewers may show them blank — flatten in that case.

### How should I write checkbox and radio values?

Checkboxes accept yes / no, true / false, 1 / 0, x, ✓ / ✗ and similar. For radio groups and dropdowns, write the option text; differences in case or full-width characters still match. Unusual values can be mapped under Value mapping, e.g. M / F to Male / Female. Values that can’t be matched are skipped and listed in the warnings CSV.

### Is my data uploaded? How many copies can I make?

Nothing is uploaded; the template and data are processed in your browser. The limit is mostly your computer’s memory — a few hundred copies is usually fine. A combined PDF can get large, so switch to one PDF per row if needed.

## Related tools

- [Merge PDF](https://qilingtools.com/en/pdf/merge): Free online PDF merger: combine several PDF files into one in the order you choose, with reordering. Processed locally in your browser, no upload, no sign-up.
- [Split / Extract PDF](https://qilingtools.com/en/pdf/split): Free online PDF splitter: extract a page range into a new PDF, or split every page into its own file and download them as a ZIP. Processed locally.
- [Rotate PDF](https://qilingtools.com/en/pdf/rotate): Free online PDF rotator: rotate all or selected pages by 90°, 180° or 270° to fix scanned documents. Processed locally, no upload.
- [PDF to Image](https://qilingtools.com/en/pdf/to-image): Free online PDF to image converter: render every page as a high-resolution JPG or PNG at 72/150/300 DPI, download all as a ZIP. Processed locally, no upload.
- [Image to PDF](https://qilingtools.com/en/pdf/from-image): Free online image to PDF converter: combine JPG, PNG and WebP images into one PDF in order, with A4 or image-sized pages. Processed locally, no upload.
- [Compress PDF](https://qilingtools.com/en/pdf/compress): Free online PDF compressor: re-render pages with compressed images to shrink scanned and image-heavy PDFs, with adjustable quality. Processed locally.
- [Watermark PDF](https://qilingtools.com/en/pdf/watermark): Free online PDF watermark tool: add text watermarks to every page, tiled or centred, with opacity and angle controls. Any language, processed locally.
- [Delete PDF Pages](https://qilingtools.com/en/pdf/delete): Free online tool to delete PDF pages: remove pages by number or range and keep the rest, then download. Processed locally, no upload.