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

form data into spreadsheet

Forum Index > Forms: Acrobat > form data into spreadsheet
2008-05-23 07:49:28
chas1994
Registered: May 23 2008
Posts: 4

Hi there,
I started using LifeCycle Designer 8.0 and I want to import and aggregate form data into an Excel sheet: I am using acrobat pro 8.0. The tutorial says:
--------
Collecting the data in a spreadsheet
You can use Acrobat Professional to consolidate the information from the returned files into a spreadsheet, such as Microsoft Excel.
1. Start Acrobat Professional and open the form you saved in the previous section.

2. Choose File > Form Data > Create Spreadsheet From Data Files.

3. Click Add Files and locate the XML file that you emailed.
-------
File > Form Data > Create Spreadsheet From Data Files' does not exist How do you do that in version 8.0
Also the data returned is in xml format. How can that go into Acr. Pro?
Thanks,
Chazz

My Product Information:
Acrobat Pro 8.1.2, Windows
Top
2008-05-28 15:32:26
#1
sunnydu
Registered: May 28 2008
Posts: 3
To get the returned data back into Acrobat Pro:
1. Save the data to a location where you can easily find it.
2. Open the form you want the data imported into
3. Choose Forms>Manage Form Data>Import Data...
Top
2008-05-29 01:36:51
#2
chas1994
Registered: May 23 2008
Posts: 4
Thanks, I appreciate your help; that works fine. However, what I really want to do is to append the incomming data to a spreadsheet. Right now, I use the excel xml import facility. Does anybody know a better, more efficient way to do that?
Top