If you want to import more than one data set, check the box that says Select multiple items. At the top of the list will be individual sets of data tables, and at the bottom it is broken down by page.

The Navigator window will appear, showing a list of all the data sets that Power Query has found in your PDF.

Find the PDF file wherever you have it stored on your computer.

Starting from the Data tab on the Ribbon, click on Get Data, then From File, then From PDF.

Here are the steps to import the PDF file to Excel: Again, you must be on the Beta Channel of Microsoft 365 at the time of this publication. If you have the new feature you will see From PDF on the From File menu. The data set I am interested in spans two pages and looks like this: Steps to Import a PDF into Excel In the video, I've used an example PDF that is an exported report on web page speed from GTmetrix. I don't have a timeline on the release, and apologize in advance if you don't have access to it yet. It will be rolling out to other channels in the coming months. It's important to note that the From PDF feature is currently available on the Beta Channel (formerly Insiders Fast) for Microsoft/Office 365 subscribers. I'll walk you through the process of importing tables from PDF to Excel.

It's fairly easy to do if you're familiar at all with Power Query (if you're not, get started with my overview tutorial here: Power Query Overview: An Introduction to Excel’s Most Powerful Data Tool, and then you can install it here: The Complete Guide to Installing Power Query). And we can use all of the data cleanup features of Power Query to prepare the data before it's imported, and automate the entire process. The new feature even detects tables of structured data within PDF pages. And now it has the ability to import a PDF file into Excel. GTmetrix-report.pdf Download Turn a PDF into an Excel Worksheet!Īs I've said before, Power Query is Excel's most powerful and magical data tool.

Import data from excel to pdf form