First, launch Microsoft Excel and open the Excel sheet in which you want to import a PDF. After that, move to the Insert menu from the top ribbon and then press the Text drop-down button.

Select the data you want to import. Once you choose the PDF document you wish to import the data from, a navigator window will display the list of tables you can import into your Excel spreadsheet.

If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

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.