To read or edit the inserted PDF, you will need a PDF reader or PDF editor installed on the computer. Microsoft Office allows you to easily insert PDF into Excel, be it a single-page or multiple-page PDF, as an attachment.

How to Insert a One-page or Multiple-page PDF into Excel Right-click and select Copy or Copy Image. If it’s an image, click to select the image. Open the PDF file using Adobe Reader or other software. Instead of choosing to insert PDF into Excel as attachment, you can use the following steps to insert the selected PDF contents.

Time-consuming and tedious if there are lots of images or tables to insert.

Copying and pasting tables will lose all formatting.

Can’t apply to scanned or image-based PDFs.

If the PDF file is in a foreign language such as Spanish, just select Spanish from the language list.

For example, to extract the text from a scanned PDF, just switch on the OCR button and select DOCX, DOC or TXT as the output format. This is especially useful if the PDF is scanned/image-based and not selectable.

Extract (scanned) PDF text to insert into Excel.

The layout and formatting will be kept, as you can tell from the comparison below. You can easily copy the tables from the converted Excel file to your Excel workbook. For example, to extract the tables on page 2 of a PDF file, just switch on the OCR button, select page, and select Excel as the output format. It works for both native searchable PDFs and scanned/image-based PDFs. This can be helpful if you don’t want to insert PDF into Excel as an attachment but only need to insert PDF’s tables.

Extract PDF tables to insert into Excel.

The images are named after the page numbers. The extracted images from a PDF file will be kept in an automatically created folder which is named after the PDF file.

Extract PDF images to insert into Excelįor example, to extract all the images on page 2-10 of PDF file A and the images on page 38 of PDF file B, just switch off the OCR button, separately select the PDF pages, and select the desired image format.

Step 3Start extracting images, tables or text from PDF

How to make a table on excel for a mac