Wednesday, August 14, 2013

PDF - Exporting data from the pdf to a spreadsheet

I've received a bunch of pdf files and I want to get the data out of the PDF form and into a spreadsheet.  

Fortunately the vendor that created the pdf files is using a pdf form, so the fields are not just scanned text, they're actual data elements.

The Adobe Acrobat XI website has an excellent description of how to import and export data from pdf files, here's the link that I got my information on:

Source for how to move data from PDF
Here's the excerpt I used, you have to have Acrobat Pro to do this.

Merge exported data files to a spreadsheet

If you want to compile data from forms that are not already in a data set, use the following process.
  1. Choose Tools > Forms > More Form Options > Manage Form Data > Merge Data Files Into Spreadsheet.
  2. In the Export Data From Multiple Forms dialog box, clickAdd Files.
  3. 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 Open.
  4. Repeat the previous step to add form data files that are in other locations, as needed.
  5. Click Export. Then select a folder and filename for the spreadsheet, and click Save.
  6. In the Export Progress dialog box, click either View File Now to open the spreadsheet file or Close Dialog to return to Acrobat.
How to get the data out of pdf to a spreadsheet