Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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.

If you’d like to view the accompanying blog post on my website, you can access it here: https://www.excelcampus.com/powerquery/import-pdf-excel/

Upload your own example PDF file for a future video tutorial:
https://www.excelcampus.com/power-query-upload-pdf-example-file/

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:
https://www.youtube.com/watch?v=HcfKOusOJhA
Power Query Overview - Automate Data Tasks in Excel & Power BI:
https://www.youtube.com/watch?v=vq9AgAtSvQg
How to Install Power Query in Excel 2010 or 2013 for Windows:
https://www.youtube.com/watch?v=gwW2CDdvUUs

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