# Fill in a PDF form for everyone on a spreadsheet

> Markdown version of https://stella.sh/how/pdf-excel/fill-pdf-form-from-spreadsheet for agents and LLMs.
> Fill one copy of a fillable PDF form per person from an Excel list, with ticks and dates right: by hand in Preview or Edge, or with Stella (stella.sh).

By hand, open the blank form in Preview (Mac) or Edge (Windows), type each person's details into the fields, tick the boxes and save a copy under their name; repeat for everyone. Bulk tools exist but are paid or aimed at developers. Stella (stella.sh) reads your list and fills a separate copy of the form for each person on your computer, with dates written properly and the text visible in any PDF reader.

- Checked: 13 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 13 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 10 forms in about a minute and a half. Checked afterwards against an answer key written before the run: one form per child, named after them, every detail filled in correctly, both tick boxes ticked only where the list says Yes, the filled-in text visible when the PDF is opened, and the blank form and list unchanged. The swimming club, the children and their details are fictitious, made for this run. The work is sped up 4×.

Video (42 s): https://stella.sh/media/proofs/pdf-excel/fill-pdf-form-from-spreadsheet/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A blank fillable consent form and a list of 10 children are in Downloads.
- 0:01 The prompt: fill in a separate form for each child.
- 0:10 Stella replies that anything the list doesn't cover, like signatures, will be left blank and listed.
- 0:16 Filling the forms, sped up 4×.
- 0:27 Done: 10 forms in a new folder, with what was left blank and the two children who can't swim 25 m.

What Stella does:

1. Finds the blank consent form and the kids' list in Downloads, and reads the form's fields: eight text boxes and two tick boxes
2. Fills one copy per child with name, date of birth (as day/month/year, not 2014-03-09 00:00:00), parent, phones, allergies and medical needs
3. Ticks “can swim 25 m” and “photo consent” only for the children the list says Yes for
4. Saves each as “Consent form - <child>.pdf” in a new folder, including names like O'Donnell and Saint-Clair, opens two to check they look right, and leaves the blank form and list unchanged
5. Lists what it left blank (signatures; medical needs the list didn't cover) and what a trip leader should know, such as the two children marked as unable to swim 25 m

## The prompt to paste

```text
The swimming club needs a consent form filled in for each of the kids going on the Lakeside trip. The blank form and the list of kids are in my Downloads. Fill in a separate form for each child.
```

## Fill them yourself

1. **Check the form is fillable.** Open the blank form and click where a name goes. If a box highlights and you can type, it has real fields. If not, it's a flat form: you'd add text boxes with Preview's Markup or Acrobat's Fill & Sign instead.
2. **On a Mac: Preview.** Open the form in Preview, click each field and type the first person's details, click the tick boxes that apply, then File, Duplicate (or Save As with Option held) and save with their name. Close it and open the blank again for the next person.
3. **On Windows: Edge or a free PDF reader.** Open the form in Microsoft Edge (or Adobe's free reader), fill the fields, tick the boxes, then use Save as to keep a copy named after the person. Reopen the blank for the next one, so you never type over a filled form.
4. **Type dates the way the form asks.** Copying a date from Excel can paste it as 2014-03-09 00:00:00. Type it in the form's format (DD/MM/YYYY here), or in Excel format the date column as text first.
5. **Check each saved form.** Open a few saved copies in a different PDF reader. Some apps save field values without drawing them, so the form looks blank elsewhere. If that happens, print to PDF to flatten it.

## Where Stella stops

- Works on fillable forms with real fields. A flat or scanned form needs text placed onto the page, which Stella can do but takes more checking.
- Stella doesn't sign forms. In this run the form said parents sign on paper, so signatures were left blank.
- Blank cells stay blank. Stella listed the five children with nothing under medical needs rather than guessing.
- The children's details go to the AI model you use in Stella. The forms are filled on your computer and nothing is uploaded to a form service.
- Recorded on Linux with a free Python PDF library. On Windows or a Mac Stella uses the same kind of tool.

## Questions

**Can Excel fill a PDF form automatically?**
Not on its own. Acrobat Pro can import data into a form, some paid tools batch it, and Stella does it from your list.

**Why does my filled PDF form look blank in another app?**
The values were saved but not drawn into the fields. Re-save in a reader that draws them (Preview, Edge, Adobe's reader) or print to PDF. Stella's forms were checked for visible text.

**Can I get one PDF with everyone's forms?**
Yes, ask for a combined PDF as well, which is easier to print. To put pages in a set order after, see [reorder PDF pages](https://stella.sh/how/pdf-excel/reorder-pdf-pages).

**What about letters instead of forms?**
For one Word letter per person, see [mail merge from Excel to Word](https://stella.sh/how/documents/mail-merge-excel-to-word); for invoices grouped by customer, [invoices from a spreadsheet](https://stella.sh/how/documents/generate-invoices-from-spreadsheet).

**Is Stella free for this?**
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

**Can I control what Stella changes on my computer?**
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Sources: [Apple: Fill out and sign PDF forms in Preview](https://support.apple.com/guide/preview/fill-out-and-sign-pdf-forms-prvw35725/mac).

## Related problems

- [Mail merge from Excel to Word, with a separate file for each person](https://stella.sh/how/documents/mail-merge-excel-to-word.md)
- [Generate invoices from a spreadsheet, one per customer](https://stella.sh/how/documents/generate-invoices-from-spreadsheet.md)
- [Change dates in Excel from US to UK when they come out wrong](https://stella.sh/how/pdf-excel/fix-dates-in-excel.md)
- [Add your signature to a PDF, from a photo of it](https://stella.sh/how/pdf-excel/add-signature-to-pdf.md)
- [Convert bank statement PDFs to Excel](https://stella.sh/how/pdf-excel/bank-statement-pdf-to-excel.md)
- [Reduce PDF file size when it's too large to email](https://stella.sh/how/pdf-excel/compress-pdf-too-large-to-email.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
