How to import data from PDF to Microsoft Excel

Claudiu Andone
by Claudiu Andone
Windows & Software Expert
Oldtimer in the tech and science press, Claudiu is focused on whatever comes new from Microsoft. His abrupt interest in computers started when he saw the first Home Computer as a kid. However, his... Read more
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
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

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.

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.

This article covers:Topics: