Auto populating a fillable PDF from an excel file

Question

I have a fillable PDF and I want to modify the form fields so that I can auto populate data from an excel file. I have a data sheet that needs entering each month and, if I can get this set up correctly, it will save me a lot of time! There are a total of 7 rows on the excel file and, each month there would normally be no more than 20 columns. I've got as far as 'preparing a form' in adobe acrobat - I've tried changing a couple of form fields and then importing data from the Excel file but it's not working and I can't work out what I'm doing wrong.

Any help would be greatly appreciated!

try67 · Answer

You must save the Excel file as a tab-delimited file first (this can be done in Excel), and it must have the correct structure to be imported to your PDF file, meaning the first row must contain the field names, and the rows after that their corresponding values. You will only be able to import one row at a time, though, unless you use a script to perform a Mail Merge command.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded