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


As you said that, this PDF document is not scanned and you wish to extract data from it. So, I would suggest you use an application program that can easily extract data from PDF. I know selecting the best utility is a quite complex task, therefore, I would suggest you use SysTools PDF Toolbox software. It is a multi-featured tool which can perform various operations. This tool provides the option to select the page numbers for data extraction purpose & once the data gets extracted you can save it in excel.

Visit the link : https://www.systoolsgroup.com/pdf-toolbox.html