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

[tc66951815]

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

[try67]

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.

[tc66951815]

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]

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.