How to Copy and Paste From PDF to Excel (3 Examples)

Method 1 – Importing Data From PDF to Excel


  • Open an Excel file.
  • Go to the Data tab on the Ribbon.
  • Select the Get Data option from the Get & Transform Data section.

  • Choose the From File option followed by From PDF.

Importing Data from PDF to Excel to Copy and Paste from PDF to Excel

  • Select the PDF file from your computer.
  • Click on Import.

  • Select Page 1 of the PDF in the Navigator dialog box and click on Load.

  • Your Excel file should look like the screenshot below.

Gathering Data from PDF to Excel to Copy and Paste from PDF to Excel

Read More: How to Copy from PDF to Excel and Keep Columns

Method 2 – Directly Copying from PDF to Excel


  • Open the PDF file you want to convert into Excel.
  • Use Ctrl+A or the mouse cursor to select all the content.

Directly Copy from PDF to Excel

  • Open a blank Excel spreadsheet.
  • Right-click on any cell to launch the Context Menu.
  • Select Paste Special from the options.

  • Select Paste As Text in the Paste Special window and click on OK.

  • All the content will be pasted in a single column, without any formatting, as pictured below.

Alternatively, you can use Ctrl+V to supersede some steps after furnishing the copied data according to your requirements.

Note that this method is not suitable for converting large or crowded PDFs into Excel files.

Read More: How to Copy from PDF to Excel Table

Method 3 – Using Microsoft Word to Extract Data From PDF to Excel

The hardest part of handling a PDF file is editing or reformatting it. To gain a better outcome from PDF files, you have to make them editable before copying and pasting them into Excel Spreadsheets. In that case, Microsoft Word can be used as a mediatory tool.


  • Launch Microsoft Word.
  • Go to the File tab on the Ribbon.
  • Select Open.
  • Click on Browse to select your PDF file.

  • Select the appropriate PDF file from your device directory and click on Open.

Using Microsoft Word to Copy and Paste from PDF to Excel

  • Click OK on the pop-up warning.

  • Wait for Microsoft Word to open the content in an editable Word document.

  • Use Ctrl+A or your mouse cursor to select the entire content.
  • Press Ctrl+C or select Copy from the Context Menu.

  • Open a blank Excel Spreadsheet and press Ctrl+V or click on Paste.

Utilize Microsoft Word to Copy and Paste from PDF to Excel

Things to Remember

  • Only when the data can be copied into a table in a PDF file can you extract the data from PDF to Excel.
  • One column or cell may include all the data that was copied and pasted from the PDF to Excel. However, the data must be cleaned up before being properly organized.

Download Practice Workbook

Feel free to download the practice workbook below.

Related Articles

<< Go Back to Import PDF to Excel | Importing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

  1. This really helped me alot, thank you 🙂

    • Dear Kirsten Wheeler,

      Thanks for your appreciation. To get solutions with detailed explanations, follow ExcelDemy.

      Shamima Sultana
      Project Manager | ExcelDemy

Leave a reply

Advanced Excel Exercises with Solutions PDF