I need to extract structured data from a pdf and store it in excel. Normal data scraping and screen scraping don’t work. When I use read pdf activity i get the unsorted data, but i dont know how to manipulate it. I tried to use anchor base activity but i get only one record. I need to extract the …

Read PDF activity returns a string which needs additional processing to fetch the desired data. On the contrary, data scraping activity results in a datatable which can be manipulated easily. So can you share the error you encountered while using ‘data scraping’ activity? Because when i use ‘data …

Extract tabular data from PDF

Help

Mahesh_Gunda (Mahesh Gunda) December 3, 2019, 5:16pm 3

hi @dorai123

Can you retry ‘Read PDF Text’ activity with its property ‘Preserve Formatting’ set to ‘True’?

The resultant string looks structured and can be manipulated using ‘Text to Columns’ feature in excel. Forum

PDF Table format

Topic		Replies	Views
Extract Table data from PDF Help datatable , studio	19	16656	August 29, 2019
Extract only some columns in a PDF data table to excel Activities datatable , pdf , activities , data_scraping , question	2	1235	February 9, 2022
PDF to Excel - Extract structured data Help excel , pdf , activities , studio	14	8727	November 28, 2018
How to extract table from pdf Academy Feedback	23	14988	February 24, 2021
Extracting pdf to excel Help excel , pdf , activities , question	5	1328	December 6, 2019

Extract tabular data from PDF

Related topics