Highlighted

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

New Here ,
Jan 19, 2016

Copy link to clipboard

Copied

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.

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

Topics

Create PDFs, Windows

Views

157.0K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
This conversation has been locked.

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

New Here ,
Jan 19, 2016

Copy link to clipboard

Copied

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.

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

Topics

Create PDFs, Windows

Views

157.0K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jan 21, 2016

Copy link to clipboard

Copied

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

Likes

4 Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Apr 05, 2017

Copy link to clipboard

Copied

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?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Most Valuable Participant ,
Apr 05, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Apr 16, 2018

Copy link to clipboard

Copied

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?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Most Valuable Participant ,
Apr 16, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Jan 25, 2018

Copy link to clipboard

Copied

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?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Most Valuable Participant ,
Jan 25, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Jan 25, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Feb 13, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
May 11, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Oct 24, 2017

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Jan 15, 2018

Copy link to clipboard

Copied

Easily from Edit Document in Acrobat DC

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Mar 26, 2018

Copy link to clipboard

Copied

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.Capture.JPG

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Most Valuable Participant ,
Mar 26, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Mar 26, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Most Valuable Participant ,
Mar 26, 2018

Copy link to clipboard

Copied

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.)?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Mar 26, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Mar 26, 2018

Copy link to clipboard

Copied

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Most Valuable Participant ,
Mar 26, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Mar 26, 2018

Copy link to clipboard

Copied

Capture.JPG

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Community Beginner ,
Mar 26, 2018

Copy link to clipboard

Copied

Capture.JPG

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Most Valuable Participant ,
Mar 27, 2018

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
New Here ,
Sep 13, 2018

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
try67 LATEST
Most Valuable Participant ,
Sep 13, 2018

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Resources
One Stop Solution for Acrobat
Edit a PDF
Add a group