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.
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.
- This will appear in a drop-down menu bar, from there go to From File.
- Next, click on From PDF.
- 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.
- 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.
- 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.
- 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.
- 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