Extract PDF Data Table Into Excel Format

datatable
excel
pdf

#1

HI ALL!

I would like to extract a structured data table from a PDF document and put it into EXCEL. I have tried using the screen scrapping, [ read pdf ] and [ read pdf with OCR] to extract the table, but the result is not in the original table format or all data are pulled into one column.

Is there any way to extract out the whole data table and put it into excel?

Thanks a lot for the help!!

Below is a sample pdf document and the data table is in page 127 (Director Remuneration).
1367.pdf (867.2 KB)
Desired Excel Format:
1367R.xlsx (11.9 KB)


#2

Currently I am doing the conversion manually…


#3

How manually?

Do the same thing just with uipath…

let me know how you are doing it manually

cheers,
Radomir