Learn how to a build a cloud-first strategyRegister Now


How can I extract data from a fillable .pdf file

Posted on 2009-02-09
Medium Priority
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?
Question by:kwylie
LVL 32

Accepted Solution

aleghart earned 2000 total points
ID: 23592545
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.

Author Closing Comment

ID: 31544583
We are using Adobe Professional, but it is version 6.  Still, I was able to get what I needed.  Thanks.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
New style of hardware planning for Microsoft Exchange server.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question