These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Extracting form data to spreadsheet - Acrobat 9 Pro Extended

lpacini
Registered: Mar 13 2009
Posts: 29
Answered

I need to know how best to extract form data to a spreadsheet. First, I have searched the forum and the most recent thread that I found on the topic is two years old! I presume that Adobe has advanced this function since then!

Forms are returned by email and sorted into folders in Outlook. The recipient of the email will have Reader v9. The next step in the workflow will be to capture the data in an Excel spreadsheet. Where do I begin???

Thanks a million in advance!!

Lauren

My Product Information:
Acrobat Pro Extended 9.1.1, Windows
utcmk
Registered: May 14 2009
Posts: 2
After you complete your form in LiveCycle designer, distribute the form and choose "manually collect responses in my email inbox" in the dialog box that comes up. As the replies come in and you open them, Acrobat will automatically recognize that they are forms that have been filled and returned and will offer to create a responses file. As the responses come in and you open them, just have the data sent into the proper response file. The data can be seen, filtered, and exported from this response portfolio file as a .csv file or .xml file. You can have multiple response portfolios for different forms you may be sending out and the portfolio files will contain not only the data, but you can view the form just as it was filled out and print it if necessary. The response portfolios are also archivable.
lpacini
Registered: Mar 13 2009
Posts: 29
Thanks a million! It certainly sounds straight forward. Are there any pit-falls along the way of which I should be aware? I am new to Acrobat 9PE and interactive forms. I can't wait to get started.

Lauren
lpacini
Registered: Mar 13 2009
Posts: 29
I meant to ask...

Is LiveCycle included in Acrobat 9 Pro Extended or do I need to purchase that separately?

Again... THANKS!!!

Lauren
utcmk
Registered: May 14 2009
Posts: 2
LiveCycle designer is included in the Windows version of A9PE but is not available at all for Mac. You should see it on your Programs list right below Acrobat. You can also launch it from within Acrobat by starting the forms wizard from the Forms menu. As for pitfalls, I too am just getting up to speed with the upgrade. In my limited testing so far it seems to work very nicely.
nixopax
Registered: Feb 6 2009
Posts: 105
Acrobat 9 Pro Extended is a Windows Platform only version, and LiveCycle is included.

To get to it, start your form wizard. [img]http://img29.imageshack.us/img29/6228/livecycle.jpg[/img]

edit: whoops, in the time I read the thread and responded, you beat me to it utcmk =)
lpacini
Registered: Mar 13 2009
Posts: 29
Thanks everyone for your helpful input!!!

Lauren
'