Skip to main content
RSells32
RSells32
Participant
January 25, 2019
Answered

Organizing data from multiple PDFS into a spreadsheet

  • January 25, 2019
  • 2 replies
  • 538 views

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!

This topic has been closed for replies.
Correct answer DelphiZoa

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

2 replies

DelphiZoa
DelphiZoaCorrect answer
Participating Frequently
January 25, 2019

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

DelphiZoa
DelphiZoa
Participating Frequently
January 25, 2019

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices