How to Import PDF into Excel (Get Data from PDF is Missing)

the easiest way for us to import PDF into our Excel is through get data from PDF but what if we are missing this option from our Excel in today's tutorial we are going to cover how can we import PDFs into our Excel alternatively we are going to follow the instructions in this forum I will leave the Forum link and the document in my video description below so that you can follow along too there are two steps in total let's get into it step 1 to determine if your Excel can import PDF or not you can download the file from my video description or you can scroll down to 1.2 in this forum and select this hyperlink to download the file it will prompt you to this Excel workbook and we have to save a copy on our PC select file save as download or copy once it is done open the downloaded file and it will looks like this remember to enable content or enable editing right click on a green row and hit refresh it will tell us if our Excel can import the PDF or not and it is still loading and yes in my case it is a yes what if you are getting you cannot import PDF instead unfortunately I am afraid there is no solution for your issue Step 2 to import PDF into our Excel open a blank Excel worksheet go to data ribbon get data from other sources click on blank query it will open a blank power query editor for us this is the same as Excel which allows us to do further data analysis for example tutoring sorting and so on we are going to copy a formula and paste it in our formula bar over here you can either get a formula from my video description or you can jump back to this forum scroll it down to number two up until you can see this equal sign over here let's copy the whole formula Ctrl C and paste it in our formula bar in power query editor here let's click Ctrl V this formula allows us to locate our PDF in our PC this highlighted letters in red locate we'll do the locating for us so in my case I have saved my document in my desktop right click on the document and select copy as path let's get back to our power query editor here and replace the letters in red simple click outside here it will allow power query to load our PDF once you can see a display of pages and tables you can tell that power query editor has successfully loaded our PDF but what if you are getting expression error as follows which means there is an error in your formula if you can recall there is a value in our formula over here if you are getting expression error we have to replace the value 1.3 with either 1.1 1.1 1.0 or 1.2 and in this case I will show you how to replace it with 1.0 Ctrl C to copy the value and let's get back to our power query editor and replace it with 1.0 click outside and you can see that the power query editor has successfully loaded our data in the beginning I have known that I want to load my data on page 3. click on the empty space over here it will allow us to see the preview of our data on page 3. we can scroll it down to double confirm this is the information that we want let's move our cursor to until you can see this sign click on it and you can see that the power query data has displayed our page 3 data over here scroll it down and I am satisfied with it let's close and load so that we can load our data in our Excel and voila this is how we can quickly import PDF in our Excel IF the get data from PDF option is missing

Channel: Joyce Chong

Views: 72,459

Keywords:

Id: PPIgOX05N9o

Length: 5min 18sec (318 seconds)

Published: Mon Mar 27 2023