Users can now import data from PDF into Excel simply and quickly with built-in features, instead of having to convert PDF files to Excel, or completely insert PDF into Excel as an object. This greatly assists users in importing reports, lists,… into Excel quickly. The following article will guide you to import data from PDF into Excel.
Instructions for inserting PDF into Excel
Note, this feature only applies to Office 365 version. With other versions of Office, you use traditional conversion methods.
Step 1:
You open the Excel document that needs to get data from the PDF. Then click on the Data tab and then look down, in the leftmost corner of the toolbar click on Get Data choose From PDF.
Step 2:
Switch to the folder interface on your computer, you Click on the PDF file need to insert and then click the Import button below.
Step 3:
Now display the Navigator interface. First you look to the left edge of the interface and you will see the pages in the PDF file that we have selected. You can Click on a slide to insert already press Load under.
Step 4:
As a result we will see the content from the PDF inserted in Excel. The right edge will be the interface of Queries & Connection to adjust the data when needed.
Step 5:
To re-insert another data table in the same PDF file, at Queries & Connections interface, friend Click on the data you are inserting present.
Then switch to Navigator interface, you click new data already Click Load, Select Load To…
Now display the new interface, click OK.
In case you want to have more options for data when inserted into PDF, at the interface as shown, we Click Transform Data.
When the data is inserted into Excel, there will be more options such as selecting columns, converting rows and columns, managing parameters and formatting data.
Source link: Instructions for inserting PDF into Excel
– https://techtipsnreview.com/