Import Data from a PDF to Excel

[JohnOvens]

Thanks, Myanda, this is an excellent video. I completed your Power Query Course in 2016. I am now fully retired but have maintained an interest in EXCEL and each week I receive a PDF file from a data provider that I need to put into a data table for my SMSF. I developed a VBA program to analyse the data once I have placed the data in a Table. I will try and use Power Query to do this step as it could be a time saver. Thanks again. The course was excellent and I would recommend it as it is the future direction being taken by Microsoft.

[excel-businessinexcel]

What a nice woman! Very homely, cozy. I think you're a good mom. The children were very lucky. I wish you happiness! Oh, Yes, we talked about Excel...

[bigtall]

Thank you Mynda for this valuable video. This really helps when you only a receive pdf file and prevents time zapping manual work. Your email tips & tricks and video demos are awesome!

[TheKnowledgeable]

I think if I watch your videos daily I will become a native English speaker 👌and thanks again for the upload

[wayneedmondson]

Hi Mynda.. great tutorial. Glad to see this functionality now included within Excel. Thanks for the lesson. Thumbs up!

[CeliaBabayalo]

Thank you so much, the technique will help me so much. I did not know Power Query would be able to identify pages with tables and separate them from pages with text. super-amazing👏👏

[OwMyHip]

Thank you so much for this video! I have needed this so many times and it'll be so nice to actually have a solution for the next time I need it.

[NelCapeTown]

Thank you very much for a clear and concise tutorial. I'm going to try it myself now with a bank statement.

[hrushikeshumalkar]

Mind-blowing and amazing tricks you have👏.

Loved to watch this 😁😀😀

[davegoodo]

This is an interesting video for me, PDFs and Excel have been a nightmare in the past. Power Query is the answer, and it is a feature I’ll need to get a lot more comfortable with, thanks for the presentation Mynda, really good.

[IvanCortinas_ES]

Powerful!!! Thank you for the video. The same option extrapolated from Power BI to Excel. Thank you Mynda!

[monte]

Thanks Mynda. So much flexibility with power query. Never thought of doing this with pdf. Appreciate you sharing. 👍

[LloydG]

Another brilliant presentation, thanks. The functionality of Excel is very impressive! Wow!

Great lesson. Clean and straight forward. All in all good quality as always. Thank you for sharing your content.

[Salriaraj]

Thanks for the nice presentation, in case the excel navigator is showing pages on left and on Right hand side it shows page is empty? any Advise. Thanks

[jaehochoi]

Super great amazing tutorial!
I spent hours on getting data from pdf
last week with csv things.

[shakiraasfoor]

Well Done Mynda
All Your Videos Are Useful

[nazarkamal]

Not only getting idea for importing pdf n also to work in PQ in another dimension thanks 👍

[leorc]

Another excellent video, nice voice and volume yo explain Power Query, muy claro con tus vídeos Mynda, congratulations! I am learning good!

[DougHExcel]

Glad MSFT finally GA'd this feature, thanks for the video!