The simplest way: embed the PDF as an object

Excel can hold a PDF file inside a spreadsheet without converting it. The PDF stays as a separate file within the sheet — you click it to open and read it, but the data inside the PDF does not become editable cells. This is the fastest route if you just need the PDF visible alongside your numbers.

Open the Excel file where you want the PDF to appear. Click the cell where you want the PDF to sit. Go to the Insert tab at the top, then click Object (in the Text group). A dialog box opens. Click the Create from File tab. Click Browse, find your PDF file, and select it. Check the box that says Display as Icon if you want a small clickable icon instead of a preview. Click OK.

The PDF now lives in that cell. Anyone who opens the spreadsheet can double-click it to read the full document. The PDF file itself stays separate — changes to the original PDF file will not automatically update the copy in Excel, and changes in Excel do not affect the PDF.

Key Takeaways

  • Embedding a PDF as an object keeps the file intact and readable but does not let you edit the PDF data as spreadsheet cells.
  • The Insert > Object > Create from File route works on Windows and Mac and takes about 30 seconds.
  • If you need the actual numbers or text from the PDF to become editable cells, you must copy and paste the content manually or use a conversion tool outside Excel.
  • Linked PDFs update when the original file changes, but embedded PDFs do not — choose based on whether your source document will be revised.

When to link the PDF instead of embedding it

A linked PDF stays in its original location on your computer or network, and Excel just shows a connection to it. If the original PDF changes, the link in Excel updates automatically. An embedded PDF is copied into the Excel file itself, so it never changes unless you replace it manually.

Link a PDF if the source document is updated regularly and you want the spreadsheet to always show the current version. For example, if you have a master PDF price list that gets revised monthly, linking it means your Excel sheet always pulls the latest prices without you having to re-insert the file each time.

To link instead of embed: follow the same Insert > Object > Create from File steps, but do not check the "Display as Icon" box. Instead, check Link to File. Now the PDF in Excel points to the original file. If someone moves or deletes the original PDF, the link breaks and Excel shows an error.

Copying text or data from a PDF into cells

If you need the actual content from the PDF — numbers, addresses, names — to live in your spreadsheet as editable data, embedding or linking will not work. You need the text to become part of the spreadsheet itself.

Open the PDF in a PDF reader (Adobe Reader, Preview on Mac, or your browser). Select the text or table you want. Copy it (Ctrl+C on Windows, Command+C on Mac). Click the Excel cell where you want the data to start. Paste it (Ctrl+V or Command+V). Excel will try to organize the content into columns and rows, though the formatting may need adjustment.

If the PDF is a table with many rows, this manual approach gets tedious. Some people use free online PDF-to-Excel converters, though you should only use these if the PDF contains no sensitive information — the file uploads to a third-party server. Alternatively, if the PDF came from an Excel file originally, you may be able to recover the original file from whoever created the PDF.

Why the data from a PDF does not automatically become cells

A PDF is a visual format — it shows you what a document looks like when printed, but it does not store information in a way Excel can read as structured data. When you embed or link a PDF, Excel treats it as a picture or document object, not as a table of numbers.

If you copy text from a PDF and paste it into Excel, the software does its best to guess where columns and rows should be, but PDFs often have formatting that confuses this process. A table that looks neat in a PDF might paste into Excel as a jumbled mess because the PDF does not tell Excel where the actual column breaks are.

File size and performance

Embedding a PDF makes your Excel file larger. A 2 MB PDF embedded in a spreadsheet adds roughly 2 MB to the file size. If you are embedding many PDFs or very large ones, the Excel file can become slow to open and difficult to share by email.

Linking a PDF keeps the Excel file small because only the link is stored, not the actual PDF. The downside is that the link only works if the original PDF stays in the same location. If you move the Excel file to a different computer or folder, the link may break.

For most situations, embedding works fine unless you are dealing with dozens of large PDFs. If file size is a concern, link instead, or store the PDFs in a shared folder that everyone on your team can access.

Troubleshooting common problems

The Insert > Object menu does not appear: You may be using Excel Online (the web version) instead of the desktop version. Excel Online does not support embedding objects. read and install the desktop version of Excel, or use a workaround like taking a screenshot of the PDF and pasting the image into the spreadsheet.

The PDF appears as a blank icon: This usually means the PDF is corrupted or Excel cannot read it. Try opening the PDF in a different reader to confirm it works. If it does, try embedding it again. If the PDF still appears blank, the file may have a format issue.

The link broke and shows an error: The original PDF was moved, deleted, or renamed. Find the PDF, move it back to its original location, or delete the broken link and re-insert it pointing to the new location.

The file is too large to email: If you embedded a large PDF, consider linking it instead and storing the PDF in a shared folder. Or remove the PDF from the spreadsheet, save the file separately, and send both files together.

Frequently Asked Questions

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

No. The embedded PDF is a snapshot. You can view it by double-clicking, but changes you make inside the PDF viewer do not save back to Excel. To edit the PDF, you must edit the original file separately, then re-embed it if you want the updated version in Excel.

What happens if I share the Excel file with someone else?

If you embedded the PDF, they will see it because it is stored inside the file. If you linked it, they will only see the link work if the original PDF is in the same location on their computer or network. Embedding is safer for sharing.

Can I embed multiple PDFs in one spreadsheet?

Yes. Insert each PDF into a different cell or area of the sheet using the same Insert > Object method. Be aware that the file size grows with each PDF you add.

Is there a way to automatically pull data from a PDF into Excel cells?

Not built into Excel. You would need third-party software or a PDF-to-Excel converter tool. For one-time conversions, free online converters work, but for regular automated updates, you may need a paid tool or custom programming.

What is the difference between a PDF and an image of a PDF?

A PDF is a document format that can contain text, images, and formatting. An image is a picture of what the PDF looks like. If you paste a screenshot of a PDF into Excel, it is just a picture — you cannot select or copy the text from it. Embedding the actual PDF file preserves the ability to open and read it properly.