30 Advanced Excel Tips for 2026

Excel Champs / Advanced Excel / How to Insert PDF into Excel
By Puneet Gogia (Microsoft MVP)

How to Insert PDF into Excel

To attach a PDF to a sheet, go to Insert ? Text ? Object, open the Create from File tab, click Browse, pick the PDF, tick Display as icon and click OK. The PDF is stored inside the workbook and opens with a double-click.

Leave Link to file unticked if you will send the workbook to anyone. A linked PDF is not stored in the file, so it will not open on another computer.

To bring the tables from a PDF into cells instead, go to Data ? Get Data ? From File ? From PDF, pick the file, select a table or page in the Navigator and click Load. Click Transform Data instead of Load to tidy the columns in Power Query first. When the PDF is replaced by a new version with the same name, Data ? Refresh All updates the import.

From PDF is in Excel for Microsoft 365 on Windows. Excel 2019 does not have it, and Excel for Mac has not offered it, so check the Get Data list in your version before relying on it.

A scanned PDF holds pictures of text rather than text, so From PDF finds no tables in it. Take a screenshot of the table and use Data ? From Picture to turn it into cells, then check the numbers against the original.

Microsoft Excel can insert PDF documents into the spreadsheet without affecting the data set. Users can insert or embed PDF documents within the spreadsheet when they want to share and refer to that PDF document along with the spreadsheet.

This tutorial will guide you on how to insert PDF files quickly in any spreadsheet.

Insert PDF into Excel as an Object

You can insert the PDF document as an object in the spreadsheet.

And once added, whenever you share or send that Excel file to any user, that user gets the embedded PDF with the Excel file and can open and save that PDF (as long as it’s embedded and not linked; see step 5).

  1. First, open a workbook where you want to insert the PDF document as an attachment.
  2. After that, go to the “Insert” tab and click on the “Text” icon and then click on the “Object” option.
    text-icon-in-ribbon
  3. Here, in the “Object” dialog box, click on the “Create from File” tab and then on the “Browse” button to choose the PDF file from your system.
    create-from-file-tab
  4. After selecting the file, select the “Display as icon” option so that the PDF shows as a small icon in the sheet (without it, Excel shows the first page of the PDF), and click OK.
  5. If you want the PDF in Excel to show the changes that you make in the original PDF document, also select the “Link to file” option. A linked PDF isn’t stored inside the workbook, so other people can only open it if they can reach the original file in the same location.
    select-display-as-icon
  6. After embedding the PDF, you can resize the icon to the size of the cell by hovering the mouse cursor over any of the round sizing handles and then dragging to shrink it so it fits into a cell.
    embedded-pdf-document
  7. Now, to lock the icon of the embedded PDF document to the cell, right-click on it and click on the “Format Object” option.
    lock-the-embedded-pdf
  8. In the end, in the “Format Object” dialog box, go to the “Properties” tab and then select the “Move and Size with cells” option so that the icon is locked to the cell and moves and resizes with it, and click OK.
    select-move-and-size-with-cells

Other Ways to Insert PDF into Excel

  1. If you have only a single-page PDF document, then you can convert it to an image (jpg, png) and add that image to Excel.
  2. If you have a data table in the PDF document and you want to insert that data table into Excel, convert the PDF into Excel format using a converter, or import it with Power Query (below).

Import a Table from a PDF with Power Query

In Excel for Microsoft 365 on Windows, you don’t need a converter to get the data out of a PDF. Power Query can read the tables in it:

  1. First of all, go to Data ➜ Get Data ➜ From File ➜ From PDF.
  2. After that, select the PDF file and click Import.
  3. Now, in the Navigator, pick the table (or page) you want, and you can see a preview on the right.
  4. In the end, click Load to put the data in a new sheet, or Transform Data to clean it first.

The data comes in as a table that you can refresh if the PDF is replaced with a newer one in the same location.

Frequently Asked Questions

Why is the Object option greyed out?

It’s not available in Excel for the web, on a protected sheet, or while you are editing a cell. Use the desktop app, unprotect the sheet, or press Esc to leave the cell first.

How do I open an embedded PDF?

Double-click the PDF icon. It opens in your default PDF reader, and you can save a copy from there.

Does embedding a PDF make the file bigger?

Yes. The whole PDF is stored inside the workbook, so the Excel file grows by about the size of the PDF. Linking keeps the workbook small, but the PDF must stay in the same place.