This article shares 4 ways to walk you through how to open PDF in Excel. You can open the PDF as a hyperlink, an object, or an Excel spreadsheet, or open just the tables of the PDF. Read on to learn the step-by-step guides.
The functionality and method to open PDFs in different Excel versions (Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, Excel 2010, and the web Excel) on Windows or Mac are almost the same. Only very slightly different in the navigation interface and a few options names.
Open PDF in Excel by Inserting a Hyperlink
Microsoft Excel allows its users to insert a hyperlink to open a PDF in Excel for free. It supports creating a link to a PDF stored on your computer or published on the web. When you click a hyperlink, the PDF will open in a default PDF reader. You can also insert links to Word, Excel, video and nearly any files in Excel and open them the same way.
Without further ado, take a look at the several steps to open PDF in Excel via a hyperlink.
Step 1: Open your Excel file, type a hyperlink name into the cell where you want to put a PDF;
Step 2: Select the cell, go to the Insert tab and choose Link in the drop-down bar;
Step 3: Enter the PDF file address, or browse your device to choose a PDF and insert it as a hyperlink;
Step 4: Click on the hyperlink to redirect and open the PDF in Excel.
Open PDF in Excel by Inserting an Object
You can also open a PDF in Excel by inserting the PDF as an object. The inserted object will connect the PDF file and the Excel file. When double-clicking the object, the PDF opens in the default PDF reader on your computer. The PDF file will be the most up-to-date even if you have made changes to the source file. Microsoft Excel allows you to insert any other file like PowerPoint, image, Word and music as an object to Excel if needed.
In terms of how to open a PDF in Excel, here is a simple guide.
Step 1: Open your Excel spreadsheet, tap on Insert and choose the Object option;
Step 2: Click Create from File and hit Browse to select a PDF to insert and hit OK;
Step 3: Move and resize the object according to your need, then double-click on it to open your PDF in Excel.
Open PDF in Excel as Excel Sheets
An effective way to open a PDF in Excel is to convert the PDF to an Excel file and add the converted Excel sheets to another Excel workbook. So you are able to open the PDF as normal Excel sheets. With the help of a PDF to Excel converter, SwifDoo PDF, you can effortlessly convert any PDF to Excel format. It can convert multiple PDFs in one go. The software is capable of converting scanned PDFs to Word, Excel or other editable files.
Check how to open a PDF in Excel by converting PDF to Excel.
Step 1: Open a PDF file in SwifDoo PDF, click Convert on the top and choose PDF to Excel in the secondary toolbar;
Step 2: Specify a location for saving the converted file in the pop-up dialogue box, and click Start to start the PDF to Excel conversion;
Step 3: Open the resulting Excel file and move or copy the necessary sheets to another opened Excel workbook;
Step 4: Open PDF content in Excel by opening the added Excel sheets.
Besides the desktop application, a free online PDF to Excel converter allows you to do the conversion for free. If you wish to open PDF pages in Excel as pictures, both the offline and online converters enable you to convert PDF to image format without breaking a sweat.
Open PDF in Excel as an Image
You can also convert your PDF to an image and insert the image into your Excel file. This way every time you open the spreadsheet, you open the PDF image in Excel as well. This is a method worth considering if your PDF has just a few pages. Take a look at how SwifDoo PDF makes it possible to open PDF in Excel in several steps.
Step 1: Download SwifDoo PDF and open your PDF with it;
Step 2: Tap Convert on the top to choose PDF to Image;
Step 3: Specify a saving location and click Convert;
Step 4: Open your Excel file, and insert the image created from the PDF. The next time you open the Excel sheet, you open the PDF in Excel.
Open PDF Table in Excel
If you just need to view the tables in a PDF from Excel, you can open only the tables instead of the entire file. Microsoft Excel has the wonderful feature to import tables from a PDF into Excel. By utilizing this feature, open a PDF in Excel without unwanted content, redirecting or switching programs.
Step 1: Open your Excel file, and go to the Data tab;
Step 2: Choose Get Data in the drop-down menu, select From File and pick From PDF;
Step 3: Select a PDF to import, choose the displayed table or page you need and load it to Excel;
Step 4: Every time once you open the Excel file, you open the PDF table in Excel.
Fix You Cannot Open Embedded PDF in Excel
When you can't open an embedded PDF in Excel, try the several introduced workarounds and see the possible reasons.
- Check if the source PDF file in Excel is corrupted, moved or removed. Open the PDF file with a good PDF reader to test. If the PDF is moved or deleted, the embedded link becomes invalid and you cannot open it.
- If clicking the PDF hyperlink won’t open the PDF file in Excel, right-click on the link and choose “Edit Hyperlink” to check if you correctly added the hyperlink or the file address. You can only open a PDF in Excel when the file address or hyperlink is complete and correct.
- If the hyperlink in Excel is linked to a PDF on your computer, then others cannot open it from their devices. You can insert the PDF as an object so any others can open from a different place.
- To open a PDF in Excel as a full version, make sure you have a PDF reader installed on your device and the default PDF reader works without any problem. Update the PDF reader or change the default PDF reader by going to “Windows settings” > “Apps” > “Default apps” > “set default apps by file type”.
- Remove the view protection. When you open PDF files in an Excel spreadsheet with protected views, you cannot open them. Open the Excel file, navigate to “File” > “Options” > “Trust Center” > “Trust Center Settings” > “Protected View”, and uncheck the protected view options. Then try opening your PDFs in Excel.
Can you open a PDF in Excel? For quick access to more information related your Excel file, you can either insert a hyperlink or an object to open a PDF document in Excel. The truth is that you cannot open PDFs with Excel itself and need to embed it as a link or an object.
In addition, many Excel users prefer to open a PDF attachment in Excel as an Excel file. That means you can convert a PDF to a high-quality Excel file with OCR using a PDF application like SwifDoo PDF. It is one of the best alternatives to Adobe Acrobat. Add the converted Excel file to another to open the PDF content more straightforwardly.