Importing data from excel to a fillable PDF form

Question

I would very much like to import data from excel til a pdf form. Running on Acrobat pro, Acrobat EDU, version 2025.00120997, 64 Bit. I cannot find an "Import" button anywhere. Is it possible at all??

PDF Automation Station · Accepted Answer

https://pdfautomationstation.substack.com/p/the-javascript-console

PDF Automation Station · Answer

One way is to use the importTextData method:

Make sure the Excel column headings match the PDF field names exactly (including case sensitivity)
Save the Excel file as file type: Text - Tab delimited
Run the following script in the console: this.importTextData()

You will have to browse your hard drive for the text file then select the row you want to import. If you want to do it silently you will have to add parameters like cPath and nRow to the method. If you want the trigger to be other than the console (with silent import), you will have to create a trusted function.

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.