Organizing data from multiple PDFS into a spreadsheet

[RSells32]

Hello! I'm trying to figure out a way to combine data from multiple pdfs into one datasheet. The PDFs are all the same, but have answers from different respondents. For example, one field is their name and their department. After getting 100 of these pdfs with their answers how can I organize all of the data into spreadsheets in order to avoid having to manually input them?

Thanks in advance!

[DelphiZoa]

Hi RSells32,

The only way I can think to do it would be to combine the pdfs into a single PDF using "Combine Files" in the right menu in Adobe Acrobat. You can then convert the combined binder to Excel by selecting "Export PDF" in the right menu and then choosing spreadsheet. After conversion, you might have to go into the spreadsheet and do some manual clean up if you have headings on each pdf, but that's still a lot easier than entering 100 pages worth of data by hand.

[DelphiZoa · Accepted solution]

This might offer a more elegant solution than my cobbling together method. I haven't tried it, but check it out to see if it would serve your needs: Merging Data from Multiple PDF Forms into an Excel Spreadsheet​.