It will open the PDF file by default, and you need to close it. The PDF File has been inserted into an Excel sheet as an object similar to a chart or any shape. We can drag it or resize it as we want.

To have Excel insert the PDF, first open the spreadsheet in Excel. Then, click the "Insert" tab on the ribbon menu and click the "Object" icon within the "Text" group of command icons.

PDF to Excel converters we tested. Here are the tools we tested, starting with our overall best performers (but remember that “best” depends in part on the specific source document).

Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program.