Office for Mac Issues

Fix Excel for Mac Missing PDF Data Import Feature: Solutions & Workarounds

Huda Qurayshi Oct 10, 2026 868 views

Question details

Users are unable to import or extract tabular data from PDF files in Excel for Mac because the specific Power Query PDF data-import capability available in Excel for Windows is not supported in the same way.

How to Overcome PDF Data Import Limitations in Excel for Mac

Product: Microsoft Excel for Mac
Device & OS: Mac
Scenario: Attempting to extract tables and data from a PDF document directly into an Excel spreadsheet for editing and analysis.
Observed behavior: The PDF data-import option is completely missing or fails to upload the file. Inserting the PDF as an object only attaches the file visually and does not extract the underlying tabular data.

Before you start

Before proceeding, determine whether you need to extract editable tabular data from the PDF or simply attach the PDF file as a reference document inside your spreadsheet, as the methods for Mac differ significantly.

Solution 1Recommended

Insert the PDF as an Embedded Object

Use this method if you only need to attach the PDF document to your spreadsheet for visual reference, without extracting its tabular data.

Excel for Mac allows you to embed files directly into your worksheet. While this does not pull the data into individual cells, it keeps the source document easily accessible for anyone reviewing the spreadsheet.

Open the Insert Menu

Launch Excel for Mac, open your workbook, and navigate to the 'Insert' tab on the top ribbon.

Select the Object Option

Click on 'Object' located in the Text group to open the object insertion dialog box.

Choose Create from File

Click the 'From File...' button (or 'Create from File' depending on your Excel version) and locate the PDF on your Mac.

Insert the PDF

Select the PDF and click 'Insert'. The file will now appear as an embedded icon or preview within your worksheet.

Data Extraction Limitation: This method embeds the PDF as a whole file. It will not parse or populate Excel cells with the text or numbers contained inside the PDF.

Solution 2

Use an External PDF to Excel Converter Tool

Since Excel for Mac lacks a native PDF data extraction tool, using a dedicated PDF converter is the best way to get tabular data into Excel.

Built-in PDF Editor & Converter

Extract PDF Data Natively Using WPS Office

Skip the limitations of Excel for Mac entirely. WPS Office features a powerful, built-in PDF to Excel converter that seamlessly extracts tabular data from PDFs directly into editable spreadsheets without requiring third-party plugins.

1. Open WPS Office: Launch WPS Office on your Mac and navigate to the 'PDF' tab on the welcome screen.
2. Select PDF to Excel: Click on the 'PDF to Excel' tool located in the main PDF toolbar.
3. Add Your PDF File: Drag and drop the PDF document containing the data you want to extract into the conversion window.
4. Convert and Edit: Click 'Convert'. WPS Office will automatically extract the tables and open them in a new, fully editable spreadsheet.

Built-in PDF to Excel conversion without leaving the appHighly accurate tabular data extraction and formatting retentionFully compatible with Microsoft Excel (.xlsx) file formatsLightweight, fast, and fully optimized for macOS devices

microsoft office alternative - wps office

Frequently Asked Questions

Will Microsoft add the PDF Data Import feature to Excel for Mac?

While Microsoft frequently updates Office 365, the Power Query functionality on Excel for Mac is currently restricted compared to the Windows version. Direct PDF data extraction via Get Data is not natively supported yet, so users must rely on external converters or embed the file as an object.

Why doesn't 'Insert Object' extract my PDF data?

The 'Insert Object' feature is designed to embed the PDF as an attachment or an image preview. It does not possess optical character recognition (OCR) or table parsing capabilities, meaning it cannot read or distribute the internal numbers and text into individual Excel cells.

Can I use Power Query on Mac to import PDF data?

Currently, Power Query in Excel for Mac supports a limited number of data sources (like local text/CSV files and some SQL databases). It does not yet include the 'From PDF' connector that allows Windows users to seamlessly parse and import PDF tables.

Office App Problems