Instructions for inserting PDF into Excel

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.

Select get data 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.

Select the PDF file to insert

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.

Select the PDF slide to insert

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.

PDF content to insert

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…

See more:  How to create a chart in Google Slides

Select the new PDF file to insert

Now display the new interface, click OK.

Select the new slide to insert

In case you want to have more options for data when inserted into PDF, at the interface as shown, we Click Transform Data.

Transform Data 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.

Add custom data

Source link: Instructions for inserting PDF into Excel
– https://techtipsnreview.com/

, , ,

Leave a Reply

Your email address will not be published. Required fields are marked *