How to Copy from PDF to Excel Table (2 Suitable Ways)

Get FREE Advanced Excel Exercises with Solutions!

PDFs are useful for distributing and archiving data. Unfortunately, it is difficult to change data in a PDF table or chart. Sometimes, we may want to examine or sort the data in a PDF. Microsoft Excel has various tools for sorting and calculating data. As a result, copying data from a PDF to Excel may be advantageous. This article will demonstrate all possible effective ways to copy from PDF to Excel table.


Download Practice Workbook

You can download the workbook and practice with them.


2 Effective Approaches to Copy from PDF to Excel Table

There seem to be various reasons that someone would want to transfer files from a PDF file to a Workbook. We may use this to prevent individually typing the information from the PDF into each cell.

For describing the approaches to copying tables from PDF to Excel tables, we consider the following information on a PDF. So, the information is a company’s employee details. The Employee Name, Join Date, Resign Date, and Total Working Year for this company. Now, suppose we want some changes to that. But we have only the PDF file, and we all know that we can not edit any PDF file. For this, we need to take this table on pdf to excel.

2 Effective Approaches to Copy from PDF to Excel Table


1. Use Data Tab to Copy Table from PDF to Excel

The Data tool is a property for reorganizing and categorizing data in Excel, as well as converting daily data to monthly or seasonal data. This is the best solution for copying tables from pdf to excel. We have to follow some steps for this. Let’s see the procedures down.

STEPS:

  • Firstly, go to the Data tab from the ribbon.
  • Secondly, select Get Data, under the Get & Transform Data category.

2 Effective Approaches to Copy from PDF to Excel Table

  • This will appear in a drop-down menu bar, from there go to From File.
  • Next, click on From PDF.

2 Effective Approaches to Copy from PDF to Excel Table

  • This will open up the Import Data dialog box.
  • After that, go to the PDF file location, and select the PDF file.
  • Then, click on Import.

2 Effective Approaches to Copy from PDF to Excel Table

  • This may take some time to open the Navigator.
  • Now, from the Navigator, select the table that you want to open up on the excel file.
  • Further, click on the Load button.

2 Effective Approaches to Copy from PDF to Excel Table

  • And, that’s it! The table that you want to copy, is now duplicated in the excel file.

  • Here, if you want to make any changes, you can do that.

Read More: Copy Table from PDF to Excel with Formatting (2 Effective Ways)


Similar Readings


2. Convert the PDF into a Word Document to Copy Table

Microsoft Word is a portable document editor that you can use on the move. Composing and editing are not limited to the workplace. We can copy a table from PDF to excel with the help of a word file. This may be a lengthy process and couldn’t give you the best result you wanted. But this will work. Let’s look at the procedures for this.

STEPS:

  • In the first place, open your word document and go to the File tab from the ribbon.

  • Then, select Open and click on This PC.

2 Effective Approaches to Copy from PDF to Excel Table

  • This will take you to the computer directory.
  • Instead of doing this, you can press Ctrl + O to open the computer directory.
  • Now, go to the location where your PDF file is located.
  • After that, select the PDF file and click on the Open button to open the file in the Word document window.

2 Effective Approaches to Copy from PDF to Excel Table

  • A Microsoft Word message will appear. Click OK to proceed.

  • By following the above steps, you can see the pdf file is now open in your Word document window.

  • Further, select the table that you wish to copy by pressing Ctrl + C.

  • Furthermore, open your Excel file and paste the table by pressing Ctrl + V on your keyboard.
  • Finally, you will be able to see that the table is copied. It may not look that good. But it’s better than just normal copying directly from the PDF.

Read More: How to Convert PDF to Excel without Losing Formatting (2 Easy Ways)


Conclusion

The above methods will assist you to Copy from PDF to Excel Table. I hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!


Related Articles

Sabrina Ayon

Sabrina Ayon

Hi there! This is Sabrina Ayon. I'm really excited to welcome you to my profile. Currently, I'm working in SOFTEKO as a Team Leader. I'm a graduate in BSc in Computer Science and Engineering from United International University. I love working with computers and solving problems. I’ve always been interested in research and development. Here I post articles related to Microsoft Excel. Hoped this may help you. Thank you.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo