FillPDFfromCSV

How does the column matching work?

The tool compares each PDF field name to your CSV headers with case, spaces, and punctuation stripped. A field called "First Name" matches a column named "firstname", "FIRST_NAME", or "first-name". Each column is used at most once, and read-only fields are skipped.

What counts as checked for a checkbox?

Checkbox columns accept yes, true, y, 1, x, checked, or on (any case) to tick the box, and no, false, n, 0, off, or unchecked to clear it. An empty cell is skipped and logged. Any other value, say "maybe", is reported as a failed cell with the reason, and the box stays unchecked.Dropdowns and radio groups are stricter. The cell must match one of the options stored in the PDF, exactly.

What does the run report show?

Every cell of every row: filled, skipped because the cell was empty, or failed with a written reason, such as "Value is 61 chars but the field allows max 40". Repeated failures are grouped, so one wrong column across 200 rows reads as one line, not 200. The report is how you catch a mapping mistake before the letters go out.