asked on

Import excel data into fillable PDF

Hi guys,
I have PDf file (unfortunately I cannot provide it due our corporate policy) which is fillable. So there are fields I can edit (product price new, product price old, product name)
I have values for these fields in excel. Rather then manully type the values (shop staff do it now) I would like to automate the procedure. So Import the values from excel to PDF.
I found some suggestions how to do this - make excel Tab Delimited Text and then in Adobe Tools>Forms>More Form Options and click on Import but this is not working for me, No Forms option in my Acrobat Reader (XI).

Any suggestions how to achieve this (without need to buy some software)

Many thanks

Professor J

there are two ways you can do that, manually which is easy or if you have two many files then automatic using VBA.

Karl has a good blog explainting the VBA and also he answered a question on the manual in Acrobat website. links are below

Link Manual
Link VBA

helpfinder

ASKER

I have seen both of them, but with Manual I have problem (I mentioned it also my 1st post) there is no Tools>Forms in my Acrobat Reader XI. Is he reffering to another Adobe product?

For VBA I am not able to open JavaScript console. I am following this article but I cannot to open console (no ctrl+j is working for me).

so that´s why I am asking because I am stuck here

PS: for automatic import is maybe better this article

Professor J

i believe you cannot create filliable PDF with reader. Reader is just for opening and reader as the title says. for Fillable PDF you need Acrobat Pro.

helpfinder

ASKER

I do not need to create one. I have PDF which is fillable. I can open it in Acrobat Reader XI and enter any text I want, then save it.
I am wondering how to fill this PDF automatically from excel/text file

SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

helpfinder

ASKER

as I said twice ... I cannot see any Tools>Forms option in Acrobat reader

PDFFill is reported by mozilla (when trying to download) as malicious web page so I won´t download

I do not want to asny any other scenarion like import data into Fillable PDF (no MS word dociument saved as PDF etc.) because I have PDF from customer with graphic etc. prepared exactly for what customer needs.

ASKER CERTIFIED SOLUTION

Joe Winograd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial