Skip to main content
Participant
August 3, 2024
Question

Extracting data from pdf based on selection

  • August 3, 2024
  • 2 replies
  • 1197 views

I want to extract some data in a pdf it has 44 pages and I want to extract some data based on selection when I select a any area in the pdf it extract it and then I want to write it into excel  

This topic has been closed for replies.

2 replies

try67
Community Expert
Community Expert
August 3, 2024

Do you mean you want to select an area on one page, and extract the data in that area from all the pages?

If so, that is possible, but will require the development of a custom-made script.

Karl Heinz  Kremer
Community Expert
Community Expert
August 3, 2024

Adobe Acrobat allows you to export portions of a document to an Excel spreadsheet: Highlight the text that you want to export, then right-click on the selection and select "Export Selection As..." - on the next dialog, you can then select what format to export to. 

 

 

Participant
August 3, 2024

In my case it is a very messy table and it is multiple tables in one page some of these its header is is in the same line and some its header it above it and all these tables are beside each other so when I try to use export to excel it read all the page as one table but it is not so I want to to select an area as in the prepare form and it extract what ever in it and I asked chatgpt and it told me to use the action wizard and choose add new action and select extract text in the document processing but I didn't find it