If you have Adobe Acrobat Pro installed, then you can use an Excel App to Fill Out PDF Forms automatically, directly from Excel. First, download the sample PDF form and the Excel Form Filling Tool from the fill pdf from excel below: Download sample files: Form Filling Tools. How Data is Organized:First of all, there is a main folder, named Form Filling Tools, that will contain a folder with Templates, all your PDF templates must be stored in the Templates folder.
Inside the Form Filling Tools folder, there is an Excel file named Fill PDF Form. Excel tool that will help us Fill PDF Forms automatically. The Filled Forms folder is not in the archive you downloaded from the above link, it will be created automatically.
Also, the code will create a sub-folder in Filled Forms for each row of data. If you have a PDF template to fill for John Doe for example, a sub-folder named John Doe will be created in Filled Forms folder, and that PDF template will go into John Doe folder. Each PDF created by code will have a time stamp in the file name, to avoid overwriting older forms and to allow you to find the most recent versions. How to Use the Excel App to Fill Out PDF Forms I tried to build a flexible structure, to allow users to use this tool with their own PDF Forms.
As a result, there are 2 important sheets in the Fill PDF Form. Data, which holds a defined table with all your source data, that needs to be sent to PDF forms.