Excel Get Data From PDF Missing? Windows and Mac Guide

If Excel's Get Data From PDF option is missing, check your Excel platform and license before reinstalling Office. Having Power Query does not mean your edition includes every connector. Microsoft's published Windows comparison marks PDF as included for its Microsoft 365 columns, while its Mac connector list does not include PDF. A missing button, a component-installation error and a PDF that imports incorrectly need different solutions.

Start here: on Windows, look under Data > Get Data > From File > From PDF. If that entry is absent, identify the product and build first. On Mac, do not spend the afternoon looking for a hidden PDF toggle: the current Mac documentation does not list a native PDF import connector. Ask for the source spreadsheet or use an approved conversion workflow instead.

This is a documentation-based troubleshooting guide, checked on October 3, 2026, not a hands-on test of every Excel edition. Where Microsoft's public tables do not settle a version-specific question, that uncertainty is stated below. The goal is to get you to usable, checked data—not promise that one setting will restore a feature your installation may not support.

Match your situation before trying a fix

The word “Excel” can mean a Windows desktop installation, a Mac subscription, a perpetual Office license or a workbook open in a browser. Start with that distinction rather than comparing your ribbon with the first screenshot you find.

The Microsoft connector availability matrix is the source for those distinctions. Its Windows table still uses older edition columns and plan labels. Treat it as evidence for what it actually lists, not a complete buying guide for every current license.

1. Identify the installation, not just the Excel icon

On Windows, open File > Account and read Product Information. Record the product name and then select About Excel for the full version/build and whether Office is 32-bit or 64-bit. On Mac, use Excel > About Excel. A workbook filename, the appearance of the ribbon or the fact that a Microsoft account is signed in does not identify the installed license by itself.

Microsoft's version-identification instructions explain where the product information lives. Keep the edition and build together: “Office Professional Plus 2019 on Windows” is useful evidence; “the latest Excel” is not precise enough for support.

Also distinguish a missing command from a hidden ribbon. If the whole ribbon is collapsed on Windows, Ctrl+F1 expands or collapses it. If the Data tab itself is missing, inspect the checked tabs under Customize the Ribbon. Do not reset all customizations as a first step; Microsoft notes that this also resets the Quick Access Toolbar. Restoring a visible tab does not install an unsupported connector.

Finally, confirm whether the workbook is open in desktop Excel or in a browser. A Microsoft 365 subscription does not make their interfaces and connector workflows identical. Record that distinction before comparing your setup with a coworker's working machine.

2. If you use Microsoft 365 on Windows, check the supported path

Open a blank workbook and look for Data > Get Data > From File > From PDF. This is the route in Microsoft's Excel import instructions. Do not confuse it with inserting a PDF as an object or exporting the workbook to PDF; neither imports the document's tables.

If the connector should be available for your installation, save your work and use the supported update process: File > Account > Update Options > Update Now. Microsoft's Windows Office update guide notes that Enable Updates may appear first. Reopen Excel after an approved update and check the menu again.

If Update Options is missing, do not conclude that Office is damaged. Microsoft says a volume-license installation or organization-managed updates can produce that interface. Ask your help desk about the installed product and update mechanism instead of changing update channels, running registry scripts or downloading an unrelated connector package.

If the command remains missing, the useful next step is a support request containing the edition, build, platform and a screenshot of the expanded menu. If it worked before, include the last known working date and any installation or account changes. Those observations help investigate the cause; they do not prove that signing out, reinstalling Office or buying a different license will fix it.

3. Why Power Query on Mac does not imply PDF support

Microsoft's Power Query guide for Excel on Mac documents sources such as Excel workbooks, Text/CSV, XML and JSON. Its Power Query Editor is generally available to Microsoft 365 subscribers on version 16.69 (23010700) or later. That version requirement is for the editor—not a statement that a From PDF connector was added.

This matters when a tutorial says “update Excel to get Power Query.” You may successfully update, open the editor and still not have the Windows PDF import option. The current Mac source list does not document it. Do not present installing a COM add-in, copying a Windows ribbon layout or pasting an M function into a blank query as a supported way around that difference.

A practical Mac workflow is to obtain CSV or XLSX from the sender, bank portal or business system, then import that supported format. Where only a PDF exists, use a conversion or OCR product that your organization approves, review the exported data and bring that result into Excel. The conversion takes place before the spreadsheet workflow; it does not add a native PDF connector to Mac Excel.

Opening a workbook that contains values previously imported on Windows is another separate case. Being able to read those cells does not establish that the original PDF query can refresh on the Mac. For collaboration, agree whether you are sharing a static data snapshot or a refreshable query, and identify which supported environment owns refreshes.

For what to do with a verified table afterward, our Excel and Google Sheets workflow guide covers analysis and cleanup. Formula assistance comes after correct data import; it is not evidence that a missing connector has become available.

4. Be careful with Excel 2016, 2019, 2021 and 2024 advice

Windows Excel 2016 and later include the Power Query experience, but Microsoft's feature table shows differences between editions. In its Office 2016 and 2019 standalone columns, the PDF row is not marked included—even where other advanced connectors are. Seeing Get Data, From Text/CSV or Blank Query is therefore not proof that PDF import should appear.

For Excel 2021, Excel 2024 and LTSC licenses, the same table does not provide separate Windows columns that settle every case. Some third-party guides give confident yes/no answers for these editions. The reviewed primary sources do not justify turning those claims into a universal compatibility promise here.

Check the exact product and build with Microsoft or your administrator before paying for an upgrade specifically to obtain PDF import. Updating an installation and upgrading its license are different operations. Neither should be recommended blindly on the strength of a generic “Applies To” banner at the top of a support article.

The same caution applies to older Power Query add-in advice. An add-in instruction written for an older Excel generation is not automatically relevant to a version where Get & Transform is built in. No add-in workaround is needed for the documented Microsoft 365 Windows menu, and the sources above do not establish one that adds native PDF import to Mac Excel.

5. If From PDF exists but asks for additional components

An error that appears after selecting the PDF connector is a different branch. Microsoft's Excel import article explicitly discusses the message “This connector requires one or more additional components to be installed before it can be used.” In its PDF section, it specifies .NET Framework 4.5 or higher.

There is a documentation caveat worth knowing: the broader, newer Power Query PDF connector reference currently lists “Prerequisites: None.” The sources are not perfectly aligned. Follow the Excel-specific instructions for that exact error and have IT verify the appropriate supported components for your Windows installation. Do not download an obsolete framework installer just because a tutorial repeats “4.5.”

Most importantly, do not treat this component guidance as proof that .NET will create an absent PDF menu. The documented error is about using the connector. If the command is missing altogether, return to the platform and edition checks instead of applying an error-specific fix to a different symptom.

6. When import opens but the PDF data is wrong

Once Navigator opens and shows PDF tables, you have passed the availability question. Choose the relevant table and use Transform Data to inspect it before loading. An empty preview, misplaced columns or missing rows now needs document-level investigation, not another search for an enable-connector switch.

Try selecting text in the PDF and copying a small, non-sensitive value into a text editor. An image-only scan may have no searchable text layer; an existing OCR layer may contain recognition errors. Adobe's OCR guidance explains how recognition adds searchable text. Do not rely on PDF import as an OCR workflow, and do not assume that successful OCR guarantees accurate rows or amounts.

Inspect the first, middle and last pages. Repeated headers can become data rows, a description can wrap onto another line, and the last page may use a different layout. Microsoft specifically discusses multiline-row cleanup with Table.FillDown or Table.Group where appropriate. Neither is a universal cleanup recipe: filling down every blank or deleting every error can change legitimate records.

For a large document in a supported Power Query environment, the PDF reference suggests inspecting smaller page ranges. This optional M example limits discovery to pages 1–2 and stops automatic combining of similar consecutive-page tables:

let
    Source = Pdf.Tables(
        File.Contents("C:\YourFolder\sample.pdf"),
        [StartPage = 1, EndPage = 2, MultiPageTables = false]
    )
in
    Source

Replace the example path with an authorized local PDF. This is a documentation-based example, not runtime-tested in Excel, and not a workaround for an unsupported Mac connector. It returns the outer navigation table, including nested Data tables; it does not automatically produce one clean row per invoice. Inspect the returned items and select the intended table before expanding anything. See the Pdf.Tables reference for the option definitions.

Keep page or source-file references while cleaning financial data. Compare row counts, identifiers, signs and totals with the original. A matching grand total alone cannot rule out swapped fields, missing descriptions or compensating errors. If several invoices have different layouts, do not assume a single folder-combine transformation will correctly map them all.

7. Alternatives that solve the data task without restoring the button

Ask for structured data first. A source CSV or XLSX usually avoids reconstructing a visual PDF layout. Ask the sender whether the same report can be exported from the original system, including the date convention and currency. Keep the PDF as a reference for checking the result.

Use an approved PDF converter when necessary. Decide whether you need table extraction, OCR or just document search; these are not interchangeable. Our PDF tools comparison discusses those broader categories. Check the product's supported document types, retention and processing location before uploading confidential invoices. A “free” label is not permission to share employer or client records.

Treat Word conversion as an optional bridge, not a guaranteed table extractor. Microsoft's PDF-in-Word guide says conversion works best with mostly text documents and can change layout. Where your Word version supports opening that PDF, inspect the converted table before copying it. This is not a promise that every Word edition or Mac workflow supports PDF opening, or that complex invoice columns will survive intact.

Use JSON only when it is the actual source format. If your business application supplies an authorized JSON export rather than a PDF, our JSON to CSV converter can help prepare a spreadsheet file. It does not read PDFs or restore Excel's PDF connector. Avoid sending confidential source records to a public tool unless the data-handling arrangement is approved.

8. Preserve identifiers and dates in the replacement file

A successful conversion is not the end of the check. Spreadsheet software can interpret text-looking numbers and dates automatically. Consider this synthetic CSV, where the sender defines dates as day/month/year:

InvoiceID,InvoiceDate,Amount
000123,03/10/2026,125.50
000124,04/10/2026,240.00

The first date means 3 October 2026, not March 10. The invoice ID is 000123, not 123. Import through Text/CSV and inspect the transformation steps rather than double-clicking the file and assuming Excel chose correctly.

Preserve the identifier column as Text before numeric conversion. If Power Query already added a Changed Type step that stripped zeros, remove or replace the relevant conversion and return to the original text—not simply change the damaged number back to Text. The missing digits cannot be recovered reliably from that converted value alone.

For dates, Microsoft's data-type and locale guidance documents Change Type > Using Locale. Remove or replace any earlier incorrect date conversion first, then apply this step to the original text. For this example, choose Date with English (United Kingdom) and verify day 3, month 10. Changing the locale of an already misinterpreted date does not recreate the original text. Choose the locale matching the real source, not the language of this article, and inspect amount separators too.

If you need to inspect textual changes between two sanitized exports, our Diff Checker can highlight line differences. It is not an accounting reconciliation tool and cannot certify that a conversion is correct. The final check remains comparison with the original authorized source.

What to send to your help desk

Keep the report short and specific. Include the platform, desktop versus web, exact Office product/build, whether all of Get Data is missing or only From PDF, and the exact error if one appears. Add a cropped menu screenshot with account identifiers removed and list the safe checks already attempted.

Use a small synthetic PDF if support needs a reproduction. Do not post a real bank statement, invoice, product key or account token in a public forum. A useful report lets the next person distinguish unsupported availability, a local installation problem and a troublesome document without guessing.

If the Copilot button is what you cannot find rather than the PDF connector, that is a licensing and update-channel question; our Copilot in Excel not showing guide covers the license labels, the relocated button and the retired COPILOT function.

Bottom line: verify support before changing the installation. If the connector is unavailable in your environment, use a supported data format. If the connector opens, investigate the PDF and imported values. These are different jobs, and treating them separately saves unnecessary reinstalls.

Sources and Image Credits

Product documentation reviewed October 3, 2026: Microsoft Power Query source availability by Excel version, Power Query on Mac, Excel import instructions, PDF connector reference, Pdf.Tables options, Office version identification, Mac Excel version menu, Windows Office updates, ribbon visibility, ribbon customization, data types and locale, leading zeros, PDF conversion in Word, and Adobe OCR guidance. Platform features and documentation can change. No Windows/Mac compatibility or extraction benchmark was performed for this article.

Photos are licensed illustrations, not screenshots of the author's Excel installation: cover by Mikhail Nilov; body images by Jakub Zerdzicki, Pavel Danilyuk, Artem Podrez and Nataliya Vaitkevich, used under the Pexels license.