Can I import data from a fillable PDF Form to an Excel spreadsheet?

I am trying to currently import data from multiple fillable PDF's that are filled in to an excel spreadsheet. I was wondering if this can be done and if so how?

I would like each fillable field in a PDF to have its own column in one excel spreadsheet.

I also have multiple PDF's that need to be transferred over to excel. (would be great to do this an automated way so I don't have to do one at a time)

The ideal solution would transfer each PDF to one unique excel spreadsheet inside a workbook and there would be multiple spreadsheets in the workbook.

If you're reading this, thank you for taking the time.

Michael Nguyen

Voted Best Answer

Do you have Adobe Acrobat? If so, select "Tools>Forms>More Form Options>Merge Data Files into Spreadsheets". This way, you can select all PDF form files, and you can export everything into one spreadsheet.

If you want to do this on a per-file basis, you can use the same menu, but then use "Export Data". You would have to do this on a per-file basis. You can however automate this by writing JavaScript and then use the Doc.exportAsText() method to write out a CSV file that can be loaded in Excel.

Karl Heinz Kremer
PDF Acrobatics Without a Net
PDF Software Development, Training and More...
http://www.khkonsulting.com

By Karl Heinz Kremer

Within this topic

Can I import data from a fillable PDF Form to an Excel spreadsheet?

Voted Best Answer

Browse more answers