PDA

View Full Version : Extract Data from PDF to Excel in a format



hawk_eyes
10-07-2019, 12:26 AM
Hi all,

I wanted to get a way to extract specific data from a pdf file to an excel file in an appropriate format.

From the attached files, I want to extract the data from the pdf file as per columns (labelled) in the excel file. There 756 pages in the pdf one sample is as per the image attached

Thanks to help.
2523825239

Kenneth Hobs
10-07-2019, 11:12 AM
Welcome to the forum!

Without seeing the pdf, I don't see anyway to help. Even then, you will likely need Acrobat, not Adobe Reader, to do it if it is even possible.

paulked
10-07-2019, 12:47 PM
There are ways of converting the PDF into a usable table first. Have a look here https://www.economicsnetwork.ac.uk/tips/pdf2excel