How To Import Data to Microsoft Excel From PDF

Recently Microsoft Excel received an upgrade which increased the performance of Microsoft Excel and added some new features to it.

One of these new features is importing data to Microsoft Excel from a PDF file.

This feature will read and transfer all PDF relevant data in the form of a table. Which will be ready for you to import it to the Microsoft Excel spreadsheet.

Also Read: HOW TO CHANGE SECURITY SETTINGS OF A PDF FILE.

Import Data to Microsoft Excel From PDF

How To Import Data to Microsoft Excel From PDF

Using the method given below you can easily import data to Microsoft Excel from a PDF.

  • From your PC or laptop desktop.
  • Open a new Excel spreadsheet.

Import Data to Microsoft Excel From PDF

  • Click on the Data option from the top bar.
  • Now click on the Get Data button.
  • Here click on the From File option.
  • Now click on the From PDF option.

Import Data to Microsoft Excel From PDF

Now a pop-up will appear, Using the pop-up you can navigate through your system and then select the file from which you want to extract data from.

Once you have selected the file another window will open, from here you can select the data that you want to use in the Microsoft Excel spreadsheet.

Import Data to Microsoft Excel From PDF

Now you have selected the data that you want to use in your new Microsoft Excel spreadsheet. Click on the Load Button to port the data into Microsoft Excel.

You can also click on the Transform Data button to edit the transferred data with Power Query Editor.

The new PDF connector feature is available only if you have an Office 365 subscription.

Also Read: HOW TO CONVERT PDF/A TO SIMPLE PDF FILE.

If you are interested in reading about software like Microsoft Excel and want to learn more about software than let us know by commenting in the comment section below.

Hope so this tutorial was helpful, We are grateful for the trust you have placed in us.

Regards: Team Windows Boy.

Leave a Comment