Extract table data from a pdf to Excel

[Amrutha.mg]

I need to extract the table from the pdf as in the below figure, Kindly help me with this

[Enrico_N_F]

Maybe this can help. Use the solution there.

Extract Table from PDF to Excel without DU

Hello folks, I am trying to get this table data from PDF to excel using activities and not Document understanding. This is the sample data, similarly there are many more files. Single FIle Sample.pdf (390.4 KB) I am using: 1 . Read PDF Text to get the string text. 2. Using string manipulation. 3. Generate Data Table to convert that to Data Table 4. Write range to write the data to excel. I am not able to get the values in structured format as it is in PDF, can anyone help me with that …

[Anil_G (Anil Gorthi)]

@Amrutha.mg

Did you try with document understandingb and using any out of box ml models?

Cheers

[sanjayva (Sanjay Valiyaveettil)]

There is a built in feature of Excel that is able to extract structured data from a PDF. Here are the steps:

• Open MS-Excel and click on Data > Get Data > From File > From PDF
  

• The next page will giv you options to load the entire page or sub tables depending on the data you have. Select the appropriate table and click Load.

This will load the data into the excel. If this works for you, then you can save this excel as a template and store the PDF file along with the template.

You can have your UiPath automation read the table.

When you need to update the data, simple copy the PDF file to where the template file is kept and use the refresh data activity and it will update the Excel file with the data from the PDF.