Extract table from PDF into EXCEL

[ELISA_ARTALEJO_BARINAGA (elisa_)]

Hi to everyone!

I’m trying to read a table from a PDF file and put it into an Excel. How can I take only the table from the PDF?

Thanks!

[RK_0 (RK)]

Hi,

Can you share a screen capture of the pdf if possible?

What methods have you tried such as data scraping or table extraction or something else?

[RK_0 (RK)]

Hi,

Refer to this video from timestamp “12:30”

UiPath Video Tutorial for PDF (extract Tables from PDF)

[Rounak_Kumar1 (Rounak Kumar)]

Hey,

try with Read PDF text to get value in String
then Use generate Data Table activity so it will convert string to data table
i hope it will work

Thanks

[william_joe]

How to copy data from a PDF to Excel
Open the PDF into Word. …
Convert the document and click “Enable Editing”
Copy the data from the document.
Open the correct Excel spreadsheet.
Paste the data into Excel.
Format the information. .
Title and save the spreadsheet.

Regards,
Will

[Ralph_Sena26 (ralph sena)]

@RK_0 Can you please provide an approach for the below table in PDF and transfer it to excel?

[Ralph_Sena26 (ralph sena)]

Master @Yoichi, do you have an approach for this scenario?

[Yoichi]

Hi,

If you can use DocumentUnderstainding, it will help you.
If not, can you try to read it using ReadPDFText activity then extract each data with string manipulation.
It may be better to raise a new topic attached the pdf file.

Regards,