+ Reply to Thread
Results 1 to 4 of 4

Managing PDF data with Excel

  1. #1
    Registered User
    Join Date
    09-30-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft Office 2010
    Posts
    10

    Managing PDF data with Excel

    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?

    Your help is greatly appreciated and please let me know if my narrative is not clear.
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Managing PDF data with Excel

    This seems like an Adobe issue not an Excel issue, not sure you will find much help here regarding that. My guess would be it follows some order according to the fields order (some numbering/order determined by Adobe when the fields are created and/or a property of the fields). If its an exposed property you may be able to adjust it for each field to the order you like, if not you may have to shuffle the columns after as you see fit and/or resign the form to follow your desired order.
    Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.

    "I am here to help, not do it for people" -Me

  3. #3
    Registered User
    Join Date
    09-30-2017
    Location
    Toronto, Canada
    MS-Off Ver
    Microsoft Office 2010
    Posts
    10

    Re: Managing PDF data with Excel

    Thanks. I posted the question in the Acrobat Community Forums in hopes of getting a response.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Managing PDF data with Excel

    Set Tab Order to Order Tabs Manually (or any other) and test it
    but this is not Excel problem

    You can order fields based on the structure, rows, or columns. For most forms, click Tab Order and choose Order Tabs by Structure as Acrobat X does a good job of ordering for you.
    If you want to change the order manually, click and drag the field in the Fields pane. You'll see the field's number change on the page.

    or

    from the left side select Order
    order1.jpg

    then drag and drop to set order as you wish. It doesn't change place of fields in your file but change priority only to exapoert in choosen order
    order2.jpg
    Last edited by sandy666; 01-08-2018 at 01:16 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Managing Data on excel
    By S2000 in forum Excel General
    Replies: 17
    Last Post: 03-29-2014, 05:41 PM
  2. Programming approach: managing external data with an Excel application
    By Alex Simmons in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2013, 08:11 PM
  3. Help managing data across sheets
    By storeyboy10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-11-2010, 08:02 AM
  4. Managing Data
    By DGillham in forum Excel General
    Replies: 5
    Last Post: 11-02-2007, 11:11 PM
  5. Help with managing data. Complicated one!
    By wizard007 in forum Excel General
    Replies: 5
    Last Post: 05-02-2007, 09:11 AM
  6. Need help managing a list of data........
    By madmanmac in forum Excel General
    Replies: 2
    Last Post: 04-17-2007, 09:41 AM
  7. Managing bad data
    By hasn7 in forum Excel General
    Replies: 2
    Last Post: 05-18-2006, 06:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1