Forum Discussion
FatinAmani
Jan 17, 2022Copper Contributor
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_EekelenPlatinum 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
- 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