Excel Import PDF Using Get & Transform Query PDF Connection

In version 2007 of Microsoft Excel 365, Microsoft introduced the PDF connection feature that allows you to import pages and tables from PDF documents. In this video, I show you how to use this feature with a PDF on either your local drive or the world wide web and refresh it automatically.

This method is beginner friendly and does not require VBA, but it only works on very recent versions of Microsoft 365 on Windows.