In this tutorial we are going to explain how to insert PDF files into Excel documents. Inserting is not the same as converting PDFs into Excel. If you want to convert PDF documents into Excel, you can use Cometdocs or our specialized websites for free PDF to Excel conversion like http://www.convertpdftoexcel.net/ or http://www.pdftoxlsconverter.com/.
Inserting PDFs into Excel can be useful if you want to send someone an Excel document with a corresponding PDF file. For example, you might want to send a PDF to support data you have presented in an Excel spreadsheet so that the person opening the Excel document will have a PDF file to explain the data in the spreadsheet.
Also, while working on an Excel spreadsheet analysis, you might want to insert a PDF file as a note or a reference to yourself. It could be useful to have a shortcut in your spreadsheet to the data source so that you don’t have to go to Windows Explorer each time to find a specific PDF document.
So, here is how you do it:
First, go to Ms Excel and click on Insert – Object
Then choose the type of Object, in this case we have Adobe Acrobat PDF document. Another option is to choose Display as icon if you want the PDF file to be represented with an Adobe PDF icon, not as a whole page.
If you don’t choose this option, only the first page of the PDF file will be shown.
When you click on the Adobe PDF icon now, the inserted document will open. Just be careful not to insert too many PDFs into your Excel spreadsheet, which could make the file extremely bulky and slow.