Extract table from PDF into EXCEL

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! :slight_smile:

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?

Hi,

Refer to this video from timestamp “12:30”

1 Like

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

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