Select Data (tab) -> Get & Transform (group) -> Get Data -> From File -> From PDF.Start Excel to create a blank workbook.To use the connector, we perform the following steps ( the example uses Excel 365). Power Query has a built-in connector used to extract information from PDF files. We could spend time rearranging and fixing the pasted data, but we don’t have that kind of time and it would negate the second requirement of an easily updatable Excel report. We could try to just highlight the relevant data in the PDF, then copy and paste the data into Excel, but it’s likely not to go as well as we had hoped.

Suppose we have a safety report with performance data stored on the second page in a table format. Let’s examine three scenarios where PDF data can be extracted using Power Query. The connector can isolate data stored in a table format or extract all data from a page if the needed content is not in a table format. Power Query in Excel and Power BI possesses a connector that allows data extraction from PDF files.

Export pdf table to excel