My current issue is a file a vendor is sending splits each page into its own table, so I have a file with 79 tables, and Power query wants to put each on on its own worksheet in excel. I just want it all in 1 single table. Haven't figured that out yet.
Spent a big portion of the weekend learning Power Automate Desktop Flows and RegEx to try and scrape data from PDF's. The solution is this! If only I found this 24h ago :-)
Love your tutorials! Question though... my pdf files have multiple tables over about 3 pages and it doesnt allow to select multiple... how do you get all of them to import into power query?
Nice. Could you do a tutorial where a PowerQuery extracts the entirety of a PDF of varying page length into Excel dynamically? In other words, without specifying each time how many pages the file has. It's a nice functionality to embed into a VBA subroutine.
Thank you. I loaded table 1 and table 2. How do I remove header/titles row from table 2 so that the header doesn’t repeat when both tables are combined in one tab? There is no delete row option after the tables are uploaded. I can only hide or group rows
Hi Chester, Sad news a recent Windows update has removed the from PDF option in Get data. This has affected Excels on 2019 & O365. 😢 Do you know if there is a way around this?
My current issue is a file a vendor is sending splits each page into its own table, so I have a file with 79 tables, and Power query wants to put each on on its own worksheet in excel. I just want it all in 1 single table. Haven't figured that out yet.
When you want to load multiples pdf files and each PDF has mutiples tables, it does not work. Power Query seem to load only 1 table from each PDF
having the same issue. Were you able to find a solution?
Spent a big portion of the weekend learning Power Automate Desktop Flows and RegEx to try and scrape data from PDF's. The solution is this! If only I found this 24h ago :-)
Brilliant! Saved me time not having to spin my wheels for hours.
This is great. I have a quick question, what about if the table is located on different pages of the PDF?
Thanks Chester, this video has been really useful.
Love your tutorials! Question though... my pdf files have multiple tables over about 3 pages and it doesnt allow to select multiple... how do you get all of them to import into power query?
Nice. Could you do a tutorial where a PowerQuery extracts the entirety of a PDF of varying page length into Excel dynamically? In other words, without specifying each time how many pages the file has. It's a nice functionality to embed into a VBA subroutine.
Thank you. I loaded table 1 and table 2. How do I remove header/titles row from table 2 so that the header doesn’t repeat when both tables are combined in one tab? There is no delete row option after the tables are uploaded. I can only hide or group rows
Very useful, much appreciated Chester!
Has the from folder moved? I don't see it as an option under get data
Superb explanation. Thank you for sharing this valuable topic.
Pdf option is not available
Great Chester! Super useful PDF conversion tips and tricks. Thanks for sharing :)) Thumbs up!!
Also after uploaded the tables, the numbers are not adding up. Please advise why
Hi Chester,
Sad news a recent Windows update has removed the from PDF option in Get data.
This has affected Excels on 2019 & O365.
😢
Do you know if there is a way around this?
It's still there for me on O365 / Win 10
How to convert pdf histogram graph into excel in table form?
is there a free download ?