Forum Discussion
pdf to excel
It is possible to import data from a PDF file into Excel using the built-in feature in Excel.
You can do this by going to the Data tab in Excel, clicking on Get Data, then From File, then From PDF. This will allow you to select the PDF file you want to import data from.
Once you have selected the file, the Navigator window will appear, showing a list of all the data sets that Power Query has found in your PDF.
You can then select the item or items that you want to import and click on Transform Data.
However, this feature is only available to Office 365 subscribers since August 2020.
It is not clear from your text whether it is possible to paste formulas from a PDF into your Excel. In Excel from Office 365 (the version with subscription) there is a tab with which you can get data from Data/From File/From PDF/From PDF. Announcing data import from PDF documents.
I hope that I could help you with this.
It doesn't work with Pro 2019. There is no PDF option in the dropdown menu