How to Restore the Missing Get Data from PDF Option in Excel

If you are attempting to import tables from a PDF document but find the specific connector absent from your Data ribbon, you are encountering a highly documented versioning limitation. Many users search for restoring the Missing Get Data from PDF Option in Excel after opening the Power Query menu and seeing the options stop at "From Workbook" or "From Text/CSV." This missing feature is rarely a software bug; rather, it is tied to your specific Microsoft Office release channel, update status, or subscription tier. This troubleshooting guide will help you verify your software environment and implement the exact steps needed to retrieve this data extraction tool.

Diagnostic Checks: Why the Data Connector is Unavailable

Before modifying your system settings, you must identify whether your software is actually capable of housing the feature. Microsoft initially released the native PDF data connector exclusively for Microsoft 365 subscribers. It was later rolled into the perpetual licenses for Office 2021 and Office 2024. If you are running an older standalone installation, no amount of troubleshooting on restoring the Missing Get Data from PDF Option in Excel will make the button appear.

Navigate to File, select Account in the bottom left navigation pane, and locate the Product Information section. Read the exact version listed under the Office logo.

• Microsoft 365 Apps for enterprise/business/family: The feature is supported. If it is missing, your local installation requires a manual update or a refresh of your connected services.
• Office Professional Plus 2021 or 2024: The feature is natively supported. A missing button indicates an outdated build.
• Office Professional Plus 2016 or 2019: The feature does not exist in this codebase. Power Query in these versions cannot parse PDF structural tags natively.

Restore the Missing Get Data from PDF Option in Excel

If your Product Information confirms you are running a supported Microsoft 365 subscription or Excel 2021/2024 installation, the connector is missing because your local client is running an outdated build or has disconnected from Microsoft's cloud feature deployment. Follow these sequential actions to force the software to fetch the latest Power Query connectors.

1. Stay on the File > Account screen inside Excel.
2. Under the Product Information heading, locate the Update Options button next to the Office Updates section.
3. Click Update Options to open the drop-down menu and select Update Now.
4. A background process will launch, checking for Office updates. If an update downloads, allow the wizard to close Excel and apply the new build.
5. Once the update completes, reopen Excel and open a blank workbook.
6. Click the Data tab on the main ribbon.
7. Click Get Data on the far left of the ribbon, hover over From File, and look for From PDF in the secondary menu.

If the update process finishes but the option remains hidden, your Microsoft account session may have a synchronization error preventing premium features from activating. On the same Account page, click Sign Out under your User Information, restart your computer, launch Excel, and sign back in using the email address tied to your active Microsoft 365 license. This forces the software to re-verify your entitlement and push the PDF connector to the ribbon interface.

Alternative Workarounds for Unsupported Excel Versions

If your diagnostic check revealed that you are running Excel 2016 or 2019, working to restore the missing Get Data from PDF option in Excel ultimately means relying on alternative bridging methods, as the native button cannot be added to older codebases.

You can use Microsoft Word as an extraction bridge to convert the PDF into a readable table format before moving it to your spreadsheet.

1. Open Microsoft Word, click File, and select Open.
2. Browse to the location of your target PDF file and select it. Word will display a prompt stating it will convert the PDF to an editable document. Click OK.
3. Wait for the conversion engine to process the file. Once opened, scroll to the table you need.
4. Click the crosshair icon in the top-left corner of the table to highlight all rows and columns, then press Ctrl + C to copy it.
5. Switch to your Excel workbook, select cell A1 (or your preferred starting cell), and press Ctrl + V to paste the data. You may need to use the Paste Options menu to select Match Destination Formatting to clean up the borders.

Effortlessly Convert PDF to Excel with WPS Office

Since the missing Power Query connector is controlled by Microsoft's subscription licensing and software updates, WPS Office cannot change your Microsoft-side settings or force the button to appear in your Excel ribbon. However, if your underlying document goal is simply to extract tables from a PDF document accurately, WPS Office provides a direct workflow that bypasses complex Power Query menus altogether.

WPS Office features an integrated PDF toolkit that natively processes tabular data. For people working on restoring the Missing Get Data from PDF Option in Excel because they do not wish to upgrade their older Office 2019 license to a costly Microsoft 365 subscription, WPS Office serves as a highly efficient alternative suite.

1. Open the WPS Office desktop application and navigate to the PDF tab on the global sidebar.
2. Click PDF to Excel from the main toolkit dashboard.
3. A dedicated conversion window will appear. Click Add Files and select the PDF document containing your tables.
4. In the conversion settings at the bottom of the window, select your desired output directory and ensure the language settings match your document for optimal optical character recognition (if the PDF is a scanned image).
5. Click the Convert button. WPS Office will process the document and immediately generate a clean spreadsheet (.xlsx) with the tables properly formatted into cells, completely bypassing the need for an intricate data import query.

Use Word, Excel, and PPT for FREE

Free Download

FAQs

Can I add the Get Data from PDF feature to Excel 2019 using an add-in?

No, there is no official Microsoft add-in that brings the native Power Query PDF connector to Excel 2019 or older perpetual versions. The parsing engine required to read PDF structural elements is hardcoded into the newer Microsoft 365 and Office 2021+ architectures. You must use third-party conversion software or the Word-bridge method instead.

Why did the Get Data from PDF option disappear after working previously?

If you previously used the feature and it suddenly vanished, your Microsoft 365 subscription may have expired, or your Office installation may have encountered an authentication glitch. When Excel cannot verify an active subscription, it silently reverts to the feature set of a basic perpetual license, hiding premium connectors. Signing out of your account via File > Account and signing back in usually resolves this exact symptom.

Does repairing Microsoft Office restore the missing PDF connector?

An Online Repair will only resolve the issue if your Microsoft 365 installation files were genuinely corrupted or failed to apply a downloaded update properly. If you are simply on a deferred update channel (such as the Semi-Annual Enterprise Channel) that has not yet received the feature update, a repair will not bypass your IT administrator's rollout schedule. You must switch update channels or wait for the global deployment.

Does the Mac version of Excel support the Get Data from PDF option?

As of recent builds, Microsoft Excel for Mac does not fully support the complete suite of Power Query connectors found in the Windows version, including the native "From PDF" function. Mac people working on restoring the Missing Get Data from PDF Option in Excel will not find a hidden toggle to enable it. You must rely on native macOS tools like Preview to copy and paste tabular text, use Word for Mac to convert the file, or utilize dedicated software like WPS Office for macOS to handle the conversion.