How to extract PDF Table into an excel file

Help Studio
,
1

One of the requirement is to extract Table from PDF and write those values into an excel file maintaining the headers

Table is expected to have 5 columns

Rows might vary - Either in one page or it could go to second and third page as well

We can assume that the Table is between 2 MAIN Headers. So Table would present anywhere between these headers

It would be great if someone could help on this scenarion

Please note that the user have StudioX license only

2

Any help on the above post??

@Anil_G @ashokkarale @Yoichi

3

@sharazkm32,

With StudioX it’s quite difficult I must say. You can try using Read PDF text with string manipulation.

4

I tried that. But hard luck

Is there any option in Studio without using Document Understanding?

1 Like
5

@sharazkm32

Did you happen to try loading pdf into excel?

The image shows an Excel menu under the "Data" tab with various data source options displayed, and the "From PDF" option is circled in red. (Captioned by AI)
The image shows an Excel menu under the "Data" tab with various data source options displayed, and the "From PDF" option is circled in red. (Captioned by AI)973×607 41.6 KB

cheers

6

@sharazkm32,

How about Autopilot for Everyone? Is it available and allowed?

Also checkout Clipboard AI

7

I will give a try and let you know

1 Like
8

Nope. Yet to migrate to latest version.

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.