Why Get From PDF Is Missing in Excel 2016 and How to Fix It
Question details
User needs to identify why Excel 2016 Home and Business does not display the Get Data from PDF connector even when Power Query is enabled, and how to work around the missing PDF import option.
- Product
- Microsoft Excel 2016 Home and Business
- Device & OS
- not provided
- Scenario
- The user wants to import tabular data from a PDF file into Excel by using the Get Data from PDF connector in Power Query.
- Observed behavior
- Excel 2016 does not show the Get Data from PDF option even though Power Query or Get & Transform is enabled.
Check the exact Excel edition, version, and build number under File > Account or File > Office Account. This tells you whether your Office installation belongs to a channel that can receive the PDF connector through updates.
Verify Your Excel 2016 Edition and Build
Use this first to confirm whether your Excel 2016 build supports the Get Data from PDF connector before you try updates or workarounds.
The PDF connector is not included in all Excel 2016 perpetual editions. Connector availability depends on the Office edition, build number, and update channel.
In Excel 2016, click File and then select Account or Office Account.
Under Product Information, check the edition, version number, and build number shown for Excel 2016.
Look for an Update Options or About Excel section to see whether the installation uses a current update channel or a perpetual license.
Install Available Office Updates for Excel 2016
Use this if your edition is supported but the PDF connector is missing because the Office build is outdated.
Convert PDF to Excel with WPS Office and Import the File
Use this when Excel 2016 cannot add the PDF connector; WPS Office converts the PDF into an .xlsx file that you can open directly or import with Power Query.
Use WPS Office as a Free Alternative When Excel 2016 Lacks the PDF Connector
WPS Office is a free, lightweight Office suite that can open, convert, and edit the files you already use. It includes PDF-to-Excel tools and supports Microsoft Office formats, so you can work around the missing Excel 2016 Get Data from PDF connector without changing your workflow.
- 1. Download WPS Office: Get WPS Office free from the official WPS website and install it on your computer.
- 2. Open PDF and convert: Launch WPS Office, open the PDF, and select the PDF to Excel conversion option.
- 3. Save and continue in Excel: Save the converted .xlsx file and open or import it in Microsoft Excel as needed.
Frequently Asked Questions
Why is Get Data from PDF missing in Excel 2016 Home and Business?
The PDF connector is not included in all Excel 2016 perpetual editions. Check File > Account to see your edition and build; if it is a perpetual Home and Business installation, the connector may not be available even with Power Query enabled.
Can an Office update add the PDF connector to Excel 2016?
It depends on the edition and update channel. Open File > Account > Update Options > Update Now, then restart Excel and check Data > Get Data > From File > From PDF. Some perpetual Excel 2016 builds still will not receive the connector.
How can I import PDF data into Excel without the Get Data from PDF option?
Use a PDF-to-Excel tool such as WPS Office. Open the PDF in WPS Office, convert it to .xlsx, and then open the converted file in Excel or import it with Power Query.
Does WPS Office support Excel files and PDF conversion?
Yes. WPS Office opens and saves .xlsx and .xls files and includes PDF-to-Excel conversion tools, making it a practical alternative when Excel 2016 lacks the PDF connector.
Where should I ask product questions about Excel 2016?
Post Excel product questions in the Excel support area or Microsoft Q&A rather than a Tech Community website discussion space. That helps you reach the correct Excel support audience.
