3 Ways To Insert a PDF Into Microsoft Excel as an Image

Are you wondering how to insert a PDF into Excel as an image? Tag along while I explain the process with clear steps and real illustrations.

Imagine needing to combine an Excel spreadsheet with a PDF document. Itโ€™s like needing to mix oil and waterโ€”they just donโ€™t blend on their own.

This skill can be frustrating if youโ€™re unsure how to make it work smoothly. Inserting a PDF into Excel as an image might seem tricky, but this tutorial breaks it down into easy steps.

Iโ€™ll guide you from start to finish, showing you exactly how to integrate your PDF content into your spreadsheet without the usual headache. Also, I’ll present multiple methods so you can take your pick depending on your Excel expertise level.

Letโ€™s dive in and get that PDF right where you need it in your Excel file.

Using the Excel Screenshot Tool

To embed a PDF document as an image, you must get a matching file for the source. The Excel Screenshot tool allows you to get an image of the document as well as import that into the destination worksheet.

Use any PDF viewer app to open the source document in one window.

Now, navigate to the worksheet where you’d like to insert the PDF file.

Available Windows
Available Windows

Click on the Screenshot command in the Illustrations block of the Insert tab.

You’ll see the PDF document’s thumbnail preview in the Available Windows panel.

Click on the PDF file’s thumbnail.

Added a screenshot in worksheet
Added a screenshot in worksheet

Excel will instantly add the screenshot as an image in the active worksheet.

Crop command
Crop command

Navigate to the Picture Format tab and click on the Crop command inside the Size block.

Cropping in Excel
Cropping in Excel

You can now crop the screenshot according to your preference.

Once you’re done cropping the image, click on any blank cell in the worksheet to complete the process.

That’s it! You’ve successfully imported a PDF file in an Excel sheet in an image format.

You’ll need Excel 2016 or a better desktop application to use this method.

Using the Insert Object Command

Excel’s Object Linking and Embedding (OLE) feature allows you to embed files from supported software, like Word, PowerPoint, Projects, Adobe Acrobat, and so on. It’s available in Excel 2016 and newer desktop apps.

Object command
Object command

Open the Excel sheet where you’d like to insert a PDF document as a picture.

Click on the Object command in the Text block of the Insert tab.

Object dialog box
Object dialog box

The Object dialog box will open.

Click on the Create tab and choose an Object type from the table. For example, you can choose Adobe Acrobat Document if you’re using this PDF viewer app.

Since I usually use the Foxit PhantomPDF app, I’ve selected the Foxit PhantomPDF FDF Document in the dialog box.

Once you select an object type, click on the OK button to insert it in the worksheet.

Import PDF
Import PDF

The Windows Explorer dialog box will open. Use that to select the PDF file you want to import. Click Open.

PDF as Shape object
PDF as Shape object

Navigate to the Excel worksheet. You’ll see a Shape object for the imported PDF document’s page.

Select the Shape and press Ctrl + C to copy the object.

Paste Special dialog box
Paste Special dialog box

Create a new worksheet, select a cell, and press Ctrl + Alt + V keys to open the Paste Special dialog.

Select Picture (JPEG) in the list of files and click OK.

Comverted Shape object to a JPEG image

Excel will convert the object into a picture and place it over the selected cell.

The downside of this method is it only imports the first page of the PDF file. Therefore, if your PDF file contains multiple pages, you must split it into different documents before importing it into Excel.

Using the Export Feature of a PDF Viewer

Most PDF viewer apps, like Adobe Acrobat, Foxit PhantomPDF, etc., allow you to export the pages of a PDF file as image files, like PNG, JPEG, etc.

Once you’ve converted the PDF into images, you can simply use the Pictures import command to insert the PDF as an image in the worksheet.

This method is suitable for most Excel desktop editions since you don’t need to rely on modern Excel features, like the Screenshot or OLE tool.

Export PDF to JPEG
Export PDF to JPEG

Open your PDF document with a PDF reader, like Foxit PhantomPDF.

Go to the Convert tab and click on the To Image drop-down menu.

Choose an image file type from the drop-down menu, like PNG, JPEG, etc.

Save image file
Save image file

You’ll see the Save As dialog box to select a destination for the converted image file.

Export a PDF in Adobe Acrobat
Export a PDF in Adobe Acrobat

If you’re using Adobe Acrobat Reader, navigate to the All tools tab and click on the Export a PDF option.

Image format
Image format

You’ll see the Convert navigation panel. There, select the Image format option in the Export PDF To section.

Hit the Convert button to save the PDF as an image file.

Place over cells
Place over cells

Now, go to the destination worksheet and click on the Pictures drop-down menu in the Illustrations block.

This Device
This Device

Hover the cursor over the Place over cells menu and click on the This Device option in the Insert Picture From context menu.

Insert image into Excel
Insert image into Excel

Use the Insert Picture dialog box to select the image created from the source PDF and hit Insert.

Excel will attach the inserted image to the active worksheet.

๐Ÿ“š Read more: If you’ve liked this Microsoft Excel tutorial, you might also want to check out the following excellent guides:

Conclusions

So far, you’ve learned how to insert a PDF into Excel as an image using the Screenshot tool, Insert Object dialog box, and the Insert Pictures command.

Did this Excel guide help you to learn a new skill? You can share your experience in the comment box. Also, if you know of a better technique to insert a PDF as an image that I might have missed to describe, mention that in your comment.

About the Author

Tamal Das

Tamal Das

I'm a freelance writer at HowToExcel.org. After completing my MS in Science, I joined reputed IT consultancy companies to acquire hands-on knowledge of data analysis and data visualization techniques as a business analyst. Now, I'm a professional freelance content writer for everything Excel and its advanced support tools, like Power Pivot, Power Query, Office Scripts, and Excel VBA. I published many tutorials and how-to articles on Excel for sites like MakeUseOf, AddictiveTips, OnSheets, Technipages, and AppleToolBox. In weekends, I perform in-depth web search to learn the latest tricks and tips of Excel so I can write on these in the weekdays!

Related Posts

Comments

2 Comments

  1. knklbrr

    The first 2 options only add the first page of the PDF, which is not helpful – it’s easier to just take a screenshot and insert that image. The option of converting the PDF to image requires paid features.

    Reply
    • John MacDougall

      Yes, unfortunately this is a difficult task without many great options.

      Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos ๐Ÿ˜ƒ