If your Excel version doesn’t support this, you may be able to accomplish it with Power BI instead. At the time of this writing, this data source is available in O365. Depending on your version of Excel, you may not have this command. Note: this command is found within the Get & Transform group of commands. We then browse to the desired PDF file and click Import. Stepsįirst, we use the Data > Get Data > From File > From PDF command. At the time of this writing, this data source is available in O365. Note: depending on when you are reading this and which version of Excel you are using, you may or may not have the From PDF option. We can accomplish this using Power Query. We would like a way to extract the commission table into Excel, like this: We have a PDF file, perhaps it looks like this: We can use Power Query to retrieve values from PDF files. Historically we have been able to get PDF data into Excel using a standard copy/paste or some third-party tools.
