Import Data from PDF to Excel Tables Using Power Query (Quick and Easy)

In this video, I will show you how to convert PDF files to Excel using Power Query. You can connect Excel with any PDF file using Power Query and then import the data from the PDF into Excel (without the need for any software or website).

One great thing about using Power Query to import data from pdf to Excel is that you can transform the data in Power Query before getting it in Excel.

This video also covers how you can combine all the PDF files in a folder using Power Query.

00:00 Intro
01:18 Import One Table from PDF to Excel
06:55 Import Multiple Tables from PDF in Excel
16:55 Combine PDFs in a Folder
23:26 Extract Table from Unstructured PDF (messy data)

#Excel #ExcelTips #ExcelTutorial #SumitBansal

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.

Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[RogerToppinGS]

This is one of the best tutorials I have seen on YouTube. Thank you so much for this. You're a wonderful tutor

[viewpoint]

There are many videos on pdf to excel, but yours is the best and step by step to the point. Thank you.

[vishytheking]

your method of explaining and preparedness with data is amazing.. i have not seen a good presentation like this in a while.. kudos.. i loved it.

[IvanCortinas_ES]

The information is very complete. Without a doubt, one of the tools you need to know to model data consistently.
Thanks for the video, Sumit.

[seoton]

Your video are amazing, that's the thing I have been struggled in converting pdf invoices from my work into excel :) Thank you very much

[ggguru]

Excellent presentation sir thank you so much

[waynebyrne]

This is an excellent intro to power query....Thank you

[دراساتاجتماعية-زل]

You always have the new and wonderful in the world of Excel

[mahendrab]

its good video but there is one doubt that you have combined the files which contained only table what about if each file contained multiple tables i.e. file one contained 2 tables, file 2 contained 3 tables and so on. please explain this.

[ekkiwurm]

Thank you, Sir. You saved me a lot of time 😀

[Yogesh.Suryavanshi]

Great, thank you for sharing this. What if there is an change in the text, in Column A financial Summary column .. in the next quarter they might added something new or delete. how to resolve such issue. Thanks

[sankarpal]

Hello Sumit sir ji. Sir mera crore namro pranam lijiye. Sir you are just wonderful. Your video always teachs a unique thing. It is a compact values. God bless you sir. Sir one humble request could you please provide this pdf file for practice purpose? Thank you sir. Always be happy and healthy. Stay blessed.

[francishubertovasquez]

You're lecture competent and exact to details. Ok

[AntonPonniah]

as always, thoroughly explained, many thanks.

[Payton-Prescott]

This is a great video, thanks a lot Sumit! 🙌 I have recently also started to use extraktAI for getting all my data from PDFs to excels, it saves me a ton of time tbh

[Satwant]

Wow. Mind-blowing power of Excel. So well explained. Thank you.

[krnrajan]

Too Good. Many thanks. Can you share the sample files. Yes. Do explain what the additional queries that are generated do

[francishubertovasquez]

About Querry, for example, in several layered Encryptions, can the Querry app be used in that like the encryption method will ask like Querrying as validation to open data and files then in those Querry question there are unknown codes in that, something like that only citing example which would make the AI data and files penetrator think quick and if it's that quick the probability of error from the Question Querry to enter.

[prithirajpanigrahi]

Thanks @trumpexcel for the Video. In the last example, if I needed just the incremental columns (retain the old and add the new) from Spotify results, what will be the steps? Thanks in advance.