Why Excel Cannot Import Data from PDF Files on Mac
Question details
The user needs to import tabular data from a PDF into Excel on a Mac but cannot find the PDF data connector.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- A Mac user opens Excel and tries to use Get Data from a PDF file, but the PDF connector is unavailable.
- Observed behavior
- The PDF data connector is missing or unavailable in some Mac versions, even with a Microsoft 365 subscription, because connector availability depends on the operating system and Excel build.
Before trying the workarounds, confirm your exact macOS version and Excel build, then check for Microsoft 365 updates. If you have access to Excel for Windows or Power Query in another supported environment, keep it available for testing the PDF connector.
Check the Excel build and install available Mac updates
Use this first to rule out an older Excel build that does not include the PDF connector.
In Excel for Mac, go to the Excel menu and select About Excel to view your current version and build number.
Click Help > Check for Updates in Excel, or open Microsoft AutoUpdate, and install any pending Microsoft 365 updates.
Restart Excel, open a blank workbook, and go to Data > Get Data > From File > From PDF to see whether the connector now appears.
Use Excel for Windows or Power Query in another supported environment
Use this when the Mac build does not expose the PDF connector but you still need to use Microsoft's native PDF import.
Convert the PDF to an Excel-compatible format before importing
Use this direct Mac workaround when the PDF connector is unavailable and you want to open PDF data in Excel immediately.
Import PDF Data into a Spreadsheet on Mac with WPS Office
Instead of waiting for the Excel PDF connector, use WPS Office on Mac to open the PDF and convert its data to an editable XLSX spreadsheet, then review and analyze the imported data in WPS Spreadsheets.
- 1. Open the PDF in WPS Office: Launch WPS Office on your Mac and open the PDF file that contains the data you want to import.
- 2. Select the PDF to Excel conversion tool: In the PDF viewer, go to the Convert tab and choose PDF to Excel, or use the Tools menu to select PDF to Excel.
- 3. Convert the file: Choose the output folder and click Convert to create an .xlsx file from the PDF data.
- 4. Review the imported data: Open the converted .xlsx file in WPS Spreadsheets and check the imported tables, rows, and columns.

Frequently Asked Questions
Why is the PDF data connector missing from Excel on my Mac?
The PDF connector availability depends on your macOS version and Excel build. Some Mac versions do not expose it even with a Microsoft 365 subscription, so it may be missing until Microsoft delivers the feature for your build.
Can I import PDF data into Excel for Mac without the PDF connector?
Yes. Use Excel for Windows or Power Query in another supported environment, or convert the PDF to XLSX or CSV first and open the converted file in Excel for Mac.
How do I check for Excel updates on Mac that might add the PDF connector?
Open Excel, go to Help > Check for Updates or run Microsoft AutoUpdate, install available Microsoft 365 updates, restart Excel, and then try Data > Get Data > From File > From PDF.
Does WPS Office provide a PDF to Excel converter on Mac?
Yes. You can open the PDF in WPS Office, use the Convert tab or Tools menu and choose PDF to Excel, then edit the resulting XLSX file in WPS Spreadsheets.
What should I check after converting a PDF to Excel?
Verify the imported table structure, column headers, and row alignment, because complex PDF layouts may not convert perfectly and might need manual cleanup.





