- 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.
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?
- Open a new Excel spreadsheet.
- Click on the Data option from the ribbon.
- Now click on the Get data button, select the From File option, then the From PDF option.
- 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.
- 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.