2022-09-21 16:22:06 • Filed to:
• Proven solutions
PDF (Portable Document Format) can help both individual and business users to share information that can be viewed the same, no matter what kind of program or device it is opened on. If you are looking to insert PDF into excel, here we provide 5 solutions below.
If you don't want to open PDF as a separate file, use Wondershare PDFelement - PDF Editor to convert PDF to Excel and copy the contents from the converted PDF to excel.
You will need to insert the PDF document into your excel document as an object. In some cases, you'll be able to open, view, resize, and even edit the inserted PDF document. Here's how to insert PDF into excel.
After opening an excel document, click the "Insert" > "Object" button in the Text section.
In the pop-up dialog box, go to the "Create from File" tab and use the "Browse" button to select the PDF document that you want to insert.
Select the option of "Display as icon," change the icon display name, then click the "OK" button to complete the process.
What's more, converting PDF to an excel file is another way for you to insert PDF into excel with Wondershare PDFelement - PDF Editor.
Open PDFelement, you can drag and drop a PDF file into it or tap on the "Open PDF" button.
Click the "Convert" > "To Excel" button to convert your PDF document to an excel file. Then you can open the converted excel file to copy the content and paste it into another excel file.
There is another way to insert PDF into Excel you can transfer the PDF into an image. For that, Wondershare PDFelement - PDF Editor can help you convert a PDF document to an image file so that you can insert it into excel directly.
After launching PDFelement, click the "Open PDF" button on the Home window to load your PDF file in it.
Click the "Convert" > "To Image" button to convert the PDF to an image file, and save it in your local folder.
Open the Excel document, and click the "Insert" > "Picture" button to choose the converted image to be inserted from your local folder.
You can embed PDF in Excel through the Hyperlink feature. This is one of the quickest methods to insert the PDF files into an Excel sheet through Excel itself.
Microsoft Excel has a feature that many don't know about. It allows you to add a hyperlink to a picture and the link will help in opening the file as soon as you click on it. Just insert a picture into Excel and then link it to the PDF file you would like to import. To display the PDF file, you have to click on the photo with hyperlink and confirm the choice you made. With this, you don't have to download any software.
Now, here are the steps you have to follow,
Step 1. Open a spreadsheet you prefer. On the 'Insert' tab, you have to click on the 'Pictures' option and insert the image into Excel.
Step 2. Right-click on the picture to Excel and choose 'Link'.
Step 3. Now, you have to select the PDF file and link it to the photo.
For making the link valid, you need to ensure that the Excel workbook and hyper-linked file are placed in the same location, this will keep your link from not working.
In Office 365, you can also import PDF to Excel as a picture. It is one of the quickest ways to insert PDF files into Excel sheets.
Step 1. Open the Excel file that you would like to insert into the PDF.
Step 2. Now, click on 'Insert', 'Pictures, and then 'Picture from File'.
Step 3. Find and double-click on the PDF that you would like to insert into Excel.
When you insert content from a PDF file to an Excel sheet, it will not get any easier than this. Moreover, you can select other file formats, such as images, for placing inside the Excel files.
The above steps are the simplest way to insert PDF into excel as an object. However, if you want to read or edit the PDF document before inserting it into the excel document, you should have a PDF editor program installed on your computer to read and edit the PDF files before or after adding PDF into excel. This is why PDFelement is so widely used. It can help you view, annotate, edit, create, and convert PDF documents quickly and easily.
If you want to annotate or edit a PDF document before or after inserting it into an excel sheet, PDFelement should be the first choice. It provides various tools for you to annotate or make comments in the PDF document. Additionally, it also enables you to edit PDF text as easily as possible.
PDFelement also enables you to add an Excel document into a PDF document if you want to display data within your PDF file. After opening a PDF document with PDFelement, you can click the "Comment">"Attachment" button to browse an excel document to add.