Skip to main content
M
Matthew305057777chp
Participant
June 14, 2023
Question

Import excel table into PDF

  • June 14, 2023
  • 3 replies
  • 2402 views

I am looking for support with importing data from an Excel (table) column to live update a PDF. 
We generate lists every quarter and the winners needed to be updated by grouping. We currently copy and paste over 100 times to complete the task. I am looking for a method to automate.
Thank you! 

 

 

    This topic has been closed for replies.

    3 replies

    M
    Matthew305057777chpAuthor
    Participant
    June 22, 2023

    Taking the advice from the replies, you're right.... It his harder to add live text to an already existing PDF. What I've done, is recreated the PDF template, formatting and all, in excel and the use the 'Save as PDF' option for all citites.

    T
    Test Screen Name
    Legend
    June 14, 2023

    Much simpler, I suspect, to use Office automation to take the live data and combine it with a Word template. This can be converted to PDF as required. Most things are harder to do once you already have a PDF.

      bebarth
      Community Expert
      bebarthCommunity Expert
      Community Expert
      June 14, 2023

      Hi,

      Did you try "Import Data..." of the "Prepare Form" tool?

      You need to save the Excel sheet in .txt file format and the title of each column need to have the same name as the corresponding field.

      Else, that can be done via a script.

      @+

        M
        Matthew305057777chpAuthor
        Participant
        June 14, 2023

        I do not see an import function at the moment on my existing PDF. Is there a method to 'add' this function? 

        Also, if you do have a smaple scritp I would love to review it. 

        Thanks for the support. 

        M
        Matthew305057777chpAuthor
        Participant
        June 14, 2023

        I am using Adobe Acrobat PRO with the ability to combine, edit etc. 

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