Import data from pdf to excel


I want to use this feature of MS excel. Is there any way to use this in UiPath via any activity or by hitting an endpoint that returns datatable? Waiting for the help! Thanks.

Hello @Umer_Shahid
You can use the Excel file as a template with the Power query and place it in a specific location.
The Excel Get data from the specific PDF in a specific location. Keep the location Constant.
Each time Move the PDF file to a specific location and specific name.
Copy the template file from the template folder and place it in the Work folder then refresh the Excel file. The data will append to it. Later you can use the excel file in your process.

1 Like

Can you provide me with the power query to extract data from pdf?