We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Acrobat X Pro export collected files to spreadsheet

Member_2_1316035
on
Medium Priority
674 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question

Top Expert 2011

Commented:
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.

Author

Commented:
I don't see a Tools button.
Top Expert 2011

Commented:
How about going to View > Tools > Forms instead?
Top Expert 2011

Commented:
So you can see what I was referring to, I made a screenshot:

 Screenshot of Acrobat X Pro

Author

Commented:
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?

Author

Commented:
I don't have Tools as an option from the View menu.  I've looked everywhere and can't find any export functions.
Top Expert 2011

Commented:
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...

Author

Commented:

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.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Not sure how to grade and award points. Basically no solution was found.

Author

Commented:
Not sure how to grade and award points.  Basically no solution was found.

Author

Commented:
Not sure how to grade and award points.  Basically no solution was found.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.