Properly Convert PDF to Excel

Did you know that you now have the option of importing and converting PDF data into Excel? This was one of the top requests of Excel users: How can we convert a PDF file into Excel?

Now you can use Power Query’s amazing data functionality to not just convert PDF to Excel, but import the PDF data with a connection the original PDF file. This way you can refresh the imported data in Excel to get the latest data from your PDF document. In addition to this, you can also clean the imported PDF data.

In this video we will test the functionality with 3 different business cases. We will first test the automatic refresh in Excel when the content of the PDF changes. In the second example we will import a specific table from a PDF document (Tesla’s quarterly financial report). And finally we’ll get creative and import the table of contents from a PDF eBook into Excel.

The new PDF data connector is available as part of a Microsoft 365 subscription

⯆ Read the full blog post:

Complete Excel Power Query playlist:

★ My Online Excel Courses ►

✉ Not sure which of my Excel courses fits best for you? Take the quiz:


Get Microsoft 365:
Microsoft Surface:

Screen recorder:
Main Camera:
Backup Camera:
Main Lens:
Zoom Lens:
Audio Recorder:

More resources on my Amazon page:

Time Stamps
00:00 Import from PDF to Excel with Power Query
00:41 Automatic Refresh – Import from PDF to Excel with Power Query
03:36 Convert Financial Report from PDF to Excel with Power Query
07:10 Import Table of Contents from PDF to Excel with Power Query

Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel #PowerQuery

Posted by Contributor