New Participant

Answered

Import data from Excel into fillable pdf using Acrobat XI Pro - is it possible? How?

Forum|Forum|10 years ago
January 19, 2016
5 replies
297631 views

I need to be able to create a fillable pdf where certain information can be merged from an Excel spreadsheet into the fillable pdf so our land use specialists can complete while in the field using tablets. I also need to be able to create a field where the user can attach or import a jpg. Is it possible to do this with Acrobat XI Pro? Is another program necessary. I need to know the answers to my questions by January 28, 2016.

This topic has been closed for replies.

Correct answer AadeshSingh

Hi shannonr80675036‌,

Yes, but you there are two things you need to do in Excel for this to work:

The columns need to be named the same way as the field names in the PDF form. You can either match the names that you are using in your PDF form, or you need to modify the field names in the PDF form so that they match the column names in Excel. In this sample, I took the first approach and used the field names as my column headers:

When you export your data file from Excel, you need to select the "Tab Delimited Text" format. This is one of the export options in Excel (and other spread sheet applications) that is available after you select File>Save As:

Once you have your Tab Delimited Text file, open your PDF form, and select Tools>Forms>More Form Options and click on Import:

On the file dialog, select to import a text file, browse to your exported text file and select it. On the next screen you can then pick which record to import, you can only import one record at a time:

This will fill the PDF form with the selected values:

You do this for every record you have in your Excel file and save the PDF file to a new name.

Regards,

Aadesh

abdelm98893565

New Participant

Hi Guys!!

I really need some help here. So i have a fillable PDF and the Tab Delimited file and everything is working properly when importing data. So my issue is that we have 100+ entries and all we do is import the data and print one by one, we don't save them and i am trying to find a script or something that i can use to auto import data and print for each entry. Any help would be much appreciated.

try67

Community Expert

You can do it using the (paid-for) tool I linked to above, which I've created. It allows you to generate a single file with all of the merged documents, and then you could print them all out with a single print command.

pramodp37529260

Known Participant

I'm Using Adobe Acrobat 7.x version in the same process after creation of tab delimited text file , It doesn't showing correct format of text, its totally showing some random text, like special characters, It is version problem or any others ?

please tell me solution for this.

try67

Community Expert

Are you sure it's a text file, and not a Word file or an RTF file, or something like that?

pramodp37529260

Known Participant

My Pdf file already Contain fields, Now just i want fill those fields with data base values/from excel.

Showing Error Message Like this, If it is not possible, Please let me know process how to bind pdf from database data.

Flamboyant_Dusk0101

New Participant

can you change the font once you inserted in the PDF? It looks like you cant in Acrobat...

marck43125596

New Participant

Easily from Edit Document in Acrobat DC

G

ghadirelmaghraby

New Participant

Hi, is there a way to fill in this form in Arabic? i tried itp it worked very well but when i have some of the inputs in arabic it doesnt work

AadeshSingh

Correct answer

Community Manager

Hi shannonr80675036‌,

Yes, but you there are two things you need to do in Excel for this to work:

The columns need to be named the same way as the field names in the PDF form. You can either match the names that you are using in your PDF form, or you need to modify the field names in the PDF form so that they match the column names in Excel. In this sample, I took the first approach and used the field names as my column headers:

When you export your data file from Excel, you need to select the "Tab Delimited Text" format. This is one of the export options in Excel (and other spread sheet applications) that is available after you select File>Save As:

Once you have your Tab Delimited Text file, open your PDF form, and select Tools>Forms>More Form Options and click on Import:

On the file dialog, select to import a text file, browse to your exported text file and select it. On the next screen you can then pick which record to import, you can only import one record at a time:

This will fill the PDF form with the selected values:

You do this for every record you have in your Excel file and save the PDF file to a new name.

Regards,

Aadesh

M

monikacfs

New Participant

I was able to do the above but as I have over 100 records that need to be imported from Excel, how do I automate that process so that I can have Acrobat create a new PDF file, save PDF with a unique name, then proceed to the next record?

try67

Community Expert

That process is called a Mail Merge. You can do it using the PDFMaker plugin in some versions of Office, or by using a script, like this one I've developed: Custom-made Adobe Scripts: Acrobat -- Mail Merge and Email

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