Skip to main content
C
christina.towne
Participant
September 12, 2023
Question

Import data from Google Sheets to fill out a PDF form

  • September 12, 2023
  • 1 reply
  • 3475 views

I have a Google Sheet which holds course data such as Titles, Descriptions, etc. I'd like to populate multiple different PDFs with each course's data to export as datasheets. I thought I found a simple solution using Adobe Acrobat Forms: https://kb.foxit.com/hc/en-us/articles/13074358902292-Import-Data-from-Excel-Spreadsheet-to-PDF-Form

However, I do not see the form import option in Adobe Acrobat. 

I'm wondering if anyone else has found a solution to import standard fields of data and create PDFs from a single Google Sheet.

    This topic has been closed for replies.

    1 reply

    try67
    Community Expert
    try67Community Expert
    Community Expert
    September 12, 2023

    The link you posted is not about Adobe Acrobat, but about Foxit, a different company that has its own PDF viewer/editor.

    You can do it in Acrobat, but only one record at a time. Search for "Import Form Data" under Tools. You will need to save your spreadsheet as a text file first, though.

     

    If you want to import the data from an entire spreadsheet and generate multiples copies from a single template file you would need a script. This kind of operation is called a Mail Merge, and it can be achieved using this (paid-for) tool I've developed: https://www.try67.com/tool/acrobat-mail-merge-and-email-pdf-files

     

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