How to import data from PDF to Microsoft Excel

Claudiu Andone
by Claudiu Andone
Windows & Software Expert
0 Comments
Download PDF
Affiliate Disclosure

  • Microsoft introduced a PDF data connector in Microsoft Excel that allows you to import data from PDF files.
  • The data connector is searching inside PDF relevant data and transforms it into tables ready to be imported into a spreadsheet.
  • Are you interested in software? We have a lot more information in our Software section.
  • This is one in a huge collection of tutorials. You can find all of them in our How to Hub.
Importing data from PDF to Microsoft Excel

You can open PDF documents and put them in a spreadsheet in Microsoft Excel, but most of the time, the result is not going to be satisfactory.

You can also try to save a PDF document as an Excel file using Acrobat DC but it’s merely something rather than nothing.

Ad

That’s why we got pretty excited when we found out that Microsoft introduced a PDF data connector in Microsoft Excel that allows you to import data from PDF files.

How do I import data from PDF to Microsoft Excel?

  1. Open a new Excel spreadsheet.
  2. Click on the Data option from the ribbon.
  3. Now click on the Get data button, select the From File option, then the From PDF option.
  4. You will be prompted to select the PFD file that you want to pull data from and after you do, you will see another window where you can select which data to use.
  5. Next, select the Load button to bring the data into Excel, or the Transform Data button to edit it with Power Query Editor.

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

We hope that this little guide will help you import your data from PDF and import them to an Excel spreadsheet.

If you have any questions or suggestions, don’t hesitate to tell us about that in the Comments section below.

Ad
Was this page helpful?
Thanks for letting us know! You can also help us by leaving a review on MyWOT or Trustpillot.
Get the most from your tech with our daily tips
Tell us why!