Extract table values from pdf in designated cells on excel spreadsheet

[Vortex99]

Hi all. Is there a way to automate (e.g. JS button) the process of extraction from table in pdf (entire pdf layout is created in Word, than saved as pdf and made fillable with Acrobat) to designated cells in Excel, where the table layout is different from the one in pdf?

Something like; first table field (top left) in pdf is text field named "Text1" and its' value has to go in C5 cell in Excel spreadsheet and so on.

Any help and guidance is much appreciated.

Thanks

[try67]

If you are talking about actual form fields, then yes, although it will require a script and it can't generate an Excel file but something like a CSV file or a tab-delimited text file, which in turn can be imported into Excel.

If, on the other hand, the table is just static contents it might be possible to do it with a script, but it will be much more complicated.

[Vortex99]

Thank you "try" for your super quick answer.
Yes, table fields are actual form fields. If it's not too much to ask, can you provide an example of how would such script look like?

[try67 · Accepted solution]

Well, you would need to write a script that collects the values of those fields into a string in the desired format and then writes that script to a "data object" (ie. a file attached to the PDF) and then exports it, so it can be saved locally.

The objects and methods needed to do all of that are documented in the Acrobat JA API Reference document, available here: https://www.adobe.com/devnet/acrobat.html

[Vortex99]

Thank you!