How to Import PDF Files into Excel with Power Query

This video teaches you how to import tables from a PDF file into Excel with Power Query. Table data that spans multiple pages in the PDF can be appended together into one cohesive Excel Table.

Upload your own example PDF file for a future video tutorial:

From PDF is a new feature in Power Query that is currently available of the Beta Channel for Microsoft/Office 365 subscribers. It will be rolling out to other channels in the coming months.

Importing PDF files into Excel has always been a challenge. This new feature of Power Query detects structured data tables within pages, making it easy to cleanup and prepare the data in the Power Query Editor.

We can also append (combine or stack) multiple tables from multiple pages in the PDF file. Power Query allows us to automate this entire process, making it fast and easy to import multiple PDF files into Excel.

Related Videos:
How to Combine Excel Tables or Worksheets with Power Query:
Power Query Overview - Automate Data Tasks in Excel & Power BI:
How to Install Power Query in Excel 2010 or 2013 for Windows:

#MsExcel #ExcelCampus
00:00 Introduction
01:11 Import from PDF
02:48 Append Data

[amitdagli]

You are first person to show append power queries.

[nonoobott]

You're an excellent teacher and instructor. I can hardly wait for this functionality on my power query. Thanks for sharing

[wayneedmondson]

Hi Jon.. thanks for the preview into this new feature. Can't wait for it to be released to the general public. Thumbs up!!

[andromeda]

Really you are one of the best instructors I have ever know them. All thanks to you dear for your amazing efforts. Hope this function to be released very soon

[michaeljones]

This is a game changer for me and I'd like to see more examples if possible.
Thanks again!

[tomwelt]

Thanks, Jon, super content. I can't wait to try it when the From PDF feature is made available. Then I'd really be interested in your planned video on refreshing the data.

[lucasamorim]

so thoroughly explained! thank you so much!

[johnmonroe]

Excellent video, Jon, thanks for sharing. Can't wait for this functionality!

[jongskicastro]

Thank you brother, I learned so much from you!!!

[kicksandblowingguns]

Dear Jon, Good Day, I'm a new subscriber, your explaining method is simple and extraordinary. Thanks for spreading your knowledge across the world. Looking fwd to see your more tutorials.

[Amy]

This is a great video. I love it. Thank you Jon.

[gladiadordoexcel]

Your videos are always very useful and with clear explanation. Congratulation from Guinea-Bissau (África)

[darrylmorgan]

Great Tutorial, Looking Forward To Try PDF Imports When It Becomes Available...Thank You Jon :)

[JagadeeshBharadwaj-]

Excellent explanation. Thanks a lot, Sir. 🙏

[RonLeedy]

Thanks for the great video. Already thinking of reports to pull in once its public.

[ebeaucourt]

Is it possible to make a video tutorial to import multiple pdf's (all with the same structutre) but with multiple tables? Thanks for your help and excellent tutorails.

[markbui]

I truly don't understand the thumb-down votes for these videos. I suspect it's coming from competing YouTube sites. Thank you Jon for taking the time to put together these tutorial videos for us. Please keep up the great work!!!

[lwinnekins]

Thanks, Jon, for this tutorial as it was a great help in understanding how to download PDF files using power query.

[willchung]

append as new! thats what i needed. thank u.

[chanelgabb]

Your Videos are fantastic! Great new feature too!