Can you open a PDF file in Excel? No. A PDF file can’t be directly opened in Excel since the PDF format is not supported by Excel. Luckily, there are several workarounds that enable you to open PDF in Excel. Read on and learn about all the methods to open PDF in Excel 2021/2019/2016/2013/2010/2007. Show
Method 1. How to Open PDF in Excel and EditThe first method is to convert the PDF file to Excel format so that it can be opened in Excel. All you need is a PDF editor that can easily turn PDF into Excel. Wondershare PDFelement - PDF Editor can not only edit PDF files, but convert PDF to editable Excel, Word, TXT, and more. With OCR support, it can convert scanned PDF to Excel files so that you can open and edit them in Excel. Step 1. Load PDFOpen PDFelement and click on the "+" button on the Home screen. There you can select a PDF to open it. Step 2. Open PDF in ExcelClick the "To Excel" button in the "Convert" menu to start the conversion. Step 3. Adjust the conversionThe system will immediately display a conversion window. You can select the folder where you want to save the converted file. Besides, you can also change some settings by clicking the "Settings" button. Click "Apply" and then "Save" when done. After that, you can open the excel file directly. PDFelement is an Excellent PDF solution tool that has garnered millions of users across the continents. The program provides an easy, quick, and affordable way to create magnificent PDF files and forms. You can convert multiple PDF files at the same time, thus preventing unnecessary processing queues. Download PDFelement today and get the PDF experience you have always yearned for all this while. Main features
Video on How to Open PDF in Excel
Method 2. Open PDF File Attached in ExcelAlthough Microsoft Excel can't open a PDF file directly, you can attach a PDF file in an Excel spreadsheet as a hyperlink so that the PDF file will be opened from Excel whenever someone clicks the link. Step 1. Add a PDF File to ExcelRight-click the cell that you want to attach the PDF, select Link (Hyperlink if you are using Excel 2010 or older.) Select Existing File or Web Page and choose the PDF file you want to open. Click OK to confirm. Step 2. Open PDF File in ExcelNow to open the PDF file in Excel, just click the cell and the attached file will be opened. Method 3. Open PDF File Embedded in ExcelThere is another way to help you open PDF in excel that is inserting a PDF file in the excel file as an object. Step 1. Open ExcelOpen your target excel file first, then click the "Insert" > "Object" button. Step 2. Insert PDFSelect the "Create from File" tab, then click the "Browse" button to select your target PDF file. And you can select the option of "Display as an Icon" in the excel file. When you want to open embedded PDF in excel, you can double click the PDF document, and it will be opened by your default PDF program directly. Method 4. Open PDF in Excel (Office 365)If you are an Office 365 user, you can easily open data from a PDF file in Excel. Here are the steps. Step 1. Open an Excel sheet, go to Data > Get Data. In the dropout menu, select From File > PDF File. Step 2. Select a PDF file you want to open and click Import. Then all pages and tables in the PDF file will be imported. Find the page or table you want to open in Excel and click Load to open the page in Excel. Method 5. Open PDF in Excel with PDF Converter ProWondershare PDF Converter Pro is the PDF tool we will use to open PDF in Excel. It can convert any format to PDF format and vice versa. It also has a simultaneous conversion to save you time. Both Windows and Mac versions work well. Below we will take the Windows version as an example and show you how to open PDF in Excel. Step 1. Import PDF filesLaunch Wondershare PDF Converter Pro on your Windows PC. It is fully compatible with Windows 10, Windows 8, Windows 7, Windows XP, and Windows Vista. After launching, click "Add PDF Files" in the primary window to search your computer for the PDF files you want to open in Excel. After finding them, add them to this PDF application. To do more in a short time, I recommend you to add a list of PDF files for simultaneous conversion. Up to 200 PDF files are supported at the same time. Step 2. Set Advanced Preferences to PDF to ExcelClick the small "Advanced Setting" button on the top right corner of the primary window. In the newly populated window you can choose:
Step 3. Open PDF in ExcelBefore you open PDF in Excel, you can select specific PDF pages or page ranges to open. Click the selected pages column in each PDF item bar. From here, you can choose PDF pages, or PDF page ranges that you will open. Click on "Convert" to see the PDF to Excel conversion. Then a small folder icon appears on each PDF item bar, click to open the output folder. And then, you can open these output documents with Microsoft Excel. FAQ: How to Fix Embedded PDF Documents Not Opening in ExcelWhen clicking on the attached PDF document in Excel, the file can't open and give you an error: Cannot start the source application for this object. If this is the problem you are having, here are 2 tips that may help you. 1. Change Protected View Open the Excel file, click File > Options > Trust Center > Trust Center Settings > Protected View, and uncheck these options: Enable Protected View for Files originating from the Internet, Enable Protected View for Files located in potentially unsafe locations, Enable Protected View for Outlook attachments. Also, uncheck the option in Privacy -- Microsoft Office documents that are from or link to suspicious Web sites. 2. Update Your PDF Reader Make sure your PDF reader is updated to the newest version. If this is still not working, install another PDF reader, such as Wondershare PDFelement - PDF Editor or Wondershare PDF Reader. Free Download or Buy PDFelement right now! Free Download or Buy PDFelement right now! Buy PDFelement right now! Buy PDFelement right now! |