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

Managing PDF field data with Excel

New Here ,
Jan 08, 2018 Jan 08, 2018

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.

Capture1.PNG

Capture3.PNG

Capture5.PNG

TOPICS
PDF forms

Views

490

Translate

Translate

Report

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 ,
Jan 08, 2018 Jan 08, 2018

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?

Votes

Translate

Translate

Report

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
New Here ,
Jan 08, 2018 Jan 08, 2018

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?

Votes

Translate

Translate

Report

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 ,
Jan 08, 2018 Jan 08, 2018

Copy link to clipboard

Copied

LATEST

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.

Votes

Translate

Translate

Report

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