EaseUS PDF Editor

An all-in-one PDF editing software to create, manage and convert PDF files easily.

  • Easily merge, split, insert, extract, delete pages from PDF documents
  • Edit, compress, encrypt, sign, OCR, annotate PDF files with ease
  • Convert PDF files to Excel, Word, PowerPoint, images or vice versa
video editor

3 Quick Ways | How to Insert PDF into Excel in 2022

Crystal Chen updated on Oct 19, 2022 to PDF Editor Tutorials | min read

Update:
Recently, Microsoft is making a change to its Microsoft Office branding. Microsoft Office is being renamed by Microsoft 365. After the official renaming, our article content will be updated accordingly.

When you are preparing a presentation or delivering a report, references to statistics are essential. To save your time and energy, it would be a good choice to insert all the data files, including PDFs, into a single Excel. To some degree, importing PDF into Excel can make your Excel spreadsheet detailed and accurate.

This post is for those who are not familiar with the ways to insert PDF into Excel. The tutorials will guide you to import PDF to Excel with built-in tools and offer you alternative methods. Come and follow the steps.

Workable Methods Step-by-step Troubleshooting
Method 1. Insert it as an Object Firstly, open your Excel and click the "Insert" tab. Then, hit "Object" > "Text". Choose "Create from file" to ... >> More details
Method 2. Attach in Excel with Hyperlink Open the preferred spreadsheet and click the "Insert" > "Picture" option to insert the image into an Excel file...>> More details
Method 3. Embed PDF in Excel Launch Microsoft Excel and click "Insert". Then choose "Pictures" > "This Device..." to select the converted picture... >> More details
Special Way: Convert PDF to Excel file[Hot] Launch the PDF editor and click the "Open Files..." button to import the PDF that you want to convert to Excel...>> More details

Method 1. How to Insert PDF into Excel as Object 

The first way is inserting PDF into Excel as an object. This function is embedded in Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 365, and other versions. Merits of this type of method are evident - no third-party software is included, no money is charged, and both Mac and Windows users can gain access to this method. Next, you know how to insert a PDF into Excel without losing formatting.

Steps to Insert PDF in Excel as An Object:

Step 1. Open your Excel spreadsheet and navigate to the "Insert" tab.

Step 2. Then, select the "Object" option in the "Text" section in the right corner.

add pdf as object

Step 3. Choose "Create from file" and browse your folder to select the PDF you want to insert in the popping-up window.

create from file

Step 4. Click on the "OK" button to import the PDF into your Excel document as an attachment.

Method 2. How to Insert PDF into Excel with "Hyperlink" Feature  

The second method is not as easy as the first one. Microsoft Excel has a not very well-known feature. You can add a hyperlink to a picture, and the link can help you open a file when you click on it. In other words, you can first insert a picture into Excel and link the picture to the PDF file you want to import. When you want to display the PDF file, you need to click on the picture with hyperlink and confirm your choice.

How to Embed a PDF in Excel by Creating a Hyperlink:

Step 1. Open your preferred spreadsheet.

Step 2. On the "Insert" tab, click the "Pictures" option and insert an image into Excel.

insert pdf into excel as pictures

Step 3. Right-click the picture embedded into the Excel and select "Link."

Step 4. Now you can choose a PDF file and link it to the picture.

Tip
To make your link valid, you should make sure your Excel workbook and the hyper-linked file are located in the same place, which will prevent your link from not working.

Method 3. How to Embed PDF in Excel After Converting into Picture 

As mentioned above, Microsoft Excel supports inserting pictures into the document, and you can also take advantage of this feature to embed PDF into Excel. First, you need to convert the PDF into image format, such as PNG, JPG, etc. Then, the images converted from PDF can be inserted into the Excel document.

This method is relatively complex comparing with the above ones, but it's really suitable for people who want to display the PDF content directly and intuitively.

related articles

Recommendation: >> Convert PDF to Image

How to convert the PDF into image formats? This post will guide you to do that step by step. 

convert pdf to picture

How to Insert PDF into Excel After Converting:

Step 1. Launch Microsoft Excel and go to the "Insert" tab.

Step 2. Click on "Pictures" > "This Device..." to select the converted picture.

Step 3. Double-click the picture you want to insert, and then it will be added to the Excel document.

Special Way: Inserting PDF into Excel - Converting PDF to Excel

This method shows you how to insert a PDF file in Excel with simple steps. However, to deal with a PDF filled with data, the best way is to convert it to Excel directly. Then, you can edit the data in Excel without any hassle.

Tool 1. EaseUS PDF Editor

This alternative method requires a powerful PDF converter to turn Excel into other formats. If you want to find the best PDF converter for beginners, EaseUS PDF Editor is a good choice. This software supports many frequently-used document and image formats, including Word, Excel, PNG, JPG, etc.

Apart from convert PDF to Excel, you can also edit PDF before or after the conversion. Many helpful editing tools are provided. For instance, you can extract images from PDF without a hassle and create many types of PDF forms. It can even allow you to encrypt the PDF with a password so that others will never open it without your permission.

EaseUS PDF Editor

Steps to Convert PDF to Excel Using EaseUS PDF Editor:

Step 1. Launch EaseUS PDF Editor and click on the "Open Files..." button to import the PDF file you want to convert to Excel.

open pdf file

Step 2. Navigate to the "Convert" tab and many options will appear. Select "To Excel" to start the converting.

convert to excel

Step 3. Once done, the converted Excel document will be saved to your computer.

Tool 2. Adobe Acrobat

Adobe Acrobat is a well-known PDF tool for its strong ability to edit and read PDF. Using Adobe to insert PDF is a more desirable way due to its multiple and powerful functions, especially when you want to insert an intact PDF into Excel (Excel only extracts the table from the PDF you choose, other content will be ignored).

Steps to Extract Table from PDF and Convert to Excel:

Step 1. Open Adobe Acrobat.

Step 2. Click on "File," then Export to, hover cursor at "Spreadsheet," and finally, choose "Microsoft Excel Workbook."

adobe converts pdf to excel

Step 3. You should name your file in the pop-up window and choose a saving path for your Excel-format PDF file.

Tip
Open it, and you can see your PDF content is displayed in an Excel spreadsheet. There could be a few problems, including some font size problems or spacing problems.

How to Edit PDF Before Inserting PDF into Excel

If you are interested in editing your PDF files, a practical PDF editor like EaseUS PDF Editor is necessary. 

This software is especially suitable for beginners as its user interface is intuitive so that everyone can utilize it effortlessly. It offers you PDF editing tools ranging from elementary ones to advanced ones. You are able to add or delete text and images in the PDF, even it's a scanned file. To make the inactive scanned PDF editable, this software offers you the OCR function. Besides, it allows you to manage PDF pages with ease, such as adding a watermark or inserting page numbers into the PDF.

How to Edit PDF Before Inserting or Converting:

Step 1. Launch EaseUS PDF Editor and import the PDF file you want to edit. You can click on the "Open Files..." button to do that.

open pdf file

Step 2. If you want to edit the text and images in the PDF, click on the "Edit" button, and there are many options for you. It allows you to insert or remove the words and pictures freely, and you can also adjust the font, size, color of the PDF text. 

edit option

Step 3. More tools are available under the "Pages" option. This versatile software supports deleting, extracting, cropping, rotating the pages with ease. You can add many elements to the PDF, including header & footer, background, watermark, etc.

edit pdf page

Step 4. After editing, you can choose to encrypt the PDF with a password, sign the PDF with an e-signature, or add comments to it. Then, click on the "File" button and select "Save" or "Save As" to preserve the changes you made to the PDF.

save the edited pdf

Conclusion

This post introduces different ways for inserting PDF into Excel. In addition to that, there are some alternative methods you can use to get an Excel document from PDF. Which is the best solution for you? Don't hesitate to have a try.

FAQs About How to Insert PDF into Excel

This part may be helpful if you want to know more about embedding a PDF in Excel.

1. Why can't I insert PDF to Excel?

Possible reasons could be that your worksheet or workbook is locked, your PDF is protected, and your files are damaged or corrupted. And some administrative problems are also responsible too.

2. How to attach PDF to Excel without losing formatting?

Open your Excel, and click "Insert" > "object". You can then create it from a file or insert a PDF file. In this way, you can attach PDF to Excel without format loss.

3. Can you drag and drop PDF to Excel?

It's not functional if you want to drag and drop PDF to your Excel.

4. How to insert more than one PDF file into Excel?

Definitely, you can import multiple PDF files to Excel, but this is not the best way. Using Adobe to combine your PDF files before inserting them is more effective, intuitive, and clearer.

About the Author

author Crystal Chen

Crystal Chen

Crystal Chen is very interested in technology products. Experiencing many technological applications like video editors, screen recorders, and PDF editors, She is willing to solve users' issues through writing tech-related articles. Through her words, you can find various solutions to solve one problem.

Read full bio

You May Be Also Interested in