Skip to main content
A
AlexandrePayre
New Participant
September 17, 2020
Question

Data not being imported from Excel into Acrobat Pro 11

  • September 17, 2020
  • 3 replies
  • 2290 views

Dear Adobe Users,

 

I am writing with regards to importing data from an Excel document into Adobe Acrobat Pro DC T1 EDO.
Here is what I do:

 

  1. Create a document in InDesign and save it as an Interactive PDF document.
  2. Once the Excel document finished, save it as "Text (tab delimited)". The Excel document only contains non-formatted text.
  3. Close the Excel document.
  4. Open the PDF document and go to Prepare Form => More => Import Data. Then select the tab delimited text document.

 

After selecting the tab delimited text document, nothing happens. Data is not being imported, and there is no error message either.

 

Please note that I did the exact same thing before, with Adobe Acrobat Standard 9.0, and it worked perfectly.

 

Would you please be able to help me?

 

Many thanks in advance!

This topic has been closed for replies.

3 replies

Karl Heinz Kremer
Karl Heinz Kremer
Community Expert
September 17, 2020

This should work with forms created in InDesign as well. The problem is usually not having the right number of columns in your Excel file, or that the field names do not match exactly what's in the PDF file. The way I usually approach this is by filling a form in Acrobat, then exporting that data using the "Export Data" function under the "More" tools option when you are in the form editor:

 

 

This will give you a template of what your Excel generated file needs to look like. The columns can be in a different order, but all of the columns that you see in the exported file need to be in your own file, and the column headers need to be identical. 

 

You can then close your PDF file, and open a blank version of the form, and then try to import the file that you've generated. It should fill all the fields just like they were. Once that works, you can work with your own data exported from Excel. 

    A
    AlexandrePayreAuthor
    New Participant
    September 18, 2020

    Dear try67, Bernd Alheit, Karl_Heinz_Kremer,

     

    I thank you for your useful answers. I guess the first thing to do is to share the files with you, as you mentionned.

    Please note that I carefully checked the names in each and every single button in InDesign as well as in each Excel cell. I actually noticed one mistake, corrected it, retried the whole process, but it didn't work.

     

    Kindly find below the WeTransfer link for the files to be downloaded:

    Files 

    Content:

    • List of countries.xlsx
    • List of countries.txt
    • Seating plan.indd
    • Seating plan.pdf

     

    Karl_Heinz_Kremer, I will try to follow your instructions in the meantime.

     

    Many thanks in advance for your assistance.

    try67
    try67
    Community Expert
    September 18, 2020

    One possible issue is that many of your values contain line-breaks, but the fields are not set as Multiline, which will not work. I would recommend removing all line-breaks from the input file.

      Bernd Alheit
      Bernd Alheit
      Community Expert
      September 17, 2020

      Are the names of the form fields and the columns of the Excel file correct?

        try67
        try67
        Community Expert
        September 17, 2020

        I would recommend not adding the fields in InDesign. They tend to be incompatible with Acrobat. Do it only in Acrobat for best results.

          A
          AlexandrePayreAuthor
          New Participant
          September 17, 2020

          Thank you very much for your swift reply!

           

          The issue is that I need to do a seating plan and create numerous fileds (200+). How am I supposed to automate this and ensure that the process is efficient? 

           

          Many thanks again.

          try67
          try67
          Community Expert
          September 17, 2020

          Can you share the files with us? Maybe use dummy data in the text file, if it's sensitive or private information.

            Terms & ConditionsAccessibility statement
            Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices