Import PDF into Excel

Occasional Visitor

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. Screenshot (54).png

2 Replies
If you send a copy of the pdf file to me at dougrobbinsmvp[atsymbol]gmail[dot]com, I will see what I can do with it

@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