The next method to import a PDF file into Excel is to use its Data menu. It lets you extract data from an existing file, database, Azure, etc., and lets you insert the data into your Excel sheet.

Excel gives you tons of options for editing, but what if your file is a PDF? Here's how to convert a PDF into an Excel file with ease. Just follow these steps.

Locate and select the PDF file you wish to import. Excel will analyze the PDF and present a list of tables to import. Select specific or multiple tables and click ‘Load’ to import them into Excel.

PDF Data Connector from Microsoft will help you import and use PDF data into Microsoft Excel spreadsheets. Learn how to use it.

You may want to import a PDF into Excel, but the process is not always straightforward. Here are some strategies for moving content from a PDF file into an Excel spreadsheet.

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.

Step 2 when importing data is the command “Data -‘ From Picture -‘ Picture from File”. On the right side you can check the data before importing or insert it directly into the spreadsheet.