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: https://www.xelplus.com/import-pdf-to-excel
Complete Excel Power Query playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyKV86N7i0q9TfYNN8bBjX-
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
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!