Homeโ€บToolsโ€บFill PDF from Excel
๐Ÿ”’ No uploadCheck boxes & drop-downsNames from your columns

Fill PDF Forms from Excel or CSV โ€” One PDF per Row by AIMerger

Have a fillable PDF form and a spreadsheet of people, orders or students? Match the formโ€™s fields to your columns once, check a real preview, and get one filled PDF for every row โ€” named from your columns, flattened if you like, in one ZIP. PDFs without fields work too: place column values on the page.

๐Ÿ”’ Processed locally in your browser โ€” your files never leave your device
1

Add the PDF form and the spreadsheet

Fields are detected automatically: text, check boxes, choices and drop-downs.

1 ยท The PDF form

๐Ÿงพ Drop the PDF form

A fillable PDF โ€” or any PDF for text placement

2 ยท The data

๐Ÿ“Š Drop the spreadsheet

Excel .xlsx/.xls, .ods or CSV โ€” one row per filled PDF

2

Match fields to columns

Columns with the same (or similar) names are matched for you. The preview is a real filled form.

File names can use any column in braces, e.g. {Full Name}-{Member ID}, and {row} for the row number. Data: .

3

Fill & download

Rows with values that donโ€™t fit a field are listed โ€” nothing is dropped silently.

๐Ÿ”’ Filled on your device. Your form and your data are never uploaded.

Limits on this device

Up to a few thousand rows on a computer (about 1,000 on phones). Values are written with the standard PDF font (Helvetica); characters it canโ€™t draw โ€” Hindi, Telugu, emoji โ€” are drawn as sharp pictures when flattening, or left for PDF readers to display when not flattening. Signature fields and buttons are not filled. Leading zeros in IDs are kept. Password-protected PDFs need the password removed first.

Fill PDF from Excel โ€” a real example made with this tool from sample files

A fillable form + a 3-row CSV โ†’ three filled PDFs, named from the columns.

How to use the PDF form filler โ€” 4 steps

  1. 1

    Add the PDF form and the spreadsheet (Excel, OpenDocument or CSV). Pick the sheet and header row if needed.

  2. 2

    Check the matches: each PDF field is matched to the column with the same or a similar name. Change any match with the drop-down. Check boxes tick for yes / true / 1 / x / โœ“.

  3. 3

    Choose the output โ€” one PDF per row (ZIP) or one combined PDF โ€” and the file-name pattern, such as {Full Name}-{Member ID}. Look at the preview of any row.

  4. 4

    Press Fill PDFs and download. Rows with values that didnโ€™t fit a field (a choice that isnโ€™t on the list, text too long) are listed.

๐Ÿ’ก Tip: Name your spreadsheet columns like the form fields (for example โ€œFullNameโ€ and โ€œFull Nameโ€ both match) and the mapping is done for you. Keep IDs as text in Excel so leading zeros (000123) survive โ€” CSV files keep them automatically.

Mail merge for PDF forms

Wordโ€™s mail merge makes letters; it canโ€™t fill a PDF form someone else designed โ€” a government form, a certificate template, an enrolment or claim form. This tool fills the formโ€™s own fields from each row, so the result looks exactly like the original form filled in by hand, and creates one file per person with a sensible name.

  • Text fields get the cell value as shown (dates and numbers as formatted in the sheet; leading zeros kept). Fields with a maximum length are respected, and the row is flagged if a value was shortened.
  • Check boxes are ticked for yes, true, 1, x or โœ“ and left empty otherwise.
  • Radio buttons and drop-downs are set when the value matches one of the options (upper/lower case and accents donโ€™t matter); otherwise the row is listed so you can fix the data.

Flatten or keep editable

Flattening turns the filled values into part of the page: they look the same in every PDF reader and canโ€™t be changed โ€” usually what you want before sending. Leave it off if people should still be able to edit their form. A combined PDF is always flattened, because many copies of the same form fields canโ€™t live in one file.

PDFs without fillable fields

Many forms are just a scan or a flat PDF. Choose Place text on the page, pick a column and click where its value should go โ€” repeat for each column, and fine-tune the position in points. Values are drawn with Helvetica; text in other scripts is drawn as a sharp picture.

Frequently asked questions

How do I fill a PDF form from Excel?

Add the fillable PDF and your Excel file above, check that each field is matched to the right column, and press Fill PDFs. You get one filled PDF per row in a ZIP, named from columns you choose.

Is this a PDF mail merge?

Yes โ€” itโ€™s mail merge for PDF forms: every row of your spreadsheet fills a copy of the form. The result can be one PDF per row or one combined PDF.

Does it work with CSV files?

Yes. CSV, TSV, Excel (.xlsx, .xls) and OpenDocument (.ods) all work.

What if my PDF has no fillable fields?

Use โ€œPlace text on the pageโ€: click where each columnโ€™s value should go. It works with scanned and flat PDFs.

Will check boxes and drop-downs be filled?

Yes. Check boxes tick for yes/true/1/x/โœ“; drop-downs and radio buttons are set when the value matches an option. Values that donโ€™t match are listed by row.

Can I name each PDF after a person?

Yes โ€” type a pattern like {Full Name}-{Member ID}. Any column in braces works, plus {row}.

Are my form and data uploaded?

No. Everything is filled in your browser on your device.

Related tools

Free tools that pair well with this one.

๐Ÿงฐ Browse all 88 AIMerger tools โ†’