Import from PDF document

Exporting a table to PDF is not a new feature, it has been around for ten years or more. But how to import a table from a PDF document into Excel? This task is performed by Power Query which, since the latest version, has become an integral part of Excel and you can’t bypass it, no matter what kind of data you import into the application. Since recently he has this fantastic option, let’s see how it is used …

Open a new Excel document. Then go to the Data ribbon. At the very beginning, you will see the Get Data menu. Open this menu and then select a submenu to import from document, further the option to retrieve data from PDF document. Find the document you want to import …

The document import process will start. In the Navigator window Excel will show, on the left, a list of tables that it has recognized. Clicking on one of them, on the right, shows data preview in which you can see what data it contains. Select the table you want to import.

By clicking on the Transform Data button you will enter the Power Query, where you can perform additional data transformation; clicking on Load achieves the import of the table contained within PDF into an Excel document.