Extract pdf table data into an Excel


Hi All,

I am new to UIpath and working on a project where i have to extract table data from pdf to excel. I have tried using Data scrapping and screen scrapping options as well but i could not get the output .

I have gone through similar articles in forum .

But i could not understand the logic.

Can someone help me out to implement the logic in simpler manner .

Attaching the sample PDF for your reference .

sampledata.pdf (110.8 KB)

Much appreciated your kind help and support .

Thanks again .


What you want to extract in this PDF.?


I would like extract table data from the PDF .

Attached screenshot for your reference .


Main.xaml (11.4 KB)
Hi please find the solution here we have 5 array with speed, driver, car, engine and Date and there is a build data table, all you need is loop each array and add data to data table.


Hi Divya,
I want to get the data into CSV in a tabular format.

Currently i tried with excel but i got all the data in single cell. Attached the sheet for your reference.

sample.xls (8.8 KB)


if you create a proper data table you can write it to either excel or to csv that doesnt matter


Hi Sailaja,
Main (1).xaml (17.6 KB)
As per your requirement to store in both excel and csv.



Thank you . I am able to extract data from the sample PDF attached .

But i am unable to extract from other PDF . Have changed all row columns and variables according to other pdf. Could you please help me out on this?


Attaching the PDF .


Would like to extract this …

I have changed the substring values according to the data in the PDF . I am only able to extract Required content not column wise.

Please help out on this.

Appreciate your kind help and support.


How can we Extract Data from a Table in PDF if we are not aware of the number of rows.