We help IT Professionals succeed at work.

How can I extract data from a fillable .pdf file

Medium Priority
3,245 Views
Last Modified: 2012-05-06
We will be receiving a large number of .pdf files that have been filled in and emailed to one of my users.  Is there a way for me to take all the .pdfs and extract the data from the fillable fields into something like an excel spreadsheet?
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Did you look in the help file?  Or are you only running Acrobat Reader?
First step, contact the person who created the fillable form.
If not available, you need to buy a license for the full version of Acrobat.

From the help file: (v9.0)

--Collect user data
After a user submits a form, open the returned form.
In the Add Completed Form To Responses File dialog box, select one of the following:
Add To An Existing Responses File Compiles the data in the response file that was created when you used the Distribute Form wizard to send out the form. (If necessary, click Browse and locate the response file.)
Create A New Responses File Creates a new response file, using the name and location you specify.
The response file opens after you click OK. Each returned form added to the response file appears as a component file of a PDF Portfolio.



--Compile form data
In Acrobat, choose Forms > Compile Returned Forms.
In the Compile Data dialog box, do one of the following to select a PDF response file:
Click Browse, and then locate and select the response file.
Type the path to the response file.
Click Add File, and navigate to the returned form.
Repeat the previous step as many times as necessary to add more returned forms.
After you click OK, the data from the selected forms is added to the response file. Each returned form appears as a component file of a PDF Portfolio.


--Export user data from a response file

Use this process to save all the entries in a PDF Portfolio response file to a spreadsheet or XML file.

In Acrobat, open the response file and select the data to export.
In the left navigation panel, click Export.
In the Select Folder To Save File dialog box, specify a name, location, and file format (CSV or XML) for the form data, and click Save.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
We are using Adobe Professional, but it is version 6.  Still, I was able to get what I needed.  Thanks.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*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.