Highlighted

export from acrobat to excel

New Here ,
Oct 22, 2020

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 ?Capture d’écran 2020-10-22 à 13.55.55.png

TOPICS
Edit and convert PDFs, How to

Views

22

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

export from acrobat to excel

New Here ,
Oct 22, 2020

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 ?Capture d’écran 2020-10-22 à 13.55.55.png

TOPICS
Edit and convert PDFs, How to

Views

23

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Oct 22, 2020 0
Adobe Community Professional ,
Oct 22, 2020

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/

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 22, 2020 0
New Here ,
Oct 23, 2020

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 23, 2020 0