What "adding a PDF to Excel" actually means

When you add a PDF to Excel, you are inserting the PDF file into a spreadsheet so it appears as an object you can click on or view. Excel does not convert the PDF into cells and data — it embeds the file itself. You end up with a clickable icon or preview in your spreadsheet that opens the PDF when you double-click it, or in some cases, a static image of the PDF pages.

This is different from extracting data from a PDF into Excel cells, which requires separate steps. If you need the numbers or text from a PDF to become actual spreadsheet data, you will need to copy and paste it manually or use a different method.

Key Takeaways

  • You can embed a PDF as an object in Excel on Windows using Insert > Object > Create from File, which lets you click the icon to open the PDF.
  • On Mac, the process is similar but found under Insert > Object, and the steps vary slightly depending on your Excel version.
  • Embedding a PDF as an image (Insert > Pictures) creates a static snapshot of the first page, which cannot be clicked to open the full document.
  • If you need the text or numbers from the PDF to become spreadsheet data, copying and pasting directly is usually faster than embedding.
  • Embedded PDFs increase your file size and may not work if you share the spreadsheet with someone who does not have the PDF reader installed.

Embedding a PDF as a clickable object on Windows

Open your Excel spreadsheet and click the cell where you want the PDF to appear. Go to the Insert tab at the top, then click Object (you may need to look under a dropdown menu labeled "Text" or similar, depending on your Excel version). A dialog box will open.

In the dialog, click the Create from File tab. Click Browse, navigate to the PDF file on your computer, select it, and click Open. Back in the dialog, you can check the box labeled Display as Icon if you want only an icon to show in the cell, or leave it unchecked to show a preview of the first page. Click OK.

The PDF is now embedded. When you or someone else opens the spreadsheet, they can double-click the icon or preview to open the full PDF. The PDF file itself is stored inside the Excel file, so the spreadsheet will be larger than before.

Embedding a PDF on Mac

Click the cell where you want the PDF. Go to Insert in the menu bar, then select Object. A dialog will appear asking whether you want to create a new object or use an existing file. Click Create from File.

Click Choose File, find the PDF on your computer, and click Open. You will see options for how to display it. Check Display as Icon to show only an icon, or leave it unchecked for a preview. Click OK to insert it.

On some Mac versions, you may instead use Insert > Picture > Picture from File, which inserts the PDF as an image rather than an embedded object. This method shows a static picture of the first page only and cannot be clicked to open the full document.

Inserting a PDF as an image instead

If you want a visual preview of the PDF in your spreadsheet but do not need it to be clickable, you can insert it as a picture. On Windows, go to Insert > Pictures > This Device, find your PDF, and click Insert. On Mac, use Insert > Picture > Picture from File.

Excel will convert the PDF to an image and place it in your spreadsheet. You can resize it by dragging the corners. This method shows only the first page of the PDF and creates a static image — clicking it will not open the full document. The file size increase is usually smaller than with embedding, but you lose the ability to access the full PDF from within Excel.

When embedding a PDF causes problems

Embedded PDFs only work if the person opening the spreadsheet has a PDF reader installed (most computers do, but not all). If you share the file with someone and they cannot open the embedded PDF, they will see only a broken icon or blank space.

Embedded files also make your Excel file much larger. A spreadsheet with one embedded PDF might jump from 100 kilobytes to several megabytes, depending on the PDF size. If you need to email the file or upload it to a shared drive with size limits, this can become a problem.

If the PDF is sensitive or changes frequently, embedding it is not ideal — the spreadsheet will contain an old copy of the PDF, and updating it means replacing the embedded file and resaving the entire spreadsheet.

Copying PDF text into Excel cells instead

If you need the actual data from the PDF — numbers, names, dates — embedding is not the right tool. Open the PDF in your PDF reader, select the text or table you need, and copy it. Click the cell in Excel where you want it to go, and paste.

Excel will try to place the data into cells automatically. If the PDF contained a table, it usually pastes as a table. If it was unformatted text, you may need to clean it up — remove extra spaces, split text into separate columns, or reformat numbers. This takes more work than embedding but gives you data you can actually use in formulas and calculations.

For large PDFs with many pages of data, copying and pasting page by page is slow. In those cases, look for a way to read the data in a format Excel prefers, like CSV or XLSX, rather than working from a PDF at all.

Frequently Asked Questions

Can I embed a PDF that is stored online, like on Google Drive or OneDrive?

Not directly through the Insert > Object method — that requires a file path on your computer. You can read the PDF to your computer first, then embed it. Alternatively, you can insert a link to the online PDF instead of embedding it, which keeps your file smaller.

What happens to the embedded PDF if I move or delete the original file?

Nothing — the PDF is stored inside the Excel file now, so the original file can be deleted or moved without affecting the spreadsheet. The embedded copy remains.

Can I edit the PDF after I embed it in Excel?

No. The embedded PDF is a copy. If you edit the original PDF file, the copy in Excel will not update. You would need to delete the embedded version and embed the updated PDF again.

Is there a way to convert a PDF table into Excel cells automatically?

Some PDF readers and online tools can extract tables from PDFs and convert them to CSV or Excel format, which you can then open in Excel. This works better than copying and pasting if the PDF has many tables. Search for "PDF to Excel converter" to find options, but test with a small sample first to make sure the conversion is accurate.

Why does my embedded PDF show only a blank icon?

This usually means the PDF reader is not installed on the computer opening the file, or the embedded file became corrupted. Try deleting the embedded object and embedding the PDF again. If the problem persists, try inserting it as an image instead.