Power Query - Extracting Data from a PDF

(0) Share

Report

Posted on by Nofiana

I have a PDF document, lets say 100 pages for example, where 50 pages contain information I want to extract into excel format. The information i want is the client name and their address.

The position of the text want is relatively the same on each page. When I get data from the PDF, the formatting gets strange and the location is no longer the same on each tab representing the page.

Is there an alternative solution? Is power query the best way to do this?

All responses (1)

Answers (0)

Nofiana 4 on at

Like (0)

Report

Re: Power Query - Extracting Data from a PDF

I've attached an example of a PDF I am working with. I've removed some text but highlighted in yellow to indicate there was text there previously. I'd like to create a to pick up the beneficiary name, TFN and the input for the tax items e.g. A, A1, A2 etc.

Capture 3.GIF