I have a pdf form with the field names that are the same as my excel spread sheet, how do I make the pdf find the excel file?

[jonv96563430]

Is there a way to link them together so the pdf will auto fill from the excel file? Also is there a way to fill one field in the pdf with a combination of two fields from the excel file. Example pdf has "name" excel file has "first name" and "last name", I would like to fill name field on the pdf file with a combination of first name and last name from the excel file.

Thanks for any help.

[try67]

You can import the data from the Excel file to the PDF, but it's a one time thing and the names of the fields in the PDF and the columns in the Excel file must match EXACTLY. However, you can create hidden fields called "first name" and "last name" and then use a script to populate the "name" field with their combined data, for example.

[jonv96563430]

I have the part about the field names matching figured out, how do I point to the excel file? There is no import from excel option that I can find in acrobat dc pro

[try67]

You have to first save the Excel file as a tab-delimited text file. Then in Acrobat go to Tools - Forms - More Form Options (might be called something slightly different in your version) - Import Data. Select the text file you exported from Excel and you're done.

[jonv96563430]

Thanks, thats what I was doing wrong. Is there an easy way to fill a spot on the form with a combination of 2 fields from the spread sheet?

Thanks again

[try67 · Accepted solution]

Using the example above, the custom calculation code for the "name" field will be:

event.value = this.getField("first name").value + " " + this.getField("last name").value;

[jonv96563430]

Thanks for the help, that worked. It took a little guess work to figure out you have to have all 3 fields on the pdf for it to work but got it.

Thanks