export from acrobat to excel

[ralphm55625938]

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 ?

[Karl Heinz Kremer]

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/

[ralphm55625938]

Thanks a lot, that's what i'm looking for.