You can choose a specific component by clicking it or using the search option. Now, from the ‘Navigator’ screen, all the identified components (tables or pages) from the PDF will appear on the left sidebar. This will open a separate window on your screen. Then, click on the ‘Open’ button to load the data. Next, locate the file you wish to import the data from and select it by clicking on it. This will open a separate File Explorer window on your screen. After that, hover over the ‘From File’ option and then click on the ‘From PDF’ option from the sub-menu. Next, click on the ‘Data’ tab from the Ribbon menu and then click on the ‘Get Data’ option to proceed.

Then, click on the ‘Blank workbook’ option to continue. Then, click on Microsoft Excel to open the app. Head to the Start Menu and type Excel to perform a search. To import the data from a PDF file, first, open Microsoft Excel. The only requirement is that the excel sheet should be stored on your secondary storage. Importing data to an excel sheet is a very straightforward process.

The tool is only available for Microsoft 365 users, though. Moreover, you can also edit the data before importing it to excel using the Power Query Editor which is also a part of this tool. You can easily import tables and/or data stored in a PDF file to an excel sheet using this feature. You can use the PDF data connector, an in-built tool in Microsoft Excel. If you have any data in a PDF file, like your bank statement or other financials, that you want to import to an Excel file, you don’t need to look for any third-party apps.

Excel import pdf table