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

[shannonr80675036]

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.

[AadeshSingh · Accepted solution]

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

[monikacfs]

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]

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

[adriang37102678]

Is it possible to do this with more than 500 entries? I have a excel sheet in which each row should import a fillable PDF then save as a new name.....I have to do this over 500 times. Is there something I can use to automate this?

[try67]

You can use the tool I've developed (see link above) to merge as many records as you wish.

[foxhound84]

I have my columns named the same as they are in my pdf form and after I save my excel doc as a tab delimited text form, adobe acrobat will not allow me to import this file from excel. When I try to import from my desktop adobe does not recognize the file. I am using a mac is that the issue?

[try67]

Make sure the file is not open in Excel file when import it in Acrobat.

[foxhound84]

Okay, I found out what the issue was why adobe did not recognize the file, I had to click the option button at the bottom and select "all files" for adobe to recognize my txt file. But now, the problem is when adobe opens my tab delimited txt file to import, all of my columns appear but none of the data I entered into the columns will appear for me to select

[BillyAsh07]

Hi!

I had the same problem but had scroll bars on the right hand side and scrolled down dozens of lines and at the bottom was my text, even though the text was only on the first 6 rows of the text file

[ghadirelmaghraby]

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

[Flamboyant_Dusk0101]

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

[marck43125596]

Easily from Edit Document in Acrobat DC

[pramodp37529260]

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]

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

[pramodp37529260]

1st it is a Excel File with values related to pdf columns and i changed it to tab delimated text extension insted of exxcel. thentrying to import data into pdf

[try67]

Are you sure you're selecting the text file and not the Excel file? If so, could you share the file with us (via Dropbox, Google Drive, Adobe Cloud, etc.)?

[pramodp37529260]

Thanks For Your Response, Please Check Below Link.

https://drive.google.com/open?id=1O-bjHrDQlKm5QDts1lfX0pAbp-EFf7pF

I have A editable Pdf Document And I want Fill That Document With Database Values/If it is not Possible i want Fill pdf Document With Above process..

Thank you

[pramodp37529260]

pdf - Google Drive

[try67]

The first step is to add form fields to your PDF file...

[pramodp37529260]

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

[pramodp37529260]

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

[try67]

The file you shared did not contain any form fields. Share the version that has them.

[abdelm98893565]

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]

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.