Mapping PDF fields to Pre-Defined Excel

Question

I am looking for the best way to convert data from an editable .pdf into a pre-defined .xls spreadsheet.

Details:

- The editable .pdf is an Application which users complete by completing the form.

- The entire .pdf is broken into 14 actual files

- The user sends the completed .pdf files into company for verification and validation.

- Company has an excel spreadsheet which contains all the fields for the data supplied in the submitted .pdf.

- Currently, Company workers manually transfer the data from the submitted .pdf into the pre-formatted .xls

So I am looking for a tool that allows me to define a source file (the submitted .pdf) and a destination file pre-defined .xls) then define: (ex)

- First Name field on the .pdf goes to First Name field in .xls template

- Last name field in .pdf goes to Last Name field in .xls template

- Etc… throughout the remainder of the document

Adobe Acrobat does not have the functionality to map field to field during the conversion. Any ideas on simple ways to accomplish this? Are there any 3rd party tools that might support this functionality?

Tariq Dar · Answer

Hi sarar43665049,

Sorry for the delay in response.

For Acrobat there is not much that can be done to export the data as you expect: Collecting and managing PDF form data, Adobe Acrobat

However, if you have LiveCycle form you may try this: https://acrobatusers.com/forum/forms-livecycle-designer/automatic-export-form-data-excel/

Let us know if that helps.

-Tariq Dar.

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