Extract data from pdf and save in excel


#1

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

PdfData

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

LineItems-Update

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

How i do.


#2

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


#3

Hi,
it is not scan pdf its just simple pdf


#4

Then you can try if data scraping works :grinning:


#5

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


#6

Hi,
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