Link to home
Start Free TrialLog in
Avatar of Member_2_1316035
Member_2_1316035

asked on

Acrobat X Pro export collected files to spreadsheet

We have an interactive pdf that was designed in an older version of acrobat (8?).  It was set up to distribute and collect data.  The form contains fields that the users complete and a button that emails the form with the data back to our office.  We then have a separate pdf that is set up to collect all the user data.  It was very simple to import new form data, as well as to export all the data back out to an excel spreadsheet.

We recenly upgraded to Acrobat X Pro and seem to have completely lost all ability to import and export form data.  Need to find out how to at least export my exisitng data.

Thanks.
Avatar of yobri
yobri
Flag of United States of America image

On the right-side of the toolbar, you will see Tools button. Clicking on it will expose a right-side navigation pane. Underneath the Comment button in the toolbar will be a very small box, that when clicked will show Tools that are available -- make sure Forms is checked on this list. The Forms tool should now be available for you to click to expand its contents. Clicking the option More Form Options > Manage Form Data, you should see Import Data and Export Data options.
Avatar of Member_2_1316035
Member_2_1316035

ASKER

I don't see a Tools button.
How about going to View > Tools > Forms instead?
So you can see what I was referring to, I made a screenshot:

 User generated image
If I open just a regular pdf, I see the Tools button (Tools | Comment | Share).  But this is a dataset/datasource pdf that was designed to collect the returned form data.  The top panel of pdf looks like an inset of a table, with columns for the data fields, and each row contains the data that was submitted by a user.  The bottom of the form is the pdf the user submitted.  So as you click on diffferent rows, the bottom pdf updates.  

On this type of pdf, I only have one option, which is Share.

Does that make sense?
I don't have Tools as an option from the View menu.  I've looked everywhere and can't find any export functions.
I haven't a dataset/datasource PDF readily available to test so I'll see if I can get my hands on one to test and hopefully assist with a solution...

I've spent countles hours searching on the web with little luck.

Attached is an article that explains how I initially set it up in Acrobat 8.  I'm just surprised that the upgrade to Acrobat X Pro doesn't support these features.  I am starting to think that I need to reinstall the older version of the program.

http://www.adobe.com/designcenter/acrobat/articles/acr8at_distribform.html


I appreciate your help.
ASKER CERTIFIED SOLUTION
Avatar of Member_2_1316035
Member_2_1316035

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Not sure how to grade and award points. Basically no solution was found.
Not sure how to grade and award points.  Basically no solution was found.
Not sure how to grade and award points.  Basically no solution was found.