How can you extract data from many pdfs into a excel

i have gotta a task where i have to extract data from 70 pdfs so can anyone tell me which topic will be better and how can I execute…

Hi @Jagjeet_Singh1

Welcome to community

Method 1 → Document Understanding

Have a look on the Video

Have look on the documentation

Method 2 → Regex and String manipulation

You can use Read PDF activity and using Regex method to extract the value from the pdf

Have look on the sample expression

If possible can you share the sample input and output file


Hi @Jagjeet_Singh1

Welcome to Community.

If you want to extract the data from 70 pdf’s with different template , you can use Ai Center with Document Understanding where you can “Data Label” all the templates and create a ML Model and Deploy in your workflow for extraction of the data.

Please find the links below.