How to Add a PDF to Excel: Methods, Use Cases, and What to Expect
Adding a PDF to Excel sounds straightforward, but there are actually several distinct ways to do it — and which approach works best depends entirely on what you're trying to accomplish. Are you embedding the file as a clickable attachment? Importing tabular data from the PDF into cells? Displaying a static image of the document? Each of these is a different operation with different results.
Here's a clear breakdown of how each method works, what it requires, and where things get complicated.
What "Adding a PDF to Excel" Actually Means
The phrase covers at least three separate tasks:
- Embedding a PDF as an object — the file sits inside the Excel workbook as a linked or embedded icon; clicking it opens the PDF in a viewer
- Inserting a PDF as an image — a snapshot of the PDF page is placed directly on the spreadsheet canvas
- Importing PDF data into cells — the actual text and numbers from the PDF are extracted and pulled into Excel rows and columns
Each method uses different tools and produces a very different result in your spreadsheet.
Method 1: Embedding a PDF as an Object
This is the most common approach when you want to attach a reference document to a workbook without breaking it into data.
How it works:
- Go to the Insert tab in Excel
- Click Object (in the Text group)
- Select Create from File
- Browse to your PDF and choose whether to link to the file or embed it
When you embed the PDF, a copy is stored inside the .xlsx file itself — the workbook becomes larger, but the PDF travels with it. When you link it, Excel stores only a reference path; the PDF must remain in the same location for the link to work.
The embedded object appears as an icon (usually the Adobe Acrobat logo or a generic file icon). Double-clicking it opens the file in whatever PDF viewer is installed on that machine.
Key limitation: This is not the same as viewing PDF content inside Excel. It's closer to a file attachment stapled to the spreadsheet.
Method 2: Inserting a PDF Page as an Image 📄
If you need to display the visual content of a PDF page directly on the sheet — a logo, a signed form, a certificate — you can convert the PDF page to an image first, then insert it.
Common workflow:
- Export or screenshot a PDF page as a PNG or JPG
- Use Insert > Pictures in Excel to place the image on the sheet
- Resize and position as needed
Some PDF tools (including Adobe Acrobat, Foxit, and browser-based converters) can export individual pages as image files. Once it's an image, Excel treats it like any other graphic.
What you lose: The text in the image is not selectable or searchable in Excel. It's purely visual.
Method 3: Importing PDF Data Into Excel Cells
This is the most technically demanding method — and the most powerful if your PDF contains structured data like tables or reports.
Microsoft 365 / Excel 2019+ approach: Excel has a built-in Get Data from PDF feature (under Data > Get Data > From File > From PDF). This uses Power Query to parse the PDF and identify tables, which are then loaded into the worksheet as structured data.
This works well when:
- The PDF was originally generated from a digital source (not scanned)
- The tables in the PDF have consistent formatting
- Column boundaries are clearly defined
It works poorly when:
- The PDF is a scanned document (an image, not text-based)
- Tables span multiple pages with varying layouts
- The PDF uses unusual fonts or merged cell structures
For scanned PDFs, you need OCR (Optical Character Recognition) first. Tools like Adobe Acrobat Pro, ABBYY FineReader, or online converters can process a scanned PDF, recognize text, and output an Excel-compatible file — but accuracy varies significantly based on scan quality and document complexity.
Factors That Shape Your Results 🔧
| Factor | Why It Matters |
|---|---|
| Excel version | Power Query PDF import requires Excel 2019 or Microsoft 365; older versions lack this feature |
| PDF type | Text-based PDFs import far more cleanly than scanned/image PDFs |
| PDF structure | Well-formatted tables extract reliably; unstructured layouts often require manual cleanup |
| Operating system | Mac versions of Excel have historically lagged on Power Query features |
| Third-party tools | Some converters produce cleaner Excel output than Excel's native import |
| File size | Large, multi-page PDFs with complex layouts can produce messy or incomplete extractions |
When the Same Method Produces Different Results
Two people following identical steps can get very different outcomes. A finance professional importing a bank statement PDF in Microsoft 365 on Windows may get clean, perfectly structured data in seconds. Someone on Excel for Mac 2019 trying to import a scanned invoice may find the feature unavailable or the output unusable without extensive cleanup.
The embedding method is consistent across most Excel versions and platforms — it's the least likely to break. The data import method is the most variable, depending on software version, PDF quality, and document structure.
The Version and Platform Gap Worth Knowing
Microsoft has expanded PDF import capabilities significantly in recent Microsoft 365 builds, with Power Query receiving ongoing updates. If you're on a perpetual license version of Excel (2016, 2019), some features available in Microsoft 365 subscriptions may be missing or limited.
Mac users in particular should verify which Power Query features are available in their specific Excel version before assuming the Windows workflow will transfer directly.
What actually works for your situation depends on your Excel version, the nature of your PDF, and what you need the data to do once it's in the spreadsheet.