[2022] How to Insert PDF into Excel Spreadsheet on Mac or Windows?

Rosa Reyes
time June 22, 2022 Preview 21.8K
share it facebook share it Twitter

Inserting PDF into Excel is the best way to supplement an Excel spreadsheet with PDF resources, this saves our time and troubles to switch between different files, to retype a document. Copying and pasting a PDF into Excel might work, but it is not an efficient solution.

Therefore, we will show you 5 good methods to insert PDF into Excel spreadsheet on Mac and Windows PC, instructions in this article are very easy to follow.

Insert PDF into Excel with Good Formatting

The PDF you want to insert into Excel may have well-formatted tables, images or texts, if you want to maintain the formatting, fitting the cells from your PDF well into the Excel file, the most efficient way is to convert PDF to Excel first, then insert. In addition, such a conversion usually supports batch transformation and OCR scanned PDFs as well. To make this, we have to find ourselves a dedicated PDF to Excel converter.

On Mac

Software like Cisdem PDF Converter OCR for Mac can convert and insert PDFs with high efficiency. It is an all-around tool to convert PDF to Excel, Word, PowerPoint, Keynote, text, EPUB, etc., perform OCR on PDFs and images, extract images from PDFs, create PDFs from other files and do other cool things.

Main Features of Cisdem PDF Converter OCR

  • Extract table, image, or text from PDF for easy insertion to Excel
  • Convert native and protected PDF to Excel, Word, PPT, Txt, total 16 formats
  • OCR to Excel and other searchable/editable file
  • Keep the original layout and quality
  • Allow batch conversion and OCR
  • Create PDF from Word, PowerPoint or other documents
  • Merge, compress and protect PDF output

How to Insert PDF into Excel on Mac?

  • Step 1. Download and install Cisdem PDF Converter OCR on your Mac. Launch it.
    Free Download
  • Step 2. Add the PDF files to this app by dragging and dropping.add pdf files
  • Step 3. Start converting PDF to Excel and get ready for insertion.
    Switch on the OCR button, select page and choose Excel as the output format. Click "Convert". insert pdf to excel cisdem 03
  • Step 4. Insert PDF into Excel on Mac now.
    Directly insert the entire Excel spreadsheet to your file,or copy and paste part of the document to Excel cells. The layout and formatting will be kept, as you can tell from the comparison below.comparison

On Windows

If you are a Windows PC user, you can use Tipard PDF Converter Platinum to insert PDF into Excel on your PC. It is a Windows application to convert PDF to Excel, Word, PowerPoint, HTML, and more. It comes with the OCR feature too, allowing users extract data from scanned PDF or image. In addition, you can rename the files and convert multiple files in batch to save time.

  • Step 1. Open the software on your PC. Drag and drop the PDFs into Tipard.insert pdf to excel windows 01
  • Step 2. Once the file is imported, choose output as Excel format.insert pdf to excel windows 02
  • Step 3. Once the conversion process is finished, you can insert the whole document to Excel spreadsheet or just copy and paste part of the file to Excel cells.

How to Insert a One-page or Multiple-page PDF into Excel as Object

Microsoft Office allows you to easily insert PDF into Excel, be it a single-page or multiple-page PDF, as an object. To read or edit the inserted PDF, you will need a PDF reader or PDF editor installed on the computer. However, you can only insert PDF as object on a PC. The object-embedding feature of Microsoft Office for Mac is limited.

  • Step 1. Open an Excel file using Microsoft Excel. On the Insert menu, click "Object".insert pdf into excel as object
  • Step 2. In the Object dialog box, click the "Create from File" tab. Click "Browse". Select the PDF file that you want to insert. Click "Open".the insert object dialog box
  • Step 3. Click "OK". The first page of the PDF will appear in your worksheet. Double-click this page, and the PDF will be opened by the associated app on your computer.

Tip: If it’s a multiple-page PDF, people who read this Excel file may not know that they can access the rest of the pages by double-clicking. In a case like this, you can add a note to let them know.

Cannot Insert as Object? Insert PDF into Excel as Image

Mac users could have problems when they try to insert a PDF into Excel using the Insert Object feature. In this case, you can only insert PDF into Excel as image. 

  • Step 1. Open Microsoft Excel on your Mac. Open an Excel workbook.
  • Step 2. Drag the PDF you want to insert into Excel. If it’s a single-page PDF, you will find the PDF inserted into a worksheet as an image. Or you can go to Insert>Pictures to import PDF as image to your Excel file.

If it’s a multi-page PDF, a dialog box will appear, asking you to select the specific page you need to insert. Select a page and click "Insert". To insert multiple PDF pages, just repeat the process.

If the inserted PDF appears as the preview of the first page, it will take a lot of space in a worksheet. The good news is you can insert PDF into Excel as an icon or a link. Below is how.

  • Step 1. Open an Excel file using Microsoft Excel, click "Object".
  • Step 2. Click the "Create from File" tab, you can find two options in the dialog box. One is Link to file, and the other is Display as icon.
    If you select the checkbox Link to file, you will insert a hyperlink pointing to a location (where the PDF file is kept) on your local disk. In this case, the PDF file is not stored in the Excel workbook but on your computer’s internal disk. If you delete the PDF file on your computer later, or if the Excel workbook is opened on a different computer where the PDF file doesn’t exist, the link will be broken.insert pdf into excel as icon

Tip: Make the Inserted PDF Fit into and Stick to an Excel Cell

When you insert PDF into Excel and display it as an icon, the icon will appear above the Excel cells. Its position won’t change as you add or remove cells above it. It won’t get hidden, sorted or filtered with the Excel cells. This can cause inconvenience sometimes. How do I insert a PDF file into an Excel cell and make it stick to the cell? The solution is easy.

  • Step 1. Place the PDF file icon into a cell by resizing the cell.
  • Step 2. Right-click on the icon. Select Format Object.
  • Step 3. Go to the Properties tab and select the Move and size with cells option.insert pdf into excel and make it fit into excel cell

How to Insert PDF into Excel with Office 365?

Excel doesn’t only offer desktop and mobile version, but also allows users to access its features online with a Microsoft 365 subscription. If you use Microsoft 365 to edit Microsoft documents online, you can insert PDF into Excel with 365 too. But before insertion, you have to convert PDF to image format first.

  1. Go to smallpdf or other PDF to Image converter, upload your PDFs and save as image first, it can be JPG or PNG.
  2. Login into your Microsoft 365 account.
  3. Go to Excel, drag and drop the Excel file that you want to insert a PDF.insert pdf to excel 365 login
  4. Then go to Insert>Pictures>This Device, import the images converted from your PDF to Excel 365.insert pdf to excel 365
  5. Go to File and click Save as.

Conclusion

When you insert PDF into Excel, you can choose to insert as it as an object and display it as an icon/link, or as images, or only insert the selected images, tables and text from the PDF. It all depends on your needs. After the PDF file or its content is inserted, you can conveniently use it for reference or for presentation use.

avatar
Rosa Reyes
share it facebook share it Twitter

Rosa has worked in Mac software industry for more than eight years. She believes that the purpose of software is to make life better and work more productively. In addition to writing, Rosa is also an avid runner.

share it facebook share it Twitter
Comments (0) Leave a Reply

Name *

Comment *

Hot Articles

6 Ways to Reduce PDF File Size on Mac without Losing Quality How to Convert PDF to JPG on Mac: 5 Ways, Support Multi-Page PDF 6 Quick Ways to Convert PDF to Keynote on Mac 2022
Home > [2022] How to Insert PDF into Excel Spreadsheet on Mac or Windows?