Extract data table from PDF to Excel

datatable
excel
pdf
#1

Hi there,

I’ve been searching the forum for a similar issue but without any luck. Please point me in the rigth direction if this issue has already been resolved.

I am trying to extract readable data from a table in a PDF-file to create a similar (but editable) Excel table (see the screenshot below).

I am able to read the data with the Read PDF text acitivity but I am not sure how to proceed from here in terms of converting it to a data table and creating an Excel file with a structured table. I get stuck when passing the output variable between the read and write range activities.

I am still a rookie in UiPath so please be elaborate in your replies.

Thanks in advance.

Capture.JPG757x535 79.1 KB

#2

As you mentioned its Native pdf then use “Data Scraping” wizard .
It directly give you output in datatable which can be used in excel.

#3

I’ve tried that but for some reason I get the error: “This control does not support data extraction. Please select a table cell” regardless of what cell in the table I select.

Reading pdf data into excel
#4

could you please attach the pdf.

#5

Sure, thank you.

dno_common_network_asset_indices_methodology_v1.0_0.pdf (1.9 MB)

#6

similar issue for me when i tried to extract the structured data from the pdf :frowning:
error: This control does not support data extraction
@badita can you please guide/help us?

#7

Hello @Mattis,

Where you able to solve this? If yes, can you please help me out too. I have to extract a table ranging multiple pages into an excel sheet.

#8

Is it possible to extract data from pdf & create excel in another way