Forum Discussion

FatinAmani's avatar
FatinAmani
Copper Contributor
Jan 17, 2022

Import PDF into Excel

Hello everyone, I'm trying to export some data from PDF format into Excel using my Microsoft Excel latest version. The problem is I do not know  how to select all page that shown here. I have almost 400+ pages, and it's hard to tick one by one. I hope there's an easy way to do it. 

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    FatinAmani Just select the first one and press Transform Data. Then, in the Applied steps, delete the Navigation step. This leaves you with the Source. Now you can simply filter all the Pages or all the Tables and expand

Resources