These include the worksheet name, the range of the cells, the location of the application through which the PDF file will be opened ( Adobe Reader in this example), and the location of the PDF file. Now I’ll show you can copy data from the PDF file to the Excel worksheet through step-by-step analysis.įirst of all, you have to declare the necessary inputs. Here we’ve got a PDF file called standardnormaltable.pdf that contains a table of the normal distribution.Īnd we’ve opened a worksheet called Sheet1 in an Excel workbook where we’ll copy the data from the PDF file. So, without further delay, let’s go to our main discussion today. You can customize data to your liking by using the features given, like adding rows and columns, removing rows & columns, managing parameters, etc.An Overview to Extract Specific Data from PDF to Excel Using VBA (Step-by-Step Analysis) Follow steps 1 – 5 from the first section.You can further customize the data using the Power Query window. Select whichever options are relevant to you. You can even choose to load the data into a new worksheet rather than the existing sheet. You will get options of Pivot Table Report, Pivot Table, etc.Instead of clicking on Load, click on the arrow next to Load and select Load To.Follow steps 1 – 5 from the above section.You can adjust the Load settings if you want to get the data in some other form, like a pivot table. Your data will be imported into the Excel sheet in a table, but you can make further adjustments if you want to make the data seem more relevant to you.

If it is something that you wish to convert to a spreadsheet form, click on it and then select Load. Click on any of the items, and you will get a preview on the preview screen.

Step-6: You will now get a Navigator Panel, and you will see a list of everything included in the PDF file. Step-5: Locate the File you wish to get data from.

Import pdf file into excel