Managing PDF field data with Excel
Copy link to clipboard
Copied
Hello,
I have made a Acrobat PDF fillable form with multiple fields and intend on having individuals complete them on a daily basis, providing different information each time they submit the form.
I would like to extract the answers to specific fields and manage them on an excel spread sheet, not just getting an entire PDF. I have done this by completing the following:
Tools > Forms > More Forms Options > Manage Form Data > Merge Data Files into Spreadsheet
This is exactly what I wanted; however, it is not being completed in an order that I would like when I merge data into the spreadsheet. When I am in the button properties of the PDF select the fields that I would like to merge into the spreadsheet, there is no ordering option and, thus I get the data in random columns.
Is this possible on another Adobe application i.e. Livecycle or Acrobat XI, DC? Is there another way to complete this process?
Your help is greatly appreciated and please let me know if my narrative is not clear.
Copy link to clipboard
Copied
It can be done in Acrobat using a script.
I don't understand the screenshots you added, though. How is that related to your question?
Copy link to clipboard
Copied
I just wanted to be as clear as possible and thought a screenshot through the process would help.
I have learned to complete the form and merge data almost exclusively through Lynda.com, the past two days so it is safe to say that I am quite new at this. When you say script, I assume "JavaScript", which would include creating calculations?
Copy link to clipboard
Copied
But the screenshots are not of the process you described, and do something completely different...
Yes, JavaScript, but it has nothing to do with calculations.
![](/skins/images/8C4ECC496FF16CD8C5F10B75FDAEAD97/responsive_peak/images/icon_anonymous_message.png)
![](/skins/images/8C4ECC496FF16CD8C5F10B75FDAEAD97/responsive_peak/images/icon_anonymous_message.png)