Import list into pdf form

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

• Global community
  • Language:
    • Deutsch
    • English
    • Español
    • Français
    • Português
    Dedicated community for Japanese speakers Dedicated community for Korean speakers
    • Home
    • Acrobat
    • Discussions
    • Importing Data into PDF form
    Importing Data into PDF form /t5/acrobat-discussions/importing-data-into-pdf-form/td-p/9584934 Jan 08, 2018 Jan 08, 2018

    Copy link to clipboard

    Hello! I created a document that I would like to send to customers that has three fields that are specific to each customer. Instead of creating each pdf individually and manually typing the variable data, (there are thousands), I'm wondering if there is a way to import data from a spreadsheet into the three specific fields I created in the pdf form? I know you can extract data that customers entered, but can you populate data that way? Thanks in advance for the help!

    Community guidelines

    Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

    1 Correct answer

    Community Expert , Jan 09, 2018 Jan 09, 2018 Thom Parker • Community Expert , Jan 09, 2018 Jan 09, 2018

    Originally I thought you might just a few customers, in this case it's not a problem to create individual FDF files for each. But if you have a thousand, well then, you'll need a more automated technique, such as first import method I described, or the Mail Merge tool mentioned by Try.

    There are several variations on this tool, one that Acrobat installs into Outlook when it is installed. These tools are designed to fill out the entire form and mail it out, like you would a form letter or stateme

    7 Replies 7 Community Expert , /t5/acrobat-discussions/importing-data-into-pdf-form/m-p/9584935#M83669 Jan 08, 2018 Jan 08, 2018

    Copy link to clipboard

    Yes, there are a several different ways to do this, most of them involve scripting. But there a couple of manual methods that are suitable for handling a small number of options.

    1. Export the data from the excel spread sheet as a "Tab Separated File" with a .txt format. The column names in this file must match the fields names verbatim. Now, open your PDF in Acrobat Professional and start the "Prepare Form" mode. There is a drop down menu in the right side panel, on this menu is an "Import Data" option. Select this and then select ".txt" from the file open dialog. Acrobat will then ask you which line in the file to import the data from.

    2. Fill out the fields of interest (and only these fields) in your form for a single customer. Then in Acrobat Pro/Standard use the "Export Data" option in the "Prepare Form" mode to save the data as an ".fdf" file. Do this for each customer. Now you can import the data back into the PDF by simply double clicking on FDF file. Acrobat will automatically open the form in Acrobat and import the data.

    Thom Parker - Software Developer at PDFScripting
    Use the Acrobat JavaScript Reference early and often