Exporting PDF form data into an excel spreadsheet

Question

hello, your help would be greatly appreciated. I have created a form for our membership that they will fill in and email back. i would like to be able to then somehow export the POPULATED data into an excel spreadsheet. i am using Acrobat 9 and Office 2007. Is there a way to do this? thank you. julie

MichaelKazlow · Answer

Did you search the help files for information? The following is from the manual that came with Acrobat. It is really a wonderful resource:

If you want to compile data from forms that are not already in a data set, use the following process.

Choose Forms > Manage Form Data > Merge Data Files Into Spreadsheet.
In the Export Data From Multiple Forms dialog box, click Add Files.
In the Select file Containing Form Data dialog box, select a file format option in File Of Type option (Acrobat Form Data Files or All Files). Then locate the form files that you want to merge into the spreadsheet, select them, and click Select.
Repeat the previous step to add form data files that are in other locations, as needed.
Click Export. Then select a folder and filename for the spreadsheet, and click Save.
In the Export Progress dialog box, click either View File Now to open the spreadsheet file or Close Dialog to return to Acrobat.

Note: When returned forms are in a response file, the most efficient way to export the information into a spreadsheet is to use the Export Data button in the left navigation panel for the PDF Portfolio response file.

To get the above and other useful data, open the user manual from the help file and search on: "form data"

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded