Import excel into PDF fillable form

Question

Hi, I'm trying to populate a PDF template using various rows of excel data using Adobe Pro. I was able to get most of it to work by making the form fields match my excel columns, but the PDF has 2 yes or no checkboxes that I can't seem to figure out how to auto-populate. My excel data has the column headers right, and for the data I've tried an "X" in either column or a Yes/No but it's not working. Any ideas?

PDF Automation Station · Answer

The check box export value must match the Excel cell value.  X will work if the export value of the check box is X.  Yes and No should work if you have 2 check boxes with the same name and the export values are Yes and No (case sensitivity matters), or 1 check box with a Yes export value ("Yes" will populate it, "No" will not).

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded