Notice Power Query has correctly identified the column labels and placed them in the header row.

However, you’re most likely to want to do some more cleaning of the data first, in which case click the ‘Transform Data’ button to open the Power Query Editor: Step 4: Import Data from PDF or Clean - From here you can click the ‘Load’ button to import data directly to the Excel worksheet or to the Data Model. You can select a table or page to preview in the pane on the right, as shown below with the table on page 7 displayed: Step 3: Select Tables and Pages in PDF - The Power Query Navigator window opens with a list of pages and tables Excel has identified in the PDF. Step 2: Locate the PDF File you want to import to Excel - Browse to the location the PDF is saved > click Import: Step 1: Get Data from PDF - It’s as easy as going to the Data tab of the ribbon > Get Data > From File > From PDF: zip file please ensure your browser doesn't change the file extension on download. Excel for Decision Making Under Uncertainty Courseĭownload the Excel Workbook and PDF and follow along.Excel for Customer Service Professionals.

Insert excel table into pdf