We have the option to activate the check box next to the command Select Multiple Items just in case we need to select more than one item. Once the Connection is established the Navigator dialog box appears as shown below. Once we press the Import button, the Connecting dialog box appears as shown below notifying us to Please Wait While We Establish a Connection. Once done, we just press the Import button located at the bottom right corner of the Import Data dialog box. Once we have selected to Import Data from a PDF File, the Import Data dialog box appears as shown in the image below, where we must navigate and locate the PDF File that we want and need to import into our Excel Spreadsheet. Once we locate the area Get & Transform Data, we select the command Get Data as shown below, and from the drop-down menu that appears we select the first command that is named From File and then from the submenu that appears we select the command From PDF. An exciting new feature that will be described in the post right below.įirst, we must select the Data tab as shown in the image below, and the from the left area of the ribbon to locate the area named Get & Transform Data. Well now we can also Import Data and Analyze Data from PDF Documents.

In previous posts of mine I have described how we can Import Data from Facebook, from Text Files, from Other Sources etc., into a Microsoft Excel Spreadsheet.

Excel import pdf table