Enable Data Import from PDF Files
I will suggest that Excel product team adds From PDF files in the Get & Transform group of the Data tab. This will make life much easier to extract data stored in PDF for further analysis in Excel.
Darnie Christopher commented
This does not work when the PDF source file is password protected . Please suggest a