Copy link to clipboard
Copied
Hi,
i'm looking for export from acrobat to excel.
We would like to distribute to a lot of people (more that one hundred) registration forms, and then we would like to compile informations from all registration forms.
Itried with one file, and it worked, but i don't know how to extract a better form for the data, could you help me please ? How to treat fils to convert data as usable data ?
Copy link to clipboard
Copied
Take a look at this recent question, which asks about getting data from mulitple forms into Excel:
https://community.adobe.com/t5/acrobat/forms-file-data-extraction/m-p/11529186?page=1#M282603
You could use the same mechanism to read the form data into an unformatted Excel document. In a second step, you can then create Excel macros to put the data into the right format.
As an alternative, you can write a VBA script to process the forms directly in Excel by extracting the data from the form on a per form basis. Take a look here for some information: http://khkonsulting.com/2010/09/reading-pdf-form-fields-with-vba/
Copy link to clipboard
Copied
Thanks a lot, that's what i'm looking for.