Skip to main content
bav_belgium
bav_belgium
Participant
November 23, 2019
Question

autofill ppdf file with data from excel sheet and save to file

  • November 23, 2019
  • 2 replies
  • 793 views

Hello,

 

I have a official PDF file that I need to fill in with a serial number and a date.

So made the pdf to a form, and put in the 2 fields, and manually save it to "date_serialNumber_fixedtext.pdf".

Now the problem is that this take so much time to do it manually because I have about 200 rows to do.

 

Is it possible to fill the data automatic from the excel file and save the pdf individually per excel row?

 

Second question, is it possible to do the automation work also in acrobat DC.

 

 

    This topic has been closed for replies.

    2 replies

    try67
    Community Expert
    try67Community Expert
    Community Expert
    November 23, 2019

    Yes, it's possible to do it. This is called a Mail Merge.

    You can do it directly from Excel using some versions of the PDFMaker plugin for Office, or by using a script, like this (paid-for) one I've developed: http://try67.blogspot.com/2011/09/acrobat-mail-merge-and-email.html

    hammer0909
    Community Expert
    hammer0909Community Expert
    Community Expert
    November 23, 2019

    You can't do this from an Excel file, but you can do it from an .fdf file. To see how an .fdf file is structured, fill in a few fields of the form and then go to the Prepare Form tool. Under the "More" section, choose Export data. Crack open the .fdf file and you'll be able to see how it's structured. You could technically also do this with an XML file as well.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices