Export PDF Form Data from multiple forms to Excel

[Guest]

Hello!

I am trying to export the data from multiple copies of the same fillable PDFs to an excel spreadsheet.  I would like the column headers to be the field names within the form, and each form's responses to appear in one row under the appropriate headers. This used to be a very simple task and I am unsure what changed recently to make this difficult.

When we export a PDF to Excel, it places a picture of each question in a new row along with the response. This is not helpful.

When we export form data, there is no option to export data to excel. We can export as a txt file, but I can not find where to define a delimiter (although it appears to be tab delimited?) I also can not find how to export multiple files at once into one file, or even find where the "export form data" option is without searching for it.

Does anyone know if there is a good way to do this in Adobe Acrobat DC, or thought another mechanism?

Thanks in advance.

[George_Johnson · Accepted solution]

In Acrobat, you'd select: More > Merge Data Files into Spreadsheet

when you're in form editing mode. This will allow you to select multiple files and will create a CSV file that includes the form data of each selected PDF.

When you export a filled-in form as text (More > Export Data > Text Files), it generates a tab-delimited file, but doesn't allow you to select multiple files. You can use JavaScript to export multiple files as tab-delimited though. This is what I prefer to do when I'm not using FDF instead.