Skip to main content
T
tc66951815
Participant
January 19, 2016
Question

How do I combine multiple pdfs and then export the data into an Excel table

  • January 19, 2016
  • 1 reply
  • 693 views

I have to send a fillable pdf file to 100+ customers. They have to fill our a form with information such as their first name, last name, age, gender, occupation, etc. They will send these pdfs back to me. How do I export that data, from 100+ different pdf files into a single Excel spreadsheet?

Thanks!
-T

This topic has been closed for replies.

1 reply

try67
Community Expert
try67Community Expert
Community Expert
January 19, 2016

In Acrobat: Tools - Forms - More Form Options - Merge Data Files into Spreadsheet...

You should not merge those files into a single PDF, though, as that will remove all of the date in all of them except for the first one.

If you want to merge them you have to first flatten them.

T
tc66951815Author
Participant
January 25, 2016

Hey,

It didn't quite work.

On each form there could be more than one name. So Row 1 has info client Bob. Row 2 has info on client Carol, etc. When I export the data. Carol's info shows up in the same row as Bob's, I would want her info to show up in a new row. Any thoughts?

Thanks,

T

try67
Community Expert
try67Community Expert
Community Expert
January 25, 2016

That would require a custom-made script and Action to implement in Acrobat (Pro), or you could do it using a Macro or something like that in Excel.

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