On this page
- Short answer
- How do I fill a PDF form from Excel?
- How should I prepare my data?
- How do I map spreadsheet columns to PDF fields?
- Can I fill PDFs straight from my CRM instead of a file?
- How do I check a bulk fill before anything is sent?
- How do I send one form to many people to sign?
- What are the common mistakes with bulk PDF filling?
- Questions people ask
Short answer
To fill a PDF from Excel or a CRM, put one person per row (or one record per contact), match each column or property to a field on the form once, and fill a copy for every record. Review any missing or conflicting values before anything goes out, then send each filled copy for signature. The matching is the slow part, and you only do it once per form.
Key takeaways
- One record per row, one header row, consistent dates and Yes/No values.
- Map columns to fields once per form, then reuse the mapping for every batch.
- Filling straight from your CRM avoids exporting stale spreadsheets.
- Review flagged fields across the whole batch before you send anything.
- Bulk send one template to many people, each with their own filled copy.
It's the start of the season and forty clients need the same form. Their details already live in a spreadsheet, or in your CRM. The plan is "mail merge," except PDFs don't do mail merge, and by client number six someone is copying and pasting from one window into another again.
This guide shows how to fill the same PDF for many people from Excel, a CSV or a CRM: how to prepare the data, match it to the form once, check the batch, and send each copy for signing. It's part of our guide to filling PDF forms automatically.
How do I fill a PDF form from Excel?
Put one person per row with a single header row, match each column to a field on the PDF once, fill one test copy, check it, then fill the rest. You'll need a tool that can read your sheet and write into the form: a form-filling app, a PDF editor's data import, or a short script with a PDF library.
The whole process in six steps:
- Clean the sheet. One header row, one record per row, no merged cells.
- Check the PDF. Is it fillable, flat or scanned? (Our guide to fillable, flat and scanned PDFs has a quick test.)
- Map columns to fields. Once per form.
- Fill one test copy with a made-up record and check every field.
- Fill the batch and review anything flagged.
- Send for signature, one envelope per person or as a bulk send.
How should I prepare my data?
Use one header row with clear names, one record per row, and the same format all the way down each column. Dates, Yes/No answers and phone numbers cause most problems, so standardise them before you map anything. Split full names and addresses into parts if the form asks for them separately.
A data checklist:
How do I map spreadsheet columns to PDF fields?
Match each column header to one field on the form, once, and save that mapping for the next batch. On fillable PDFs you match to the field names stored in the file; on flat or scanned PDFs the fields must be found first. Most problems here come from headers and field names that don't line up.
| Problem | What you see | Fix |
|---|---|---|
| Cryptic field names | Text17 instead of "Date of birth" | Click each field to identify it, or use a tool that reads the printed labels |
| Name mismatch | Column "DOB", field "Date of birth"; nothing fills | Map explicitly rather than relying on matching names |
| Checkbox values | Box stays empty even though the cell says "Yes" | Use the value the checkbox expects, or let the tool convert it |
| Date format | 2026-03-14 lands on a form that wants 14/03/2026 | Convert dates to the form's own format |
| Character boxes | A 9-digit number spills across the comb | Strip spaces and dashes; one character per box |
| Overflow | Long addresses cut off | Shrink to fit, abbreviate, or flag for a person |
In AppliFlo's PDF and Word forms, you pick the client and every field fills from their record in GlobalyOS, HubSpot or a CSV, with dates and names arriving in the form's own format. If the form is flat or scanned, AI finds the fields first. Once a form is set up, filling it again from a saved template never uses AI pages.
Can I fill PDFs straight from my CRM instead of a file?
Yes, and it avoids the stale-export problem. Instead of exporting a spreadsheet that's out of date by lunchtime, a connected tool reads each client's current record when you fill. A read-only connection is the safer kind: the form tool can read the record but can't change it.
AppliFlo's live connections today:
- GlobalyOS: one-click Connect; signed copies go back to the client record.
- HubSpot: OAuth, read-only. AppliFlo reads contact properties to fill forms and doesn't write back.
- CSV and Excel upload: for everything else.
- REST API and MCP server: for your own systems and AI agents, on the Business plan. See developers.
On the roadmap, not yet live: Google Sheets, Salesforce and Agentcis.
How do I check a bulk fill before anything is sent?
Fill one test copy first, then review flags across the whole batch in one place: rows with missing values, dates that couldn't be converted, text that didn't fit, and records with two possible answers. Fix the data at the source where you can, so the next batch is cleaner. Nothing should be sent while a flag is open.
What to look at, in order:
- The test copy, field by field. Open it in a PDF reader, click through every field, print one page.
- Missing values. A blank on one row is often a blank in the CRM.
- Conflicts. Two addresses, two surnames, a date that doesn't parse.
- Overflow. Values too long for their box.
- Signature lines. They should be left for signing, never filled with typed names.
In AppliFlo, a value that won't fit, or one AppliFlo is unsure of, is flagged for you and never quietly guessed. Fix a misplaced box once and form memory keeps the correction for the next copy of the same form. We explain the thinking in Flag, don't guess.
How do I send one form to many people to sign?
Use bulk send: one template, many recipients, each getting their own copy filled with their own details. Set the signing order if more than one person signs, turn on reminders, and track who has finished from one list. Each signed copy should come back sealed with its own audit trail.
In AppliFlo's Sign, bulk send sends one template to many clients, with roles, signing in order or in parallel, and reminders. Every signed PDF gets a PAdES seal, a certificate of completion and an audit trail showing who signed, when and from which IP address. Bulk send is on the Starter and Business plans; see pricing for current details.
What are the common mistakes with bulk PDF filling?
The usual ones: filling a flat PDF that has no fields, trusting column headers to match field names, skipping the test copy, sending before reviewing flags, and using an old edition of an official form. Each one is cheap to avoid and expensive to fix after forty envelopes have gone out.
- Skipping the test copy. One wrong mapping, multiplied by every row.
- Old edition. Download official forms fresh from the agency, or use a library that tracks editions, before a big batch.
- Silent truncation. Long names cut off without anyone noticing.
- Editing the PDF instead of the data. Fix the CRM record, or the same error returns next season.
If your team handles onboarding at volume, the Form I-9 employer guide shows a real-world pack that suits this approach.
Questions people ask
How do I fill a PDF form from Excel?
Save your sheet with one header row and one person per row. Then use a tool that can match each column to a field on the PDF, such as a form-filling app, a PDF editor's data import, or a script with a PDF library. Match the columns once, fill one test copy, check it, then fill the rest of the rows.
Can I fill many PDFs at once?
Yes. Once each column is matched to a field, a bulk fill creates one copy of the form per row or record. The important step is reviewing the batch: look for rows with missing values, dates in the wrong format and text that doesn't fit, before any copy is signed or sent.
Can I fill PDFs from HubSpot?
Yes, with a tool that connects to HubSpot. AppliFlo connects to HubSpot with a read-only connection: it reads contact properties to fill forms but doesn't write anything back. You pick the contact, and their properties fill the matching fields. Anything missing from the record is flagged for you instead of guessed.
How do I send one form to many people to sign?
Use bulk send: one template, many recipients, each getting their own copy filled with their own details. Set the signing order if more than one person signs, turn on reminders, and track who has finished. In AppliFlo, bulk send is on the Starter and Business plans.
Why are some fields blank after a bulk fill?
Usually because the column header doesn't match the field, the cell is empty, or the PDF has no fillable fields at all. Check the mapping, check the row, and check that the PDF is fillable. Flat PDFs and scans need their fields found first, by hand or by AI detection.
