exporting fields from fillable pdf into excel?

[annef20688461]

I have fillable pdf form that people complete.  I want to be able to export just the fillable fields into excel as a batch.  This was very easy in the old Acrobat "export data from forms" function.  I can't figure out how to do it using Acrobat DC.

[Thom Parker · Accepted solution]

It's still there, Use the tool search,

Also see this discussion

Re: Forms export to Excel

[shawnaa23052547]

I have adobe acrobat pro dc and I'm having issues with exporting filled forms into either a spreadsheet or database such as access? My overall plan is to take this created fallible form and have individuals fill it out send it back to me via email and then I pull that data into one of those sources. I'm just having issues with doing it.

[Thom Parker]

The easiest way to do this is to use the Distribute Form feature in Acrobat. You'll find it at the bottom of the left side fields panel in Prepare Form Mode.

[shawnaa23052547]

That doesn’t answer the question of how to put that data into a spreadsheet or database?

[Thom Parker]

Putting the data into a spreadsheet is part of the form Distribution and collection process.

However, if you want to just put the data into a spreadsheet, then use the options shown at the top of this thread.

If you have already tried these and they didn't work, then please explain what didn't work for you.

[shawnaa23052547]

Hello,

So the form that I have created is not a one time survey its a form that will need to be filled out several times and I need to somehow pull the responses from the fallible form into a spreadsheet or database. I tried to export and all it did was pull the whole form into an excel I would need it to fall into categories in an excel. I'm using Adobe D.C version if that makes a difference.

[heatherr36558381]

Hello,

This is exactly what I need to be able to do. Did you have any success?

[monmck]

I am a complete novice with Adobe Pro but I have managed to create a fillable pdf form.  I did not click on the 'Distribute' button when I created the form.  Should I have done this before I sent the form out for applicants to fill in and return? Now, I have the completed forms back , I seem to be able to export the data to Excel, but the fields are not filling in the Excel columns I've created with the same name. Any straightforward advice would be helpful. Thank you.

[try67 · Accepted solution]

You can't export the form data to an existing Excel file. You can use the Merge Data Files into Spreadsheet command to create a new file with all the data from the completed forms you got back from your users, and then import or copy it to an existing one.

[monmck]

Thank you so much try67. I've been struggling with this and your instructions were clear and they worked first time. Brilliant!