Further, Power Query can improve accuracy by executing these transformations automatically every time you refresh your queries. Obviously, Power Query can help save you tremendous amounts of time. Therefore, you do not have to perform these tasks manually each time your data changes. Importantly, each of these transformations – and so many more you can add – automatically execute each time you refresh your data query. You can also add transformations that data to make it more useful to you. Using these tools, you can quickly and easily import data into your Excel workbooks. Collectively, these icons constitute Power Query. Insert PDF into Excel In the pop-up dialog box, go to the 'Create from File' tab and use the 'Browse' button to select the PDF document that you want to insert. There, on the left side, you will notice a group of icons labeled Get and Transform Data. Open an Excel Document After opening an excel document, click the 'Insert' > 'Object' button in the Text section. Now right click on the PDF icon and select Format Object. Before clicking OK, check the boxes that says Link to file and Display as icon.

Click Create > Browse to locate the PDF you want to insert.

You can access Power Query from the Data tab of the Ribbon in Excel. Open up the Excel spreadsheet that you want to place the link into and select Insert > Object. Since introducing this tool, Microsoft has continually enhanced Power Query with new features, including the option of converting and importing PDF data into Excel. Microsoft added Power Query to Excel with the 2010 release of the application.

Insert pdf data into excel