Once you have such a file, you can use the Acrobat JavaScript method Doc.importTextData() to import one record at a time (just like we did manually before). The key to importing data from an Excel file is that you need to export the data as a “tab delimited text file” – just like described in the question I linked to above. If that does not work, trying to automate this step will also fail. The following gives you an idea about how to do this using JavaScript.Īnything I said about importing data manually in the link above is still true, so get familiar with the manual process and verify that you can actually import one data record from your text file into your PDF form. There must be a way to automate this…Īnd, there is.

This is very useful if you only have to deal with one or a few records that you need to import into PDF forms, but what if we are talking about 10s or 100s of records? It gets a bit boring to click on the same buttons again and again. You can find this information here: Can I import data from an Excel spreadsheet to a fillable PDF Form? A while ago I documented for how to manually import an Excel data record into a PDF form.

Import data into pdf form