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.


How to Copy from PDF to Excel Table: 2 Effective Approaches

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. 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 Copy and Paste from PDF to Excel


Download Practice Workbook

You can download the workbook and practice with them.


Conclusion

The above methods will assist you in copying from a PDF to an Excel table. I hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section.


Related Articles

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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo