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

Import data from Google Sheets to fill out a PDF form

New Here ,
Sep 12, 2023 Sep 12, 2023

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.

TOPICS
Create PDFs , Edit and convert PDFs , How to , PDF , PDF forms , Rich media and 3D
2.6K
Translate
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 12, 2023 Sep 12, 2023
LATEST

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

 

Translate
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