• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
Locked
1

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

New Here ,
Jan 19, 2016 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.

TOPICS
Create PDFs

Views

268.3K

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
community guidelines

correct answers 1 Correct answer

Jan 21, 2016 Jan 21, 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

...

Votes

Translate

Translate
Jan 21, 2016 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

Votes

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
community guidelines
New Here ,
Apr 05, 2017 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?

Votes

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
community guidelines
Community Expert ,
Apr 05, 2017 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

Votes

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
community guidelines
New Here ,
Apr 16, 2018 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?

Votes

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
community guidelines
Community Expert ,
Apr 16, 2018 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.

Votes

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
community guidelines
New Here ,
Jan 25, 2018 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?

Votes

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
community guidelines
Community Expert ,
Jan 25, 2018 Jan 25, 2018

Copy link to clipboard

Copied

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

Votes

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
community guidelines
New Here ,
Jan 25, 2018 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

Votes

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
community guidelines
New Here ,
Feb 13, 2018 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

Votes

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
community guidelines
New Here ,
May 11, 2017 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

Votes

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
community guidelines
New Here ,
Oct 24, 2017 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...

Votes

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
community guidelines
New Here ,
Jan 15, 2018 Jan 15, 2018

Copy link to clipboard

Copied

Easily from Edit Document in Acrobat DC

Votes

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
community guidelines
Explorer ,
Mar 26, 2018 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

Votes

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
community guidelines
Community Expert ,
Mar 26, 2018 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?

Votes

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
community guidelines
Explorer ,
Mar 26, 2018 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

Votes

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
community guidelines
Community Expert ,
Mar 26, 2018 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.)?

Votes

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
community guidelines
Explorer ,
Mar 26, 2018 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

Votes

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
community guidelines
Explorer ,
Mar 26, 2018 Mar 26, 2018

Copy link to clipboard

Copied

Votes

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
community guidelines
Community Expert ,
Mar 26, 2018 Mar 26, 2018

Copy link to clipboard

Copied

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

Votes

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
community guidelines
Explorer ,
Mar 26, 2018 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.

Votes

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
community guidelines
Explorer ,
Mar 26, 2018 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.

Votes

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
community guidelines
Community Expert ,
Mar 27, 2018 Mar 27, 2018

Copy link to clipboard

Copied

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

Votes

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
community guidelines
New Here ,
Sep 13, 2018 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.

Votes

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
community guidelines
Community Expert ,
Sep 13, 2018 Sep 13, 2018

Copy link to clipboard

Copied

LATEST

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.

Votes

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
community guidelines