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)

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) https://trumpexcel.com/learnexcel/
✅ Free Dashboard Course https://bit.ly/freeexceldashboardc...
✅ Free VBA course https://bit.ly/excelvbacourse
✅ Free Power Query Course https://bit.ly/powerquerycourse
✅ Best Excel Books: https://trumpexcel.com/bestexcelbooks/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

#Excel #ExcelTips #ExcelTutorial #SumitBansal