Fill in a PDF form for everyone on a spreadsheet
Ten trip consent forms filled from a list of kids, ticks only where the list says yes.
A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 32 s in real time.
The short answer.
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.
Stella does this on Windows, Mac and Linux.
What happened.
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×.
How Stella does it.
- Finds the blank consent form and the kids' list in Downloads, and reads the form's fields: eight text boxes and two tick boxes
- 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
- Ticks “can swim 25 m” and “photo consent” only for the children the list says Yes for
- 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
- 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.
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.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
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.
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.
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.
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.
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 it 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.
What about letters instead of forms?
For one Word letter per person, see mail merge from Excel to Word; for invoices grouped by customer, invoices from a 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.
Checked against these sources on 13 November 2026.