export from acrobat to excel

Question

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 · Answer

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/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded