Hi All, I have a PDF file, which has content in tabular format. I need to exract this into an excel sheet. Is there any way to automate this in UI path As I have multiple PDF files to extract like this. Please advise.

Hi @SailuKrish Welcome to the UiPath Community! We’re glad to have you here. For your concern, please refer to this post: [image] Convert table from PDF to Excel Help HI @nithin2304 , Refer this posts Regards, Arivu Hope this helps. Thanks and regards

Hello @SailuKrish , You will need to use “Data Scraping” method which enables us to extract structured data from web application, document etc. Thanks, Pankaj

Datascariping is not working…

Please reply me… Thanks, Sailukrish

Please find the sample pdf format. Already used screen scraping and data scraping but I didn’t get required output. Name date description time Sass 10/01/2018 gfdyjhf 8.00 Ffdyjj Gfhhh Kkkk 15/02/2018 jtesgyjj 7.00 Gggh High 18/03/2018 ghjjkkh 4.00

Hi @SailuKrish Is ffdyjj and Gfhhh names? Then they do not have date, description and time? :slight_smile:

No.It’s a description, that is in multiple lines… Thanks, Sailukrish

So what you need are those 3 lines with complete details? :slight_smile:

Yes… I need to extract entire table it has number of records like this… Already i used read pdf with ocr text and I get entire pdf data is stored in string variable. After that what can I do to retrieve the table data to excel. Thanks, Sailukrish

Extract PDF table to excel

Help

Jan_Brian_Despi (Jan Brian Despi) May 21, 2019, 10:13am 2

Hi @SailuKrish

Welcome to the UiPath Community! We’re glad to have you here.

For your concern, please refer to this post:

Hope this helps.
Thanks and regards

Topic		Replies	Views
Extract data from PDF(vertically) Help excel , uiautomation , pdf , studio	14	2078	October 10, 2019
Exctract table from pdf to excel Studio	3	2603	February 28, 2021
Date extract error PDF to Excel Activities datatable , excel , selector , database , uiautomation , pdf , mail , activities , data_scraping , web , string , question	10	1249	February 16, 2023
Scraping8 Activities activities , question , script	7	568	October 17, 2023
Extract PDF tabular data and save to excel Certification pdf	11	2365	February 28, 2021

Extract PDF table to excel

Related topics