Extract data from pdf and save in excel

I have to extract the data from pdf and save into excel in same format then how i do.
Here are sample pdf data.


I fetch data from pdf by using code and here is the result:-


and i want result in this way:-
Line Item-R.xlsx (8.4 KB)

How i do.

If it is scanned PDF, you can use Abby ocr engine. For which you need to buy separate licence.

it is not scan pdf its just simple pdf

Then you can try if data scraping works :grinning:

You can also use read PDF and generate data table, so that your output will be proper table format

1 Like