This option is only available comes from the new PDF connector feature which is only available for those who have Office 365 subscriptions.

Select the file, then you will be prompted with a Navigator where you can select the tables where you want to pull out data from.Īfterward, click on the Load button to instantly put the data into the Excel sheet or choose Transform Data to edit it using the Power Query Editor. A drop-down menu will appear, where you need to choose From File.įile formats will appear on the side and here, you can choose From PDF.Ī dialog box will open for you to choose the PDF file where you will import data from.

Note that this method will only work if the text or table on your PDF can be selected.Īlso: How to merge PDF files Method 2: Importing Data from PDF using Microsoft ExcelĪnother option is to directly import data using Microsoft Excel.įirst, open a new Excel spreadsheet and click on Data from the Menu bar.įrom the toolbar, click on Get Data.

The result will be a bit messy, but if the data you’ll be importing will be minimal, then it might be somehow easier to manage and arrange properly on the Excel sheet. Or type in “Ctrl + Alt + V” to show the Paste Special dialog box.įrom the dialog box, choose Text and click on the OK button on the lower-right corner. From its dropdown menu, choose Paste Special. If this does not work, you can try to click on the Paste icon. However, using this method is not always very efficient as the alignment and format of the pasted data can be different. Next, you will need to open Microsoft Excel, and paste the data in there from your clipboard.

Open pdf table in excel