Power Query - Extracting Data from a PDF

Like (0) Share

Report

Posted on 17 Jan 2024 04:57:50 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 22 Jan 2024 at 01:24:05

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