Extract info from a variable length pdf and dump to Excel

[SimonHughes]

For each item we test (and there could be one, 50 or 500 items to test, this number is fully variable) we create a two page report which is automatically generated as a pdf. So the full pdf could well be 1,000 or even 2,000 pages long.

The report has a header with nine labeled pieces of information (contained in two columns - see below) which I want to extract and dump into an Excel table in the style shown below. Can anyone tell me if this can be done and if so, how would it be done.
Many thanks in advance

 

[BSALV]

As you have 365, you can read (parts of ) a pdf into excel.
There are lots of videos about that.
So you can try that first manually.
If that works, you can try to automate that, but as you say your pdf is 1,000 pages ???

 

[SimonHughes]

As you have 365, you can read (parts of ) a pdf into excel.
There are lots of videos about that.
So you can try that first manually.
If that works, you can try to automate that, but as you say your pdf is 1,000 pages ???

All sorted now thank you. Yes, the report could be 10 or 1,000 pages long, it's just the way it is.