Import data from excel and create multiple separate forms in Adobe

Forum|Forum|7 years ago
July 27, 2018
3 replies
5558 views

I am trying to auto populate pdf forms from excel (like mailmerge in word). I have multiple rows in excel and when I import data from the excel sheet, i would like each row to be created as a separate form in Adobe. I consulted with Adobe support and googled. It sounded like I needed a javascript and a custom action. Could someone help me with the script and guidnace on how to implement this in Adobe?

Acrobat SDK and JavaScript

This topic has been closed for replies.

P

ped76535503

Participant

Here is a video tutorial

Using Data Merge in Adobe InDesign - auto fill text fields and pages - YouTube

its like mailmerge in Word. Create text boxes in the Master > Window >Utilities> DataMerge and import the csv or txt.

try67

Community Expert

I believe (not 100% sure) that is should be available from the PDFMaker plugin in Excel, too.

I've developed a (paid-for) tool that allows you to do it directly in Acrobat, with some additional features which are not available in the built-in function. You can find it here: Custom-made Adobe Scripts: Acrobat -- Mail Merge and Email PDF Files

Karl Heinz Kremer

Community Expert

A while ago I wrote a blog post about just that: Batch-Import List Data into PDF Form - KHKonsulting LLC

This will import a tab separated text file, If you want to automate that from within Excel, that can be done as well, but is a bit more complex.

Karl Heinz Kremer

Community Expert

Oops, sent the wrong link. What you want to do is described here: Batch-Import Excel Data into PDF Forms - KHKonsulting LLC

eunicel9763549Author

Participant

I did look at this post and had trouble with below part. When I clicked on Doc.importTextData, it took me to general how to on JavaScript.

you can use the Acrobat JavaScript method Doc.importTextData() to import one record at a time (just like we did manually before). Take a look at the documentation for this method: Doc.importTextData

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