beautypg.com

Creating a spreadsheet from form data, Excel. see microsoft excel, Spreadsheet of form data – Adobe Acrobat 7 Professional User Manual

Page 244: Creating from forms, Creating a, Spreadsheet from form data

background image

Creating a spreadsheet from form data

Once you've collected PDF form data in FDF or XML format from multiple users, you
can organize the form data into a comma-delimited spreadsheet file (CSV). After
exporting the form data to a CSV file, you can work with the data in a spreadsheet
application, such as Microsoft Excel.

Create a folder on your computer to contain the form data that you receive via

email; then, when you organize that data into a spreadsheet or need to review individual
responses, you can quickly locate all of the files.

To organize form data into a spreadsheet:

1. Choose File > Form Data > Create Spreadsheet From Data Files.
2. If you want to automatically include all forms and form data that you've previously added

to the Data Files list, select Include Most Recent List Of Files To Export Data From.

3. Click Add Files, select one or more files that have an .xml, .fdf, .pdf, or .xfdf file name

extension, and then click Select. Repeat this step if you want to add more files to the list.

4. If you want to remove a file from the list, select the file, and click Remove Files.
5. Click Create Spreadsheet.
6. Select a location on your computer to save the spreadsheet, and then click Save. The

Create Spreadsheet dialog box displays "Done" when Acrobat has created the spreadsheet.

7. If you want to open the spreadsheet file in your default spreadsheet application, click

View File Now; otherwise, click Close The Dialog.

This manual is related to the following products: