The file’s name contains the region name at the end of the filename. Keeping Track of the Data’s Place of Originīefore we load the results into Excel, we want to ensure that we can properly identify the region from which each transaction originated. This iterative process will extract and combine the data from each PDF table into a single table. Power Query will automatically create a series of queries, parameters, custom functions, and transformation steps to iterate through each PDF in the folder. Selecting tables is usually preferred as it avoids unwanted PDF content, like paragraph-style text, and more properly identifies table characteristics, like headers.Ĭlick OK to begin the combining process. If you have multiple tables on a single page, and you want all tables, selecting “” may prove more effective than selecting each table separately. In the Combine Binaries dialog box, we see a listing of all tables and pages in the first PDF.Īs each file has but one page with a single table, selecting either the “ Table001” or “ ” options will likely yield the same result. To extract each of the PDF file contents, click the Expand Binaries button in the top-right of the Content column. We don’t want the file metadata we want the contents of each file.

Copy table from pdf to excel