How to Copy & Paste PDFs to Excel

A PDF's content can be displayed in programs other than Adobe Reader, including Excel. Adobe Reader allows you to copy PDF content, with custom options for the copying method, which you can paste into an Excel document to illustrate a report. You can copy the entire PDF to your clipboard or use the Snapshot tool to marquee a smaller area. Pasting the PDF as an image allows you to preserve its formatting without modifying its contents. If you need to modify the PDF in Excel, you should paste it as editable data instead.

...

Copy to Clipboard as Image

Step

Open the PDF document you're copying in Adobe Reader.

Step

Select "Edit" and "Copy File to Clipboard" from the toolbar.

Step

Minimize Adobe Reader and skip to the "Paste PDF" section below.

Copy Selected Area as Image

Step

Click the Snapshot tool in the toolbar in Adobe Reader.

Step

Drag your mouse over the area you want to copy in the PDF. The selected area is highlighted.

Step

Click "OK" at the prompt, "The selected area has been copied."

Step

Minimize Adobe and skip to the "Paste PDF" section.

Copy as Editable Data

Step

Select "Edit" and "Select All" from the toolbar or highlight the data you want to copy.

Step

Select "Edit" and "Copy" from the toolbar.

Step

Minimize Adobe Reader and open the Excel worksheet.

Paste PDF

Step

Open a new or existing worksheet in Excel.

Step

Click the cell where you want the PDF to appear.

Step

Press "CTRL+V" to paste the PDF as an image or editable data.